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

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