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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq