How to / Database Engineering
Zero-Downtime PostgreSQL Schema Migrations on 500GB+ Tables
A 2ms ALTER TABLE can still cause an outage. Use 50ms lock timeouts, NOT VALID constraints, and throttled keyset backfills to migrate 500GB+ Postgres tables.
Khizar Muzammil · · 26 min read
