Re: Load Distributed Checkpoints, take 3

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