← Back to systems

PostgreSQL MVCC

6 questions · ~6 min · intermediate

Six mechanism-first questions on tuple headers, snapshots, read committed versus repeatable read, pg_xact visibility checks, cleanup horizons, and why index-only scans still care about MVCC metadata.

0 / 6

Why can a PostgreSQL transaction running under repeatable read keep seeing an older row version after another transaction has already committed an update?

Press 1 to 4 to pick an answer