Postgres Concurrency Internals: Connections, Locks, and MVCC
A practical guide to how Postgres handles many concurrent clients — process-per-connection, pooling, lock manager, MVCC tuples, deadlocks, and pg_locks.
postgresqldatabaseconcurrencyinternalsperformance
