<br /> checkpoint_segments<br /> Maximum distance between automatic WAL checkpoints, in log file segments (each segment
isnormally 16 megabytes).<br /><br /> Increase these settings if your database has lots of large batch writes to
decreasethe frequency of checkpoints (and thus lower disk activity). Decrease them if you are short on disk space or
yourenvironment has a significant risk of <u><b>unexpected power-outs, as any un-checkpointed transactions will dropped
onrestart.</b></u><br /><br /> Matthew Wakeling wrote: <blockquote
cite="mid:alpine.DEB.2.00.0902101208460.3995@aragorn.flymine.org"type="cite">On Mon, 9 Feb 2009, justin wrote: <br
/><blockquotetype="cite">Well then we have conflicting instructions in places on wiki.postgresql.org which links to
this<br /><a class="moz-txt-link-freetext"
href="http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html">http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html</a><br
/></blockquote><br/> Could you be a little more specific as to which sections conflict? <br /><br /> Matthew <br /><br
/></blockquote>