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
|
| Список | 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:
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 по дате отправления: