Lesson 07 · 15 min
Locks and deadlocks
Row and table locks, SELECT FOR UPDATE, SKIP LOCKED queues, deadlock detection and advisory locks.
15 minLesson 7 of 10Practice includedAsk AI on any point
MVCC keeps reads and writes from getting in each other's way: SELECT does not wait for UPDATE. But two writes to the same row, a schema migration under load or a job queue without coordination run into locks. You need to understand them to avoid a "the database froze" moment in the middle of a workday.
Sign in to continue
The rest of this lesson opens after sign up
The first lesson of every course is open without an account. To read on, solve the practice and use Ask, create a free account or log in.