| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Greg Smith <gsmith(at)gregsmith(dot)com>, Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Load Distributed Checkpoints, take 3 |
| Date: | 2007-06-24 09:32:06 |
| Message-ID: | 467E3A16.9050405@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-06-24 09:43:37 | Re: Load Distributed Checkpoints, take 3 |
| Previous Message | Simon Riggs | 2007-06-24 09:23:59 | Re: Load Distributed Checkpoints, take 3 |