7.2 Postgres Administration - postgresql.auto.conf
This module discuss the postgres config file - postgresql.auto.conf
This config file overrides the value of parameters in postgresql.conf and can be modified by alter system command
Alter system set work_mem='16MB';
Alter system set shared_buffers='128MB';
#Reload config
select * from pg_reload_conf();
#Remove work_mem parameter from postgresql.auto.conf
alter system reset work_mem;
#Remove all parameters from postgresql.auto.conf
alter system reset all;