Re: Load Distributed Checkpoints, take 3 - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Load Distributed Checkpoints, take 3
Date
Msg-id 1182678479.9276.397.camel@silverbirch.site
Whole thread Raw
In response to Re: Load Distributed Checkpoints, take 3  (Greg Smith <gsmith@gregsmith.com>)
List 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 by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Load Distributed Checkpoints, take 3
Next
From: Dariusz Suchojad
Date:
Subject: Docs for CREATE RULE with WHERE/NOTIFY