Re: Change default of checkpoint_completion_target

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Change default of checkpoint_completion_target
Дата
Msg-id 519044.1611084646@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 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
Stephen Frost <sfrost@snowman.net> writes:
> Any further comments or thoughts on this one?

This:

+        total time between checkpoints. The default is 0.9, which spreads the
+        checkpoint across the entire checkpoint timeout period of time,

is confusing because 0.9 is obviously not 1.0; people will wonder
whether the scale is something strange or the text is just wrong.
They will also wonder why not use 1.0 instead.  So perhaps more like

    ... The default is 0.9, which spreads the checkpoint across almost
    all the available interval, providing fairly consistent I/O load
    while also leaving some slop for checkpoint completion overhead.

The other chunk of text seems accurate, but there's no reason to let
this one be misleading.

            regards, tom lane



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Change default of checkpoint_completion_target
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Change default of checkpoint_completion_target