diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2011-01-22 20:31:24 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2011-01-22 20:31:24 -0500 |
| commit | 0f73aae13def660371c34c8feda6e684e6366bdb (patch) | |
| tree | 8428d4ae32b17ff45efbca1c8ef4de5e80d253bb /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 518b1e96c02ba0fa52227c528d6e951004d0653f (diff) | |
| download | postgresql-0f73aae13def660371c34c8feda6e684e6366bdb.tar.gz postgresql-0f73aae13def660371c34c8feda6e684e6366bdb.zip | |
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.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index f436b834680..6c6f9a9a0d8 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -162,7 +162,7 @@ # fsync_writethrough # open_sync #full_page_writes = on # recover from partial page writes -#wal_buffers = 64kB # min 32kB +#wal_buffers = -1 # min 32kB, -1 sets based on shared_buffers # (change requires restart) #wal_writer_delay = 200ms # 1-10000 milliseconds |