From: | Mohamed Wael Khobalatte <mkhobalatte(at)grubhub(dot)com> |
---|---|
To: | Atul Kumar <akumar14871(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Required checkpoints occurs too frequently |
Date: | 2020-12-12 01:50:51 |
Message-ID: | CABZeWdz-fbid9-mC2te6d6pROWuiTNLoo65MY2W=aVnCPPVfwQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Dec 11, 2020 at 8:49 PM Mohamed Wael Khobalatte <
mkhobalatte(at)grubhub(dot)com> wrote:
>
>
> On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar <akumar14871(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> We are getting this alert frequently "Required checkpoints occurs too
>> frequently" on postgres version 11.8
>>
>> The RAM of the server is 16 GB.
>>
>> and we have already set the max_wal_size= 4096 MB
>> min_wal_size= 192 MB.
>>
>
> There are more control settings for checkpoints, such as
> checkpoint_timeout. Check out the documentation and see if your set values
> make sense for your case.
>
I didn't realize this was answered, and as it was suggested, not a good
idea to double post.
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2020-12-12 06:07:54 | Re: SQL group by help |
Previous Message | Mohamed Wael Khobalatte | 2020-12-12 01:49:08 | Re: Required checkpoints occurs too frequently |