O'Reilly logo
  • Daniel Waite thinks this is interesting:

This means that every statement inside a transaction will get a new snapshot of the data, which will be constant throughout the query.

An SQL statement will operate on the same snapshot and will ignore changes by concurrent transactions while it is running.

If you want to avoid that

From

Cover of Mastering PostgreSQL 9.6

Note

What the fuck?