Lesson 4.18mIntermediate6.4k students

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.

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