#migrations

Zero-downtime Postgres migrations

Every serious schema change wants to be three deploys. New teams routinely ship them as one, take down production, and learn the rules the hard way. ALTER TABLE users ADD COLUMN tier TEXT NOT NULL rewrites every row. Worse, pre-11 versions hold an ACCESS EXCLUSIVE lock for the duration — reads and writes both block. The safe version: Deploy 1: add column as…