OSDN Git Service

Allow the wal_buffers setting to be auto-tuned to a reasonable value.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 23 Jan 2011 01:31:24 +0000 (20:31 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 23 Jan 2011 01:31:24 +0000 (20:31 -0500)
commit0f73aae13def660371c34c8feda6e684e6366bdb
tree8428d4ae32b17ff45efbca1c8ef4de5e80d253bb
parent518b1e96c02ba0fa52227c528d6e951004d0653f
Allow the wal_buffers setting to be auto-tuned to a reasonable value.

If wal_buffers is initially set to -1 (which is now the default), it's
replaced by 1/32nd of shared_buffers, with a minimum of 8 (the old default)
and a maximum of the XLOG segment size.  The allowed range for manual
settings is still from 4 up to whatever will fit in shared memory.

Greg Smith, with implementation correction by me.
doc/src/sgml/config.sgml
src/backend/access/transam/xlog.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample