7.1 Postgres Administration - postgresql.conf
This module will discuss the config files of postgresql. This module is divided in to multiple videos.
The first part of module one will cover the main config file of postgres , which is postgresql.conf
#Commands and queries
#Check data and config file location
ps -ef|grep postgresql
#edit postgresql.conf
nano /etc/postgresql/15/main/postgresql.conf
#check shared buffers setting in postgres instance
show shared_buffers;
#check work memory buffers setting in postgres instance
show work_mem;
#check shared buffers modified value and applied status
select * from pg_file_settings where name='shared_buffers';
#check work mem buffers modified value and applied status
select * from pg_file_settings where name='work_mem';