PostgreSQL Locks, Part 3: Advisory Locks and Choosing the Right Lock
sep 2026The last of three parts on PostgreSQL locking: advisory locks and their pitfalls, every lock type in pg_locks, a decision guide for choosing between row, table, advisory, and Serializable, and how to observe locks in production.