Simon Riggs wrote:
> On Fri, 2007-06-22 at 22:19 +0100, Heikki Linnakangas wrote:
>
>> However, I think shortening the checkpoint interval is a perfectly valid
>> solution to that.
>
> Agreed. That's what checkpoint_timeout is for. Greg can't choose to use
> checkpoint_segments as the limit and then complain about unbounded
> recovery time, because that was clearly a conscious choice.
No, by checkpoint interval, I meant both checkpoint_timeout and
checkpoint_segments. You can decrease checkpoint_segments as well to
shorten recovery time.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com