Re: [PERFORM] Wrong docs on checkpoint_segments?

2011-01-07 Thread Andres Freund
On Friday, January 07, 2011 02:45:02 PM Florian Weimer wrote: > * Andres Freund: > > On Friday, January 07, 2011 01:45:25 PM Florian Weimer wrote: > >> On 9.0, this configuration > >> > >> checkpoint_segments = 512 # in logfile segments, min 1, 16MB each > >> > >> results in 1034 segments, so

Re: [PERFORM] Wrong docs on checkpoint_segments?

2011-01-07 Thread Florian Weimer
* Andres Freund: > On Friday, January 07, 2011 01:45:25 PM Florian Weimer wrote: >> On 9.0, this configuration >> >> checkpoint_segments = 512 # in logfile segments, min 1, 16MB each >> >> results in 1034 segments, so the effective logfile segment size is 32 MB. > Um. Is it possible that you

Re: [PERFORM] Wrong docs on checkpoint_segments?

2011-01-07 Thread Andres Freund
On Friday, January 07, 2011 01:45:25 PM Florian Weimer wrote: > On 9.0, this configuration > > checkpoint_segments = 512 # in logfile segments, min 1, 16MB each > > results in 1034 segments, so the effective logfile segment size is 32 MB. Um. Is it possible that you redefined XLOG_SEG_SIZE or

[PERFORM] Wrong docs on checkpoint_segments?

2011-01-07 Thread Florian Weimer
On 9.0, this configuration checkpoint_segments = 512 # in logfile segments, min 1, 16MB each results in 1034 segments, so the effective logfile segment size is 32 MB. The documentation says this: Maximum number of log file segments between automatic WAL checkpoints (each segment is