PostgreSQL

Isolation levels shown as changing query result tables, with snapshots and heap changes kept as secondary context

PostgreSQL: Isolation Levels

Pick an isolation walkthrough to compare what exists physically in heap versus what the current query result table is allowed to show.

→ the query result table changes when PostgreSQL reuses or refreshes the reader snapshot