Re: A few new options for CHECKPOINT

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: A few new options for CHECKPOINT
Дата
Msg-id 20201216223918.GG4527@momjian.us
обсуждение исходный текст
Ответ на Re: A few new options for CHECKPOINT  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Mon, Dec  7, 2020 at 11:22:01AM +0900, Michael Paquier 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.

+1 for making it 0.9.   FYI< Robert Haas has argued that our estimation
of completion isn't great, which is why it defaults to 0.5.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: \gsetenv
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Proposed patch for key managment