postgresql introduces risk deadlock: DBRaven

Source: Technology·Target: Failure Mode

Summary

PostgreSQL detects deadlocks via cycle detection in the lock graph (runs every deadlock_timeout, default 1s) and aborts the cheapest transaction to resolve the cycle; applications must handle deadlock errors with retry logic.

Evidence

·deadlock lists postgresql in affects_technologies; PostgreSQL runs cycle detection ~every 1s (failure_modes/deadlock.yaml)
·postgresql documents lock contention on hot rows under high-concurrency OLTP (technologies/postgresql.yaml bottlenecks)

Evidence grounding

Grounded, 2 supporting items

Concurrent writers acquiring locks in different orders trigger PostgreSQL deadlocks.