| Type: | enum |
| Default: | read committed |
| Context: | user |
| Restart: | false |
| Values: | [serializable, repeatable read, read committed, read uncommitted] |
Each SQL transaction has an isolation level, which can be either read uncommitted, read committed, repeatable read, or serializable. This parameter controls the default isolation level of each new transaction. The default is read committed.
Consult mvcc and sql-set-transaction for more information.
Recommendations
Relates to transaction_isolation. Better set on a session or transaction basis as transaction_isolation in order to support specific types of transaction conflict resolution.