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

Поиск
Список
Период
Сортировка
От Avinash Kumar
Тема Re: "checkpointer process" is consuming more memory. How to control it?
Дата
Msg-id CAN0TujepZnutjWptC1OPMOM0zsODkXvaC=PtMfBATovkY1EmHg@mail.gmail.com
обсуждение исходный текст
Ответ на "checkpointer process" is consuming more memory. How to control it?  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Ответы Re: "checkpointer process" is consuming more memory. How to control it?  (Raghavendra Rao J S V <raghavendrajsv@gmail.com>)
Список pgsql-general
Дерево обсуждения
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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: "checkpointer process" is consuming more memory. How to controlit?
Следующее
От: Raghavendra Rao J S V
Дата:
Сообщение: Re: "checkpointer process" is consuming more memory. How to control it?