The Backend Engineering Show with Hussein Nasser All Postgres Locks Explained | A Deep Dive
Mar 19, 2023
Chapters
Transcript
Episode notes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Introduction
00:00 • 2min
The Back-in Engineering Show - Spotify for Podcasters
02:23 • 3min
Can You Still Acquire Access Shared Locks and Exclusive Locks?
05:42 • 2min
PostgreSQL Advisory Lock
08:06 • 3min
How to Achieve Table Level Locks in Postgres?
10:39 • 3min
The Most Aggressive One, Access Exclusive
13:23 • 3min
Vacuumful Removes Physically Removes All These Space
15:55 • 3min
Access Share, Access Exclusive, and Access Share Locks
18:49 • 2min
What Happens When You Delete a Row, Share Update Exclusive?
21:07 • 3min
Create Index Concurrently Acquires Share Lock on the Table
24:21 • 3min
The Most Important Box Is Share Update Exclusive
27:02 • 2min
Row Level Locks
29:29 • 3min
Select for Update, Is It a Delete, or Delete?
32:09 • 2min
The Concurrent Locking for No Key Update
34:37 • 3min
How to Acquire a Key Share in PostgreSQL?
37:10 • 3min
How Do I Simulate a Delete and Update in Postgres?
39:53 • 4min
The Importance of Deadlocks in SQL Server, Right?
43:27 • 2min
PostgreSQL Application Advisorial Lock
45:13 • 3min
PostgreSQL Advisory Locks - What Are They?
47:52 • 2min