Re: Change default of checkpoint_completion_target

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Change default of checkpoint_completion_target
Дата
Msg-id 5285eb02-3340-7728-9f62-1a4365eda850@enterprisedb.com
обсуждение исходный текст
Ответ на Change default of checkpoint_completion_target  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Change default of checkpoint_completion_target  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Yet another fast GiST build
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] [PATCH] Generic type subscripting