Re: Change default of checkpoint_completion_target - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Change default of checkpoint_completion_target
Date
Msg-id 20210323183033.GI579@momjian.us
Whole thread Raw
In response to Re: Change default of checkpoint_completion_target  ("Bossart, Nathan" <bossartn@amazon.com>)
List 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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: WIP: BRIN multi-range indexes
Next
From: Tom Lane
Date:
Subject: Re: pg_upgrade failing for 200+ million Large Objects