News for hackers. Stuff that matters.
Re:Debugging PostgreSQL performance the hard way by endymi0n on Thursday September 29, 2016 @02:45PM (#12607794)
Now you make me cry :D

Seriously, the hardest part for me about teaching and writing is going back and trying to see the problem from the eyes of the "guy you were before". Now that it's all obvious, it's suddenly all not that hard anymore and even a little embarrassing to write down - I mean you can find all of this stuff on the Postgres Mailing lists, or superb books like "High Performance Postgres", so it's actually trivial, right?

Thing is, there's still way too few good and reasonably short TL;DR guides for Postgres out there (somehow it's always getting a little less love than MySQL, although this is starting to change), so I thought I'd give it a try, wrap it in an entertaining real-world story and in this way give a little part back to this awesome community. So: Glad you like it! AMA

Re:Debugging PostgreSQL performance the hard way by nugator on Thursday September 29, 2016 @04:55PM (#12608698)
If you have any writeup about your PostgreSQL to Elasticsearch denormalization/aggregation/transportation methods I'd be very interested to read about it!
Re:Debugging PostgreSQL performance the hard way by vitorbaptistaa on Friday September 30, 2016 @06:12AM (#12611538)
+1 to that. We use a similar stack in OpenTrials (http://opentrials.net) and it would be great to see how others solved these issues.
Re:Debugging PostgreSQL performance the hard way by CodeWriter23 on Friday September 30, 2016 @04:43AM (#12611229)
I've been using PostgreSQL for 12 years and learned some great stuff from you. THANKS!!! In the past, I have checkbook-engineered my way into performance. Easy to do when it's someone else's money. Not possible when bootstrapping like I am currently.
Re:Debugging PostgreSQL performance the hard way by kellytk on Wednesday October 05, 2016 @11:21PM (#12649997)
Thanks for writing the article, I'm better at DBA for reading it. You are indeed a "Database Whisperer".