Re: explanation of some configs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




checkpoint_segments
Maximum distance between automatic WAL checkpoints, in log file segments (each segment is normally 16 megabytes).

Increase these settings if your database has lots of large batch writes to decrease the frequency of checkpoints (and thus lower disk activity). Decrease them if you are short on disk space or your environment has a significant risk of unexpected power-outs, as any un-checkpointed transactions will dropped on restart.

Matthew Wakeling wrote:
On Mon, 9 Feb 2009, justin wrote:
Well then we have conflicting instructions in places on wiki.postgresql.org which links to this
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html

Could you be a little more specific as to which sections conflict?

Matthew


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux