As you requested below you can find the checkpoint parameter values. In pg_xlog directory , I can see each wal file size is 16mb.
select name, setting from pg_settings where name IN ('checkpoint_segments','checkpoint_timeout','max_wal_size','min_wal_size','checkpoint_completion_target','wal_keep_segments');
Also, what are the values set to the following parameters ?
select name, setting from pg_settings where name IN ('checkpoint_segments','checkpoint_timeout','max_wal_size','min_wal_size','checkpoint_completion_target','wal_keep_segments');
We have a database cluster as "db1_data". Under this cluster we have two databases. one is db1 and other is qovr. I surprised to see as "checkpointer process" is consuming 8.73GB of memory(RSS value as 9158892). Why "checkpointer process" is consuming this much amount of memory and how to limit the usage of the "checkpointer process" memory.