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