Обсуждение: "Required checkpoints occurs too frequently"
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. Please help me in optimizing the same to avoid this alert. Regards, Atul
On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote: > 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. You should increase "max_wal_size" even more. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
how much size should I increase in "max_wal_size". Do we need to change any other parameter's value also ? Regards, Atul On 12/11/20, Laurenz Albe <laurenz.albe@cybertec.at> wrote: > On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote: >> 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. > > You should increase "max_wal_size" even more. > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > >
it depends on your cluster environment. you need to know how much wal is created in checkpoint_timeout duration. for example your checkpoint_timeout = 30 min, you need to measure how much wal is created in 30 minute. and then you can increase max_wal_size according to this size.
Atul Kumar <akumar14871@gmail.com>, 11 Ara 2020 Cum, 12:02 tarihinde şunu yazdı:
how much size should I increase in "max_wal_size".
Do we need to change any other parameter's value also ?
Regards,
Atul
On 12/11/20, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote:
>> 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.
>
> You should increase "max_wal_size" even more.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
What do you mean by “how much wal is created”
On Friday, December 11, 2020, Amine Tengilimoglu <aminetengilimoglu@gmail.com> wrote:
How total Wal files in size or how much total wal files in numbers.
Please let me know.
Regards
Atul
On Friday, December 11, 2020, Amine Tengilimoglu <aminetengilimoglu@gmail.com> wrote:
it depends on your cluster environment. you need to know how much wal is created in checkpoint_timeout duration. for example your checkpoint_timeout = 30 min, you need to measure how much wal is created in 30 minute. and then you can increase max_wal_size according to this size.Atul Kumar <akumar14871@gmail.com>, 11 Ara 2020 Cum, 12:02 tarihinde şunu yazdı:how much size should I increase in "max_wal_size".
Do we need to change any other parameter's value also ?
Regards,
Atul
On 12/11/20, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote:
>> 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.
>
> You should increase "max_wal_size" even more.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
> On Dec 11, 2020, at 06:34, Atul Kumar <akumar14871@gmail.com> wrote: > > What do you mean by “how much wal is created” > How total Wal files in size or how much total wal files in numbers. Since WAL segment files are a fixed size (almost always 16MB), those numbers are directly related. -- -- Christophe Pettus xof@thebuild.com