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

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

[image: image.png]

On Wed, 22 Aug 2018 at 19:26, Avinash Kumar <avinash(dot)vallarapu(at)gmail(dot)com>
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(at)gmail(dot)com> 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.
>>
>> [image: image.png]
>>
>> --
>> Regards,
>> Raghavendra Rao J S V
>>
>>
>
>
> --
> 9000799060
>

--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425