All Postgres Locks Explained - A Deep Dive

All Postgres Locks Explained - A Deep Dive

Hussein Nasser via YouTube Direct link

Table Lock Conflict Matrix

12 of 21

12 of 21

Table Lock Conflict Matrix

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. 1 Intro
  2. 2 What are Locks?
  3. 3 Overview of Postgres Locks
  4. 4 Table-Level Locks
  5. 5 ACCESS EXCLUSIVE
  6. 6 ACCESS SHARE
  7. 7 19:00 ROW SHARE ROW EXCLUSIVE
  8. 8 SHARE UPDATE EXCLUSIVE
  9. 9 SHARE
  10. 10 SHARE ROW EXCLUSIVE
  11. 11 EXCLUSIVE
  12. 12 Table Lock Conflict Matrix
  13. 13 Row-Level Locks
  14. 14 FOR UPDATE
  15. 15 FOR NO KEY UPDATE
  16. 16 FOR SHARE
  17. 17 34:40 FOR KEY SHARE Row Lock Conflict Matrix
  18. 18 Page-Level Locks
  19. 19 Deadlocks
  20. 20 Advisory Locks
  21. 21 Summary

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.