[prev] 70 [next]

Transaction Isolation Levels (cont)

For transaction isolation, PostgreSQL
  • provides syntax for all four levels
  • treats read uncommitted as read committed
  • repeatable read behaves like serializable
  • default level is read committed

Note: cannot implement read uncommitted because of MVCC


For more details, see PostgreSQL Documentation section 13.2

  • extensive discussion of semantics of UPDATE, INSERT, DELETE