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 <akumar14...@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.a...@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 > > > > > > >
