What PostgreSQL Locks on UPDATE: In-Place xmax, 4 Row Lock Modes, EvalPlanQual & SSI
Physical engine mechanics of PostgreSQL row locking: how xmax writes locks directly into tuple headers without a lock table, the 4 row lock modes matrix, foreign key collisions, EvalPlanQual rechecks, and why SSI serializable aborts are by design.