Part 06 · Transactions and Concurrency Control

Locking and Two-Phase Locking

Shared lockExclusive lock2PLLock granularity

Shared and exclusive locks, row vs table locks, and the two-phase rule that makes locking serializable. Seeing lock waits live in pg_locks.

⏱ 6 min · Station 51 of 123

✎

This chapter is being written.

The route is mapped; the full walkthrough arrives here soon.