Re: A few new options for CHECKPOINT

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: A few new options for CHECKPOINT
Дата
Msg-id X82RyaGPsfgp0aD5@paquier.xyz
обсуждение исходный текст
Ответ на Re: A few new options for CHECKPOINT  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: A few new options for CHECKPOINT  ("Bossart, Nathan" <bossartn@amazon.com>)
Re: A few new options for CHECKPOINT  (Bruce Momjian <bruce@momjian.us>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Proposed patch for key managment
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Logical archiving