| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Wrong docs on checkpoint_segments? |
| Date: | 2011-01-07 13:45:02 |
| Message-ID: | 82mxnceskh.fsf@mid.bfk.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
* 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 used --with-wal-
> segsize=SEGSIZE?
No, the individual files are still 16 MB. It's just that the
checkpoint_segments limit is not a hard limit, and you end up with
slightly more than twice the configured number of segments on disk.
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2011-01-07 13:47:24 | Re: Wrong docs on checkpoint_segments? |
| Previous Message | Andres Freund | 2011-01-07 13:39:31 | Re: Wrong docs on checkpoint_segments? |