PostgreSQL MVCC, Isolation, and Locking — A Backend Developer's Guide
How Postgres MVCC actually works, the four isolation levels (and what each gives you), row vs advisory locks, deadlocks, and the transaction patterns every backend developer needs to handle concurrency correctly.