PostgreSQL documentation (opens in a new tab)
The official reference for the tools used in this lesson.
Link
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.
Lesson 4.18m 18sIntermediate6.4k students
Lesson length
8:18What 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
Personal notes are coming soon.