All Postgres Locks Explained | A Deep Dive
The Backend Engineering Show with Hussein Nasser
00:00
Can You Still Acquire Access Shared Locks and Exclusive Locks?
Exclusive locks give you exclusive access. Once you obtain an exclusive lock on that object or row, nobody can change it. Deadlocks are things that happen when two transactions try to manage the same resource and they are waiting on each other. There are lighter weight things that happen at the table level that tells Postgres things here. And there's a also called application locks level locks,. which is apps can create this concept of a mutex that is manually created by the app.
Transcript
Play full episode
