* 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 <fwei...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
