16.2. Isolation levels
By default a read operation will read the last committed value unless a local modification within the current transaction exist.
The default isolation level is very similar to
READ_COMMITTED: reads do not block or take any locks so non-repeatable reads can occur.
It is possible to achieve a stronger isolation level (such as
SERIALIZABLE) by manually acquiring read and write locks.