Re: checkpoint_timeout

Thomas F.O'Connell wrote:
> In the annotated conf file for 8.0, Josh Berkus notes that
> checkpoint_timeout should be increased "dramatically" for large data
> loads. For settings like sort_mem (now work_mem), it's been convenient
> to be able to have a default setting for standard work and a
> per-connection configuration option.
>
> Instinctively, it seems like it would be nice to have something similar
> for checkpoint_timeout, but is there any disadvantage to having a value
> "dramatically" higher than the default for general use, considering
> that checkpoint_timeout can only be set at server start?

I don't see something that happens every five minutes as any kind of
performance problem. I am not sure what Josh saw that made him want to
increase that.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073