4 ms·

Dominik Raute, I just wanted to say that this may be the best article I have EVER read on how to do database performance tuning. The fact that you showed all th

by mcherm 10y ago

Dominik Raute, I just wanted to say that this may be the best article I have EVER read on how to do database performance tuning. The fact that you showed all the initial steps that DIDN'T reveal any problems was great. The fact that you mentioned the tools you were using and commented on what was particularly good about each was also great. And you explained it all on a level that was comprehensible to a beginner even though this was a very advanced level of work. Thank you for sharing this!

endymi0n 10y ago
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
- nugator 10y ago
  If you have any writeup about your PostgreSQL to Elasticsearch denormalization/aggregation/transportation methods I'd be very interested to read about it!
  - vitorbaptistaa 10y ago
    +1 to that. We use a similar stack in OpenTrials (http://opentrials.net http://opentrials.net) and it would be great to see how others solved these issues.
- CodeWriter23 10y ago
  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.
- kellytk 10y ago
  Thanks for writing the article, I'm better at DBA for reading it. You are indeed a "Database Whisperer".
deleted 10y ago
[deleted]

by mcherm 10y ago

endymi0n 10y ago

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

nugator 10y ago
If you have any writeup about your PostgreSQL to Elasticsearch denormalization/aggregation/transportation methods I'd be very interested to read about it!
- vitorbaptistaa 10y ago
  +1 to that. We use a similar stack in OpenTrials (http://opentrials.net http://opentrials.net) and it would be great to see how others solved these issues.
CodeWriter23 10y ago
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.
kellytk 10y ago
Thanks for writing the article, I'm better at DBA for reading it. You are indeed a "Database Whisperer".

deleted 10y ago

[deleted]