Skip to content
All Postgres Locks Explained | A Deep Dive episode artwork

Mar 19, 2023 49 min

All Postgres Locks Explained | A Deep Dive

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

All Postgres Locks Explained | A Deep Dive

0:00 49:11

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 49 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on March 19, 2023.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.