Completed
FOR NO KEY UPDATE
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
All Postgres Locks Explained - A Deep Dive
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 What are Locks?
- 3 Overview of Postgres Locks
- 4 Table-Level Locks
- 5 ACCESS EXCLUSIVE
- 6 ACCESS SHARE
- 7 19:00 ROW SHARE ROW EXCLUSIVE
- 8 SHARE UPDATE EXCLUSIVE
- 9 SHARE
- 10 SHARE ROW EXCLUSIVE
- 11 EXCLUSIVE
- 12 Table Lock Conflict Matrix
- 13 Row-Level Locks
- 14 FOR UPDATE
- 15 FOR NO KEY UPDATE
- 16 FOR SHARE
- 17 34:40 FOR KEY SHARE Row Lock Conflict Matrix
- 18 Page-Level Locks
- 19 Deadlocks
- 20 Advisory Locks
- 21 Summary