Tag: #schema-migration
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 1 posts
The Complete Guide to Zero-Downtime Schema Changes: The Lock Level Each DDL Takes and How to Run It Safely
Working from the PostgreSQL 18 documentation, this lays out by grade exactly which lock each DDL statement takes: the eight table lock modes and their conflicts, the lock level of every ALTER TABLE variant, which changes
2026-08-15 · 18 min read #database#postgresql#schema-migration#zero-downtime#locking