PG修改参数方法

1.查看参数文件位置

postgres=# show config_file;
           config_file            
----------------------------------
 /data/pgsql_data/postgresql.conf
(1 row)

postgres=# show hba_file;
           hba_file           
------------------------------
 /data/pgsql_data/pg_hba.conf
(1 row)

postgres=# show ident_file;
           ident_file           
--------------------------------
 /data/pgsql_data/pg_ident.conf
(1 row)

2.查看当前会话参数

show all;
postgres=# show enable_hashjoin;
 enable_hashjoin 
-----------------
 on
(1 row)
postgres=# \x
Expanded display is on.
postgres=# select * from pg_settings where name in ('enable_hashjoin');
-[ RECORD 1 ]---------------------------------------------
name       | enable_hashjoin
setting    | on
unit       | 
category   | Query Tuning / Planner Method Configuration
short_desc