postgresql 常用配置

https://www.cnblogs.com/ctypyb2002/p/9793000.html

select * from pg_stat_activity;

 # 查看一些插件

select * from pg_available_extensions where name like '%plpython%';

https://blog.csdn.net/jinguo_zhang/article/details/128172244

alter system set shared_buffers = '32GB';

set shared_buffers = '32GB';

show shared_buffers;

set max_parallel_workers='32';

show max_parallel_workers;

alter system set max_parallel_workers='32';

set work_mem='512MB' ;

alter system set work_mem='512MB';

show work_mem;

 

alter system set maintenance_work_mem = '8GB';

set maintenance_work_mem='8GB' ;

show maintenance_work_mem ;