Toggle navigation

default_transaction_isolation

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.

Comments