Re: Required checkpoints occurs too frequently

2020-12-11 Thread Mohamed Wael Khobalatte
On Fri, Dec 11, 2020 at 8:49 PM Mohamed Wael Khobalatte < mkhobala...@grubhub.com> wrote: > > > On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar wrote: > >> Hi, >> >> We are getting this alert frequently "Required checkpoints occurs too >> frequently

Re: Required checkpoints occurs too frequently

2020-12-11 Thread Mohamed Wael Khobalatte
On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar wrote: > 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 &g

Re: "Required checkpoints occurs too frequently"

2020-12-11 Thread Atul Kumar
Ok I m sorry, I had no idea of it. On Friday, December 11, 2020, Stephen Frost wrote: > Greetings, > > * Atul Kumar (akumar14...@gmail.com) wrote: > > Please help me in optimizing the same to avoid this alert. > > Please don't post the same question to multiple lists, nor post > the same questio

Re: "Required checkpoints occurs too frequently"

2020-12-11 Thread Stephen Frost
Greetings, * Atul Kumar (akumar14...@gmail.com) wrote: > Please help me in optimizing the same to avoid this alert. Please don't post the same question to multiple lists, nor post the same question over and over to the same list with little time between them. Thanks, Stephen signature.asc Des

"Required checkpoints occurs too frequently"

2020-12-11 Thread Atul Kumar
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

Required checkpoints occurs too frequently

2020-12-11 Thread Atul Kumar
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