Zero-Downtime Database Migrations for PostgreSQL
Practical techniques for changing schemas on busy PostgreSQL databases without taking the app down, including expand-and-contract, online DDL, and safe backfills.
Zero-Downtime Database Migrations for PostgreSQL
Practical techniques for changing schemas on busy PostgreSQL databases without taking the app down, including expand-and-contract, online DDL, and safe backfills.
Why do schema migrations on a busy PostgreSQL table often cause outages even when the change looks small?
Most `ALTER TABLE` statements take an `ACCESS EXCLUSIVE` lock. That blocks every read and write until the migration finishes. On a hot table, even a 200ms lock can pile up thousands of waiting queries, exhaust the connection pool, and take the app down. The migration itself runs fine. The queue of blocked queries is what breaks production.
Also worth your time on this topic
AWS Well-Architected Review Checklist
Comprehensive checklist based on AWS Well-Architected Framework covering operational excellence, security, reliability, performance efficiency, cost optimization, and sustainability.
120-180 minutes
GitOps with ArgoCD - Automated Kubernetes Deployments
Implement GitOps workflows using ArgoCD for automated, declarative, and auditable Kubernetes application deployments.
120 minutes
Service Mesh Traffic Management with Istio
Learn how to configure advanced traffic management policies in Istio including weighted routing, automatic retries, and circuit breaker patterns for production services.
25 minutes