All Postgres Locks Explained | A Deep Dive

The Backend Engineering Show with Hussein Nasser

内容由Hussein Nasser提供。所有播客内容（包括剧集、图形和播客描述）均由 Hussein Nasser 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品，您可以按照此处概述的流程进行操作https://zh.player.fm/legal。

1+ y ago 49:11

MP3•单集首页

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

526集单集

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