Isolation Levels
PostgreSQL Isolation Levels
| Level | Dirty Read | Non-repeatable Read | Phantom Read |
|---|---|---|---|
| READ UNCOMMITTED* | No | Yes | Yes |
| READ COMMITTED (default) | No | Yes | Yes |
| REPEATABLE READ | No | No | No** |
| SERIALIZABLE | No | No | No |
* PostgreSQL treats READ UNCOMMITTED as READ COMMITTED
** PostgreSQL's REPEATABLE READ also prevents phantom reads