Re: Checkpoint Tuning Question

Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com> writes:
> On Wed, Jul 8, 2009 at 1:23 PM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)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