PostgreSQL设置隔离级别

PostgreSQL支持的隔离级别:

  • serializable
  • repeatable read
  • read committed
  • read uncommitted

PostgreSQL默认的隔离级别为read committed。

查看当前默认的隔离级别:

postgres=# show default_transaction_isolation; default_transaction_isolation -------------------------------  read committed (1 row)