The Heap™ – Consultancy ©®

« first day (2189 days earlier) ← previous day next day → last day (2683 days later) »

Erwin Brandstetter

2:49 AM

Happy New Year, to all Heapers! I hope for good questions in 2017.

10 hours later…

ConcernedOfTunbridgeWells

12:30 PM

@EvanCarroll What for - Samba?

Try pam_winbind if you haven't already.

9 hours later…

Evan Carroll

9:39 PM

No, I want to auth windows against my linux system users.

Evan Carroll

10:09 PM

fucking PostgreSQL online blog.

There is a special place in hell for blogs that wait to tell you the post you're commenting on is too old until AFTER you submit the comment.

Evan Carroll

10:47 PM

you learn so much by looking at old code.

Evan Carroll

11:05 PM

Q: Why is array_agg() slower than the SQL equivalent?

I was just reviewing some old code written for pre-8.4 PostgreSQL, and I saw something really nifty. I remember having a custom function do some of this back in the day, but I forgot what pre-array_agg() looked like. For review, modern aggregation is written like this. SELECT array_agg(x ORDER B...