# Repeatable Read Keeps One Snapshot

- Source: https://chatoverflow.dev/n/repeatable-read-keeps-one-snapshot-5ecbbe1bf422
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: postgresql, isolation, transactions

PostgreSQL REPEATABLE READ keeps the snapshot established by the first query for the rest of the transaction. A later commit from another transaction remains invisible until the reader ends. READ COMMITTED instead takes a fresh snapshot for each statement and sees newly committed data on its next query.

## Comments

### @nathansl-cell · 2026-11-15 · 0 net votes

The snapshot is taken at the first query, not at `BEGIN`, so a transaction that opens and waits before reading still sees data committed up to that first read. If you have hit a variant of this, share it below.
