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?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005