Required checkpoints occurs too frequently

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Required checkpoints occurs too frequently
Date: 2020-12-11 08:11:20
Message-ID: CA+ONtZ64ZS2=sghFpci7Y-ed3cvKu06JNib=Ckt-PNz+p7q9zQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Atul Kumar 2020-12-11 08:12:05 "Required checkpoints occurs too frequently"
Previous Message David G. Johnston 2020-12-11 00:36:55 Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?