| 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.
On StackOverflow
- Very slow Django: Multiple "SHOW default_transaction_isolation" calls in log
- Django showing data from previous days
- postgres - cannot drop database using psycopg2
- Intermittent Deadlock with Django LiveServerTestCase, Selenium, and Postgres
- How to fix an error Plone RelStorage using AWS RDS Read replica by psycopg2