Re: Required checkpoints occurs too frequently

From: Mohamed Wael Khobalatte <mkhobalatte(at)grubhub(dot)com>
To: Atul Kumar <akumar14871(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Required checkpoints occurs too frequently
Date: 2020-12-12 01:49:08
Message-ID: CABZeWdwCp2hZ0dnzunqt5LA-5neFRwyvJZ+snTO3-VS3-gYmtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 11, 2020 at 3:11 AM Atul Kumar <akumar14871(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mohamed Wael Khobalatte 2020-12-12 01:50:51 Re: Required checkpoints occurs too frequently
Previous Message Chris Stephens 2020-12-11 17:24:05 SQL group by help