Programming
5 PostgreSQL locking behaviors that trip people up
Introduction
PostgreSQL uses MVCC (Multi-Version Concurrency Control) for concurrency control: reads never block writes, and writes never block reads.
Its locking system has 8 table-level lock modes and 4 row-level lock modes, and the conflict tables in the documentation tell you exactly which...
May 26, 2026 · 8 min read