pgsql: Allow the wal_buffers setting to be auto-tuned to a reasonable v

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Allow the wal_buffers setting to be auto-tuned to a reasonable v
Date: 2011-01-23 01:32:24
Message-ID: E1Pgooa-0001AJ-Cj@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=0f73aae13def660371c34c8feda6e684e6366bdb

Modified Files
--------------
doc/src/sgml/config.sgml | 25 +++++++++++----
src/backend/access/transam/xlog.c | 41 ++++++++++++++++++++++++-
src/backend/utils/misc/guc.c | 2 +-
src/backend/utils/misc/postgresql.conf.sample | 2 +-
4 files changed, 61 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2011-01-23 01:44:10 pgsql: Quick hack to un-break plpython regression tests.
Previous Message Tom Lane 2011-01-22 23:02:06 pgsql: Suppress "control reaches end of non-void function" warning from