Alvaro Herrera wrote:
> Gregory Stark escribió:
>> "Joshua D. Drake" <jd@commandprompt.com> writes:
>
>>> I don't think at any time I have said to my self, I am going to set this
>>> parameter low so I don't fill up my disk. If I am saying that to myself
>>> I have either greatly underestimated the hardware for the task. Consider
>>> that we are quarreling over what amounts to a nominal amount of hard
>>> drive space, 1000 checkpoint_segments = 1.6G of space. My phone has more
>>> capacity than that.
>> Well my phone has 16G of RAM, why not 10000 ?
>
> I don't think the disk space used is the only consideration here. You
> also have to keep recovery time in mind. If you set it to 1000,
> recovery would take way too long.
Presumably if you set checkpoint_segments to a high value, you'd use
checkpoint_timeout to limit recovery time.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com