Sign up to save your podcasts
Or
Share All Postgres Locks Explained | A Deep Dive
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
All Postgres Locks Explained | A Deep Dive
Get my database engineering course https://database.husseinnasser.com
In this video I do a deep dive in all locks obtained by postgres, I learned a lot while making this video and hope you enjoy it.
0:00 Intro
2:30 What are Locks?
5:30 Overview of Postgres Locks
9:10 Table-Level Locks
11:40 ACCESS EXCLUSIVE
17:40 ACCESS SHARE
19:00 ROW SHARE
20:15 ROW EXCLUSIVE
21:15 SHARE UPDATE EXCLUSIVE
23:30 SHARE
24:50 SHARE ROW EXCLUSIVE
25:18 EXCLUSIVE
25:30 Table Lock Conflict Matrix
28:30 Row-Level Locks
30:00 FOR UPDATE
33:00 FOR NO KEY UPDATE
34:00 FOR SHARE
34:40 FOR KEY SHARE
35:10 Row Lock Conflict Matrix
39:25 Page-Level Locks
42:00 Deadlocks
46:00 Advistory Locks
47:20 Summary
https://www.postgresql.org/docs/current/explicit-locking.html
View all episodes
By Hussein Nasser
4.9
4040 ratings
Get my database engineering course https://database.husseinnasser.com
In this video I do a deep dive in all locks obtained by postgres, I learned a lot while making this video and hope you enjoy it.
0:00 Intro
2:30 What are Locks?
5:30 Overview of Postgres Locks
9:10 Table-Level Locks
11:40 ACCESS EXCLUSIVE
17:40 ACCESS SHARE
19:00 ROW SHARE
20:15 ROW EXCLUSIVE
21:15 SHARE UPDATE EXCLUSIVE
23:30 SHARE
24:50 SHARE ROW EXCLUSIVE
25:18 EXCLUSIVE
25:30 Table Lock Conflict Matrix
28:30 Row-Level Locks
30:00 FOR UPDATE
33:00 FOR NO KEY UPDATE
34:00 FOR SHARE
34:40 FOR KEY SHARE
35:10 Row Lock Conflict Matrix
39:25 Page-Level Locks
42:00 Deadlocks
46:00 Advistory Locks
47:20 Summary
https://www.postgresql.org/docs/current/explicit-locking.html
More shows like The Backend Engineering Show with Hussein Nasser
View all
Freakonomics Radio
32,110 Listeners
Software Engineering Radio - the podcast for professional software developers
274 Listeners
Risky Business
376 Listeners
Science Vs
12,219 Listeners
Syntax - Tasty Web Development Treats
984 Listeners
Darknet Diaries
8,049 Listeners
Practical AI
213 Listeners
Within Reason
1,646 Listeners
All-In with Chamath, Jason, Sacks & Friedberg
10,178 Listeners
Dwarkesh Podcast
561 Listeners
Big Technology Podcast
507 Listeners
Hard Fork
5,544 Listeners
The AI Daily Brief: Artificial Intelligence News and Analysis
693 Listeners
Prof G Markets
1,486 Listeners
The Pragmatic Engineer
75 Listeners