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

From Peter Eisentraut
Subject Re: Change default of checkpoint_completion_target
Date
Msg-id 5285eb02-3340-7728-9f62-1a4365eda850@enterprisedb.com
Whole thread Raw
In response to Change default of checkpoint_completion_target  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Change default of checkpoint_completion_target
List pgsql-hackers
On 2020-12-07 18:53, Stephen Frost wrote:
> * Michael Paquier (michael@paquier.xyz) wrote:
>> 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.
> 
> Concretely, attached is a patch which changes the default and updates
> the documentation accordingly.

I agree with considering this change, but I wonder why the value 0.9. 
Why not, say, 0.95, 0.99, or 1.0?



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Yet another fast GiST build
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] [PATCH] Generic type subscripting