How to Migrate a Table

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