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


Cover of Mastering PostgreSQL 9.6


What the fuck?