Postgres Pro
Downloads
Home   >   mailing lists

Re: "checkpointer process" is consuming more memory. How to control it? - Mailing list pgsql-general

From Avinash Kumar
Subject Re: "checkpointer process" is consuming more memory. How to control it?
Date
Msg-id CAN0TujepZnutjWptC1OPMOM0zsODkXvaC=PtMfBATovkY1EmHg@mail.gmail.com
Whole thread Raw
In response to "checkpointer process" is consuming more memory. How to control it?  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Responses Re: "checkpointer process" is consuming more memory. How to control it?
List pgsql-general
Tree view
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@gmail.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.png

--
Regards,
Raghavendra Rao J S V




--
9000799060
Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: "checkpointer process" is consuming more memory. How to controlit?
Next
From: Raghavendra Rao J S V
Date:
Subject: Re: "checkpointer process" is consuming more memory. How to control it?