Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

All Postgres Locks Explained - A Deep Dive

Hussein Nasser via YouTube

Start learning Write review
Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → Udacity Ad

Generative AI: Fine-Tune LLMs and Build RAG Chatbots, Rated 4.9★

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This course explains PostgreSQL locks in depth, covering table-level, row-level, and page-level locks, conflict matrices, deadlocks, and advisory locks.

Syllabus

Intro
What are Locks?
Overview of Postgres Locks
Table-Level Locks
ACCESS EXCLUSIVE
ACCESS SHARE
19:00 ROW SHARE ROW EXCLUSIVE
SHARE UPDATE EXCLUSIVE
SHARE
SHARE ROW EXCLUSIVE
EXCLUSIVE
Table Lock Conflict Matrix
Row-Level Locks
FOR UPDATE
FOR NO KEY UPDATE
FOR SHARE
34:40 FOR KEY SHARE Row Lock Conflict Matrix
Page-Level Locks
Deadlocks
Advisory Locks
Summary

Taught by

Hussein Nasser

Reviews

Start your review of All Postgres Locks Explained - A Deep Dive

Start learning

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.