| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Michael Paquier <michael(at)paquier(dot)xyz>, David Steele <david(at)pgmasters(dot)net>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Bernd Helmle <mailings(at)oopsware(dot)de>, "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Change default of checkpoint_completion_target |
| Date: | 2021-03-23 18:30:33 |
| Message-ID: | 20210323183033.GI579@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Mar 23, 2021 at 06:24:07PM +0000, Bossart, Nathan wrote:
> LGTM. I just have a few small wording suggestions.
>
> + completion overhead. Reducing this parameter is not recommended as that
> + causes the I/O from the checkpoint to have to complete faster, resulting
> + in a higher I/O rate, while then having a period of less I/O between the
> + completion of the checkpoint and the start of the next scheduled
> + checkpoint. This parameter can only be set in the
>
> Reducing this parameter is not recommended because it forces the
> checkpoint to complete faster. This results in a higher rate of I/O
> during the checkpoint followed by a period of less I/O between
> checkpoint completion and the next scheduled checkpoint.
FYI, I am very happy this issue is being addressed for PG 14. :-)
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-03-23 18:35:46 | Re: pg_upgrade failing for 200+ million Large Objects |
| Previous Message | Alvaro Herrera | 2021-03-23 18:28:50 | Re: WIP: BRIN multi-range indexes |