Обсуждение: Required checkpoints occurs too frequently
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
On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar <akumar14871@gmail.com> 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 more control settings for checkpoints, such as checkpoint_timeout. Check out the documentation and see if your set values make sense for your case.
On Fri, Dec 11, 2020 at 8:49 PM Mohamed Wael Khobalatte <mkhobalatte@grubhub.com> wrote:
On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar <akumar14871@gmail.com> 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 more control settings for checkpoints, such as checkpoint_timeout. Check out the documentation and see if your set values make sense for your case.
I didn't realize this was answered, and as it was suggested, not a good idea to double post.