News for hackers. Stuff that matters.
Re:A Performance Cheat Sheet for PostgreSQL by chairleader on Monday June 18, 2018 @02:36PM (#17340545)
Nice reference!

Does anyone have similar references for doing 0-downtime migrations? For example, building your indexes with CONCURRENTLY to prevent table locking.

Re:A Performance Cheat Sheet for PostgreSQL by nimajalali on Monday June 18, 2018 @03:09PM (#17340828)
Not exhaustive but this has come in handy: https://www.braintreepayments.com/blog/safe-operations-for-h...
Re:A Performance Cheat Sheet for PostgreSQL by pjungwir on Monday June 18, 2018 @03:39PM (#17341052)
If you are using Rails, this is a nice guardrail: https://github.com/ankane/strong_migrations

Even if you aren't on Rails or don't want to use the gem, it is still nice a checklist.