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" on postgres version 11.8 >> >> The RAM of the serve

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 > min_wal_size= 192 MB. > There are m

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