Why Database Deadlocks Need Wait-Die and Wound-Wait Schemes
from Database Tech with Fexingo: SQL, NoSQL, and Data Storage Conversations Hosted by Fexingo
Lucas and Luna dive into database deadlock handling, comparing wait-die and wound-wait schemes. Using a concrete example from PostgreSQL 17's transaction manager, they explain how these protocols prevent deadlocks without the overhead of a deadlock detector. The episode covers why wait-die is safer for read-heavy workloads while wound-wait favors writes, and how Amazon Aurora's distributed architecture forced a custom hybrid approach. A must-listen for engineers designing high-concurrency OLTP systems. #DatabaseDeadlocks #WaitDie #WoundWait #PostgreSQL #AmazonAurora #OLTP #ConcurrencyControl #LockManager #TransactionIsolation #DeadlockPrevention #DistributedDatabases #DatabaseInternals #TechPodcast #FexingoBusiness #BusinessPodcast #DataEngineering #SQL #NoSQL Keep every episode free: buymeacoffee.com/fexingo
Embed this episode
No transcript yet.