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

Seams like you are with the default or fairly less checkpoint_* settings.

You need to look at several patterns to understand the best values for
these settings.

For now, i can say 300 seconds for checkpoint_timeout could be fairly very
less. Try increasing that with a reload.

See this =>
https://www.percona.com/blog/2018/06/15/tuning-postgresql-for-sysbench-tpcc/

Please do note that delaying checkpointing could also increase the time for
crash recovery/shutdown, etc.........

--
Thanks & Regards,
Avinash Vallarapu (Avi).
PostgreSQL Support Tech Lead.
+1-902-221-5976

On Wed, Aug 22, 2018 at 11:02 AM, Raghavendra Rao J S V <
raghavendrajsv(at)gmail(dot)com> wrote:

>
> 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
>