Enough backends waiting on one heavyweight lock can turn PostgreSQL's deadlock detector into a serialized storm that drives database throughput to zero.