Dan Armbrust <daniel.armbrust.list@xxxxxxxxx> writes: > On Wed, Jul 8, 2009 at 1:23 PM, Tom Lane<tgl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
