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
What the fuck?
Share this highlighthttp://www.safaribooksonline.com/a/mastering-postgresql-96/8214283/