deadlock detection term
DB or system finds cycles in the lock-wait graph
Postgres detects cycles and aborts one transaction with 'deadlock detected.' Apps must catch and retry. Don't rely on detection — design lock order to avoid cycles.
DB or system finds cycles in the lock-wait graph
Postgres detects cycles and aborts one transaction with 'deadlock detected.' Apps must catch and retry. Don't rely on detection — design lock order to avoid cycles.