Allow the wal_buffers setting to be auto-tuned to a reasonable value.
Tom Lane <tgl@sss.pgh.pa.us>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +19 −6 |
| src/backend/access/transam/xlog.c | modified | +40 −1 |
| src/backend/utils/misc/guc.c | modified | +1 −1 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +1 −1 |