Re: explanation of some configs
От | justin |
---|---|
Тема | Re: explanation of some configs |
Дата | |
Msg-id | 4991C25B.7000508@emproshunts.com обсуждение исходный текст |
Ответ на | Re: explanation of some configs (Matthew Wakeling <matthew@flymine.org>) |
Ответы |
Re: explanation of some configs
|
Список | pgsql-performance |
<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>
В списке pgsql-performance по дате отправления: