Re: A few new options for CHECKPOINT - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: A few new options for CHECKPOINT
Date
Msg-id X82RyaGPsfgp0aD5@paquier.xyz
Whole thread Raw
In response to Re: A few new options for CHECKPOINT  (Stephen Frost <sfrost@snowman.net>)
Responses Re: A few new options for CHECKPOINT
Re: A few new options for CHECKPOINT
List pgsql-hackers
On Sun, Dec 06, 2020 at 10:03:08AM -0500, Stephen Frost wrote:
> * Alvaro Herrera (alvherre@alvh.no-ip.org) wrote:
>> You keep making this statement, and I don't necessarily disagree, but if
>> that is the case, please explain why don't we have
>> checkpoint_completion_target set to 0.9 by default?  Should we change
>> that?
>
> Yes, I do think we should change that..

Agreed.  FWIW, no idea for others, but it is one of those parameters I
keep telling to update after a default installation.

> In fact, I'd argue that we can
> probably get rid of checkpoint_completion_target entirely as an option.
> The main argument against that is that it could be annoying for people
> upgrading, but changing the default to 0.9 would definitely be an
> improvement.

Not sure there is enough ground to do that though.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Proposed patch for key managment
Next
From: Craig Ringer
Date:
Subject: Re: Logical archiving