6 ms·
Nice reference! Does anyone have similar references for doing 0-downtime migrations? For example, building your indexes with CONCURRENTLY to prevent table lock
by chairleader 8y ago
Nice reference!
Does anyone have similar references for doing 0-downtime migrations? For example, building your indexes with CONCURRENTLY to prevent table locking.
- nimajalali 8y agoNot exhaustive but this has come in handy: https://www.braintreepayments.com/blog/safe-operations-for-high-volume-postgresql/ https://www.braintreepayments.com/blog/safe-operations-for-h...
- pjungwir 8y agoIf you are using Rails, this is a nice guardrail: https://github.com/ankane/strong_migrations 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.