Postgres Pro
Downloads
Home   >   mailing lists

Re: "Required checkpoints occurs too frequently" - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: "Required checkpoints occurs too frequently"
Date
Msg-id 9aa3f78ed8c658fdd7bf639cde06133be908b8a3.camel@cybertec.at
Whole thread Raw
In response to "Required checkpoints occurs too frequently"  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: "Required checkpoints occurs too frequently"  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-performance
Tree view 
On Fri, 2020-12-11 at 13:42 +0530, Atul Kumar wrote:
> 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.

You should increase "max_wal_size" even more.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-performance by date:

Previous
From: Atul Kumar
Date:
Subject: "Required checkpoints occurs too frequently"
Next
From: Atul Kumar
Date:
Subject: Re: "Required checkpoints occurs too frequently"