Zero-Downtime Postgres Migrations with Drizzle ORM

Zero-Downtime Postgres Migrations with Drizzle ORM Drizzle ORM generates migrations automatically from schema diffs. That's convenient right up until you run a generated migration on a live database with 10 million rows and your API starts timing out. Here's the mental model and the patterns that actually prevent downtime. The Core Problem Postgres takes locks when you run DDL. Most of the dangerous ones are ACCESS EXCLUSIVE locks that block all reads and writes for the duration. On a small tabl