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

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.