| From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | jian xu <jamesxu(at)outlook(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: checkpoint process use too much memory |
| Date: | 2020-04-20 19:37:48 |
| Message-ID: | fcb5bde4-437d-913e-cb1f-3fdb866a805a@sqlexec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)outlook(dot)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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter M. Groen | 2020-04-21 08:27:55 | Re: Exporting TBs of data in Oracle schema/database into CSV format to migrate into PostgreSQL |
| Previous Message | Scott Ribe | 2020-04-20 19:23:06 | Re: checkpoint process use too much memory |