Anatomy of concurrent data access in PostgreSQL
summary
PostgreSQL's mechanisms for concurrent data access are examined, including how the database implements locking, MVCC (multi-version concurrency control), and related internals to provide safe, user-friendly concurrent operations. The talk analyzes the internal work PostgreSQL performs to manage conflicts, maintain consistency, and optimize performance under concurrent workloads.
AI-written summary · about
chapters (4)
related talks
39mAnatomy of Table-Level Locks in PostgreSQL
45mTransactions and Concurrency Control Patterns
50mExplaining the PG concurrency control mechanisms using rollercoasters
42mAnatomy of Table-Level Locks in PostgreSQL
58mConcurrency in Postgres
32mMonitoring Waits in PostgreSQL
47mWhat If We Opened PostgreSQL's Hood?
49mConcurrency Deep-Dive