Thread: Checkpoint issue
Hi team,
Checkpoint is not getting completing properly. There is delay of more than 3 hrs between checkpoints. Manual intiated checkpoint running for more than 1 hour.
Checkpoint_timeout 5min
Max wal size 8gb
Thanks,
Raj
On Wed, May 6, 2020 at 6:13 AM Raj kumar <rajkumar820999@gmail.com> wrote:
Hi team,Checkpoint is not getting completing properly. There is delay of more than 3 hrs between checkpoints. Manual intiated checkpoint running for more than 1 hour.Checkpoint_timeout 5minMax wal size 8gb
OK, your checkpoints take a long time to complete and since they don't run concurrently having a checkpoint_timeout value less than that time to complete renders the setting immaterial. The main question here is what factors into how long a checkpoint takes to complete. IIUC there are two pieces, the amount of shared buffers being written to disk and the rate at which they are written. So the main driver of this whole setup is "shared_buffers".
David J.