The Heap™ – Consultancy ©®

3:25 AM

android.stackexchange.com/a/197184/7425 well that was fun

3:37 AM

There are more people that are Socratic on StackOverflow, than inquisitive on SuperUser

Damn.

That tells you something about how damn big and devoted and necessary SO is.

5 hours later…

8:33 AM

morning (late)

Tom V

8:46 AM

aloiskraus.wordpress.com/2018/06/16/…

A: PostgreSQL boost speed on select of 120M rows

8:57 AM

Proper indices. Withou an index it is a table scan. Head over to https://use-the-index-luke.com/ and read it. Better hardware. If your hardware can pull in 20 gigabyte per second then yes, you can brute force that. Not THAT hard (epyc motherboard, number of u2 based SSD).

surprisingly, no mention of phones

otherwise, please VtC the question as it lakhs all details

9:23 AM

@TomV nasty

@ypercubeᵀᴹ I think you would enjoy Kerbal Space Program.

ypercubeᵀᴹ

@ConcernedOfTunbridgeWells I'm afraid I might get hooked on it ;)

9:47 AM

@ypercubeᵀᴹ Be very afraid.

They've just released their first DLC pack as well.

It's loads of fun if you're of a certain level of geekiness. In related news, Rutgers University Press has just released a reprint of Ignition.

Of course it's sold out.

10:15 AM

This upsets me greatly. There's an ARM CPU instruction that does a JavaScripty-targetted operation infocenter.arm.com/help/index.jsp?topic=/com.arm.doc.dui0801g/…

When will the madness end?

@Philᵀᴹ has a PFY?

@ConcernedOfTunbridgeWells I have two

Fabulous. Try not to traumatise them too much.

Too late

I liked the ARM2 instruction set. 27,000 gates. Occasionally I think I should have bought an Archimedes in 1990.

We have the worst of all possible worlds now. Desktop software ecosystem tied to a particular ISA and software running on multiple, deep layers of abstraction.

10:19 AM

Yeah, I think the same. A friend had a personal one I was jealous of. I had an Amiga at home. Used Arcs at school

I saved up my sheckels and bought a PC with a 386SX CPU instead. My left brain says it was the right thing to do. My right brain doesn't necessarily agree.

However, by 1992 I could run Linux on it.

I went for the PC after. Can't remember if it was a Pentium 60 or 75

My alma mater bought all of Sun Australia's old trade-ins and converted them to X terminals. They also got the old shoeboxes and flogged them off. I got two 300MB drives and pimped out my PC with them.

5.25" full height. I had to buy a tower case to put them in.

@Philᵀᴹ I got a 486 around 1995 and scored a 17" monitor in an auction. That ran Linux quite sweetly, although I had enough dependency on Windows to set it up as a dual boot.

There's a massive divide in qualifications now. Some Universities seem to be offering Software Engineering degrees that are basically just youtube courses churning out the latest fads. CS degrees are a far cry from it

Bloody kids

I'm quite sad at what qualifies for a master's degree at quite respectable universities here these days.

10:25 AM

Makes me chuckle. All this containers nonsense. FreeBSD jails and Solaris zones all over again 😂

Having said that, back when I were a lad and did my degree, about 90% of the students in the networking paper couldn't do binary arithmetic well enough to calculate a subnet mask.

@Philᵀᴹ There haven't been a lot of new ideas in systems programming for quite a while. UCB shut down the CSRG nearly two decades ago.

Uphill both ways, etc.

I wish ZFS had become more mainstream. Another Oracle mess

@Philᵀᴹ I think Oracle are perhaps the only traditional IT company that manage to out-bellend Microsoft. With the possible exception of CA.

10:51 AM

At least Microsoft are trying to change

11:02 AM

Yes. They're less full of themselves now that they can see mobile tech undercutting a large chunk of their market.

11:40 AM

@ConcernedOfTunbridgeWells I still remember getting up at home at semi-regular intervals to check if the kernel compilation already finished (was a 386). Weeks after that, to provide printer support on the server in a small molecular biology lab, I thought 'OK, I'll start compilation, go for a coffee and see how it is proceeding' - but by the time the others also stopped working (less than 5 minutes), it was done. That was progress.

Q: How do I CREATE a table only if it doesn't exist in PostgreSQL?

11:53 AM

dba.stackexchange.com/users/152404/codename-k the guy has some very basic questions (some of which are part of all possible SQL101 tutorials). Should we (lovingly) tell them to RTFM and such?

like this:

-2

This is the way to create a new table in PostgreSQL, CREATE TABLE foo ( foo_id int PRIMARY KEY, bar text, ); How do I do this if it needs to check if the table already exists and to proceed with the CREATE only if one is not found?

12:17 PM

If there isn't a previous question & answer, I don't see a problem with it. Assuming our end goal is to document all database things ever

1:02 PM

Apr 5 '17 at 2:37, by Paul White

Dec 9 '16 at 19:18, by Paul White

Personal view (mod hat off) is that basic questions should be allowed, but the quality bar would need to be as high (perhaps higher) than for more advanced questions.

1:16 PM

my concern is in a smaller part about the individual questions, but mostly about nudging the person to read stuff

Andy K

1:29 PM

quick question

let's say I have a column A and another column B on a tabke

I want to have column A as unique and column B unique as well

if I was doing a composite PK

it would be something like that

PRIMARY KEY namePK (A,B)

but it would allowed me something like that

A,B
A,C

I want to be sure that if A exist, it will not allow to write anythng else

that will have A as value in column A

Simon Righarts

Have a separate unique index just on column A?

Andy K

that would work

ypercubeᵀᴹ

and another unique index on B

1:49 PM

@SimonRigharts hah, you. Long time no see!

1 hour later…

3:07 PM

I have a question, maybe I will ask on dba.se

If a backup is moved to a different server and restored, would msdb.restorehistory.backup_start_date still contain the actual date the backup was taken from?

i.e. I presume this is ultimately from metadata held in the backup files.

This is on SQL Server.

3:21 PM

@dezso It's a while since I had to build a custom kernel - the last time I did that would have been sometime in the early 2000's.

3:33 PM

@ConcernedOfTunbridgeWells the story happened in about 2003

Andy K

see ya

@dezso I don't think that's a bad question I can see linking to that when people have a problem there. A better critique would be what do you do with RDBMS-extensions of SQL that cross db-boundaries. Like for instance, IF NOT EXISTS is supported by at least MySQL. Should that question be opened then to MySQL and MariaDB -- since they'll be doing it the same way? Or should it be specific to Pg?

3:49 PM

@EvanCarroll once again, my main problem is not the question (however it is not a very sophisticated one), but that with 3 seconds and typing 'postgresql create table' into a search box they would have found the answer.

But their answer isn't as good as mine and we're more awesome and should have the answer ourselves. =)

And God said, "go forth and multiply fruits like a cancer amongst the Google."

That's what I imagine he would have said anyway.

@EvanCarroll that happens only when he is sitting in the Temple OS

4:11 PM

hahahha

4 hours later…