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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073