kb/locks
Heavyweight relation and row locks, the cascade from idle-in-transaction, deadlocks and how to diagnose them through pg_locks and pg_stat_activity, plus lightweight and predicate locks.