Alvaro Herrera wrote:
Gregory Stark escribió:
"Joshua D. Drake" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
