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 > >
