4 ms·
> a transaction doesn't guarantee that all statements in it see the data at the same point in time This depends on the transaction isolation level. If you use
by andyferris 1y ago
> a transaction doesn't guarantee that all statements in it see the data at the same point in time
This depends on the transaction isolation level. If you use snapshot or serializable this should be the case (but you may have aborted transactions due to optimistic concurrency).
- Spixel_ 1y agoYou are right, but note that the default isolation level is "Read committed" in postgres.