Re: Simple postgresql.conf wizard

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