Re: "checkpointer process" is consuming more memory. How to control it?

[Raghavendra Rao J S V <raghavendrajsv@xxxxxxxxx>]

We are using PostgreSQL 9.2 version.

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');   

On Wed, 22 Aug 2018 at 19:26, Avinash Kumar <avinash.vallarapu@xxxxxxxxx> wrote:

Hi Raghavendra,

Please let us know your PostgreSQL version. 

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'); 

On Wed, Aug 22, 2018 at 10:43 AM, Raghavendra Rao J S V <raghavendrajsv@xxxxxxxxx> wrote:

Hi All,

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.

--

Regards,
Raghavendra Rao J S V

--

9000799060

--

Regards,
Raghavendra Rao J S V
Mobile- 8861161425