3 ms·
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
by 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 agoIf 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 agoI'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 agoThanks for writing the article, I'm better at DBA for reading it. You are indeed a "Database Whisperer".