Pg_repack

Zero-Downtime Database Migrations: Patterns That Work in Production

Naive database migrations kill production. Here's the expand-contract pattern, online schema change tools, and the specific techniques that let you migrate PostgreSQL and MySQL schemas without taking your app offline.