Zero-Downtime Database Migrations: The Expand-Contract Pattern in Production
How to rename database columns and alter schema types on 500-million row Postgres tables without holding table locks.
Kalash JindalAuthor
Postgres Schema Architecture
Phase 1: Expand, Phase 2: Dual Write & Backfill, Phase 3: Contract.
SHARE ARTICLE
ABOUT THE WRITER
Founder of developerOS & CloudPrep. Former Infrastructure Engineer and Systems Architect.
