| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Raj kumar <rajkumar820999(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Checkpoint issue |
| Date: | 2020-05-06 13:51:52 |
| Message-ID: | CAKFQuwb2TJLjuy+ihzQP8k2kqZEUoBc9R-LiEKOE=33BvAOPkw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, May 6, 2020 at 6:13 AM Raj kumar <rajkumar820999(at)gmail(dot)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 5min
> Max 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ayaansh Chawla | 2020-05-08 05:04:52 | postgresql Installation failed Error changing group of /opt/PostgreSQL to daemon |
| Previous Message | Raj kumar | 2020-05-06 13:12:45 | Checkpoint issue |