What do you mean by “how much wal is created”
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.
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
>
>