Re: Load Distributed Checkpoints, take 3

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Load Distributed Checkpoints, take 3
Дата
Msg-id 1182678479.9276.397.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: Load Distributed Checkpoints, take 3  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-patches
On Fri, 2007-06-22 at 16:57 -0400, Greg Smith wrote:
> If you're not, I think you should be.  Keeping that replay interval
> time down was one of the reasons why the people I was working with
> were displeased with the implications of the very spread out style of
> some LDC tunings.  They were already unhappy with the implied recovery
> time of how high they had to set checkpoint_settings for good
> performance, and making it that much bigger aggrevates the issue.
> Given a knob where the LDC can be spread out a bit but not across the
> entire interval, that makes it easier to control how much expansion
> there is relative to the current behavior.

We won't need to set checkpoint_settings so high, since performance is
smoothed across checkpoints by LDC and its OK to allow them more
frequently. So this concern need not apply with LDC.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: Load Distributed Checkpoints, take 3
Следующее
От: Dariusz Suchojad
Дата:
Сообщение: Docs for CREATE RULE with WHERE/NOTIFY