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: |
- [PERFORM] explanation of some configs Thomas Finneid
- Re: [PERFORM] explanation of some configs Joshua D. Drake
- Re: [PERFORM] explanation of some configs Thomas Finneid
- Re: [PERFORM] explanation of some configs justin
- Re: [PERFORM] explanation of some config... Matthew Wakeling
- Re: [PERFORM] explanation of some c... justin
- Re: [PERFORM] explanation of so... Robert Haas
- Re: [PERFORM] explanation of so... Matthew Wakeling
- Re: [PERFORM] explanation o... justin
- Re: [PERFORM] explanation o... Greg Smith
- Re: [PERFORM] explanation o... justin
- Re: [PERFORM] explanation o... Greg Smith
- Re: [PERFORM] explanation o... justin
- Re: [PERFORM] explanation of some configs Robert Haas