Re: PostgreSQL DB checkpoint error!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Apr 28, 2020, at 2:13 AM, Ashok kumar Mani <amani@xxxxxxxxxxxxx> 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.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux