Re: checkpoint process use too much memory

Поиск
Список
Период
Сортировка
От MichaelDBA
Тема Re: checkpoint process use too much memory
Дата
Msg-id fcb5bde4-437d-913e-cb1f-3fdb866a805a@sqlexec.com
обсуждение исходный текст
Ответ на Re: checkpoint process use too much memory  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: checkpoint process use too much memory  (jian xu <jamesxu@outlook.com>)
Список pgsql-admin
Дерево обсуждения
You said: "the work_mem is 128MB, so they could use mostly 25GB memory,"

But work_mem is sometimes very deceiving based on types of queries executed.  You may need many work_mem buffers for a single query. So 8 buffers used = 1GB.  So it could conceivable surpass 25GB easily.  I would do some explaining on your SQL workload.

Regards,
Michael Vitale



Scott Ribe wrote on 4/20/2020 3:23 PM:
On Apr 20, 2020, at 1:13 PM, jian xu <jamesxu@outlook.com> wrote:

Do you mean the file cache will be counted in postgres checkpointer memory usage?

No, it won't be counted as PG memory. I just mean that free memory low is not a sign of a problem, when it's file cache.

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: checkpoint process use too much memory
Следующее
От: "Peter M. Groen"
Дата:
Сообщение: Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL