Transactions and isolation levels
Isolation decides which concurrency anomalies you can still see. Read committed is the default, and it permits more than most people assume.
- 8m
- Intermediate
Video by mkdev · YouTube
Check your understanding
3 questions. Unlocks when you finish the video.
Overview
What this lesson covers
- Keep transactions short and correctly scoped
- Compare read committed, repeatable read, and serializable
- Avoid deadlocks by ordering access consistently
This lesson sits in Operating Postgres, part of PostgreSQL for Developers. It assumes what came before it and leads directly into the next lesson in the module.
In this lesson you will:
- Keep transactions short and correctly scoped
- Compare read committed, repeatable read, and serializable
- Avoid deadlocks by ordering access consistently
Resources
Your notes will live here
Note taking is not available yet. Nothing you type would be saved, so the tab stays read-only for now.