Nikolay and Michael discuss zero-downtime schema migrations — why they're a challenge, a variety of different cases, and some things you can do to achieve them.

Here are links to a few things we mentioned:

Comparison of JOINS: MongoDB vs. PostgreSQL (blog post by Michael Stonebraker and Álvaro Hernández)
Common DB schema change mistakes (blog post by Nikolay)
lock_timeout and retries (blog post by Nikolay)
lock_timeout
Fast Column Creation with Defaults (blog post by Brandur)
Database Schema Changes Without Downtime (new version of blog post by Braintree)
Zero-downtime Postgres migrations - the hard parts (blog post from GoCardless)
GitLab migration_helpers.rb
GitLab migration style guide
dblab

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

If you would like to share this episode, here's a good link (and thank you!)

~~~

Postgres FM is brought to you by:

Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard

With special thanks to:

Jessie Draws for the amazing artwork

613 - SoulCycle

The Dollop with Dave Anthony and Gareth Reynolds

SoulCycle: A World of Obsession

Remember Everything You Learn from Podcasts