PostgreSQL Zero Downtime Migration: Expand and Contract in Practice
Run PostgreSQL schema changes without outages: lock_timeout with retries, expand and contract steps, batched backfills, NOT VALID constraints and concurrent indexes.
14 min read
Tag
locking
PostgreSQL Blocking Queries: Find the Root Blocker with pg_locks
Learn to trace PostgreSQL blocking queries to the root blocker with pg_stat_activity, pg_blocking_pids() and pg_locks, then prevent them with lock_timeout.
13 min read