postgresql事务隔离级别如何查看以及设置

1、查看数据库事务隔离级别

SELECT name, setting FROM pg_settings WHERE name ='default_transaction_isolation';

或

SELECT current_setting('default_transaction_isolation');

2、设置全局事务隔离级别

方法一：修改postgresql.conf文件中的default_transaction_isolation

方法二：alter system set default_transaction_isolation to 'REPEATABLE READ';

3、设置当前会话事务隔离级别

SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

设置当前事务的事务隔离级别

START TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

或：

BEGIN ISOLATION LEVEL READ UNCOMMITTED READ WRITE;

原文链接：https://blog.csdn.net/weixin_42500720/article/details/112166601