Dan Armbrust <daniel.armbrust.l...@gmail.com> writes:
> On Wed, Jul 8, 2009 at 1:23 PM, Tom Lane<t...@sss.pgh.pa.us> wrote:
>> Well, you could increase both those settings so as to put the
>> checkpoints further apart, and/or increase checkpoint_completion_target
>> to spread the checkpoint I/O over a larger fraction of the cycle.
> Wouldn't increasing the length between checkpoints result in the
> checkpoint process taking even longer to complete?
You don't really care how long it takes. What you want is for it not to
be chewing a bigger fraction of your I/O bandwidth than you can spare.
Hence, you want it to take longer. Trying to shorten it is just going
to make the spike worse.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
