Re: Wrong docs on checkpoint_segments?
От | Florian Weimer |
---|---|
Тема | Re: Wrong docs on checkpoint_segments? |
Дата | |
Msg-id | 82mxnceskh.fsf@mid.bfk.de обсуждение исходный текст |
Ответ на | Re: Wrong docs on checkpoint_segments? (Andres Freund <andres@anarazel.de>) |
Ответы |
Re: Wrong docs on checkpoint_segments?
|
Список | 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@bfk.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
В списке pgsql-performance по дате отправления: