All Postgres Locks Explained | A Deep Dive

The Backend Engineering Show with Hussein Nasser

Content provided by Hussein Nasser. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Hussein Nasser or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

1+ y ago 49:11

MP3•Episode home

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

515 episodes

#Hussein Nasser #Engineering #Business #Industries #Open Source #Programming #Tech #Software Development