Re: PostgreSQL DB checkpoint error! - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: PostgreSQL DB checkpoint error!
Date
Msg-id 913378B8-0A7F-44A6-BF34-32BF58FC0876@crazybean.net
Whole thread Raw
In response to PostgreSQL DB checkpoint error!  (Ashok kumar Mani <amani@accelaero.com>)
Responses RE: PostgreSQL DB checkpoint error!  (Ashok kumar Mani <amani@accelaero.com>)
List pgsql-admin


On Apr 28, 2020, at 2:13 AM, Ashok kumar Mani <amani@accelaero.com> wrote:

Database is getting hung every day at 5AM. I found the below message from log file , Could you please help me , should I need to increase the max_wal_size value ?

Most likely.  I would recommend enabling checkpoint logging to get a better understanding how often checkpoint are occurring, duration, and size in relation to buffer pool.  Check for 'checkpoint starting’ and 'checkpoint complete’  in the PostgreSQL log files after enabling it.

log_checkpoints = on

What is shared_buffers, max_wal_size, and wal_buffers set to?

Why it say “incomplete startup packet” in the log.

This should be benign.

pgsql-admin by date:

Previous
From: Raj kumar
Date:
Subject: pgbench data loading failure- tablepscace space or pg_wal mount space issue
Next
From: Ashok kumar Mani
Date:
Subject: RE: PostgreSQL DB checkpoint error!