#zero downtime

A schema migration is not one SQL statement: expand, backfill, and observe before you contract

A PostgreSQL schema migration must account for existing rows, older workers, and newly deployed code. Use expand, repeatable backfills, and evidence about locks, indexes, and constraints before removing an old path.