[Solved] Which PostgreSQL feature helps automatically detect deadlocks during transaction execution? — Ans: Deadlock detector that aborts one transaction to break the cycle | PostgreSQL

PostgreSQL - Transactions and Concurrency

Which PostgreSQL feature helps automatically detect deadlocks during transaction execution?

AWrite-ahead logging for crash recovery

BDeadlock detector that aborts one transaction to break the cycle

CQuery planner optimizing join order

DAutovacuum process cleaning old tuples

Step-by-Step Solution

Solution:

Step 1: Identify PostgreSQL features related to deadlocks
Deadlock detection involves identifying cycles in lock waits and aborting one transaction to resolve it.
Step 2: Match the feature to the description
Deadlock detector that aborts one transaction to break the cycle describes the deadlock detector that aborts a transaction to break the deadlock cycle.
Final Answer:
Deadlock detector that aborts one transaction to break the cycle -> Option B
Quick Check:
Deadlock detection = Automatic abort [OK]

Quick Trick: PostgreSQL aborts one transaction to resolve deadlocks [OK]

Common Mistakes:

Master "Transactions and Concurrency" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which PostgreSQL feature helps automatically detect deadlocks during transaction execution?