06/ 11·6 lessons·2 h 25 min

Transactions

How Postgres behaves under concurrency: ACID and transactions, an MVCC mental model (visible xmin/xmax), row locks and lost updates, isolation levels in practice, retries on 40001, and deadlocks with advisory locks.

Start module→Continue · Transactions and ACID→Reread module→Next module →
/ lessons

Lessons

6 lessons · 2 h 25 min
  1. 01Transactions and ACID↳ continue from here#transactions#acid#atomicity25m
  2. 02The MVCC mental model↳ continue from here#mvcc#transactions#snapshot25m
  3. 03Row locks and lost updates↳ continue from here#locks#for-update#skip-locked25m
  4. 04Isolation levels in practice↳ continue from here#isolation#serializable#write-skew25m
  5. 05Retrying on 40001↳ continue from here#40001#retry#serializable20m
  6. 06Deadlocks and advisory locks↳ continue from here#deadlock#40P01#advisory-lock25m