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.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.