Wrong docs on wal_buffers?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Wrong docs on wal_buffers?
Date: 2011-01-05 20:43:10
Message-ID: 4D24D7DE.6020507@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

All,

One of my coworkers just pointed this out:

"The amount of memory used in shared memory for WAL data. The default is
64 kilobytes (64kB). The setting need only be large enough to hold the
amount of WAL data generated by one typical transaction, since the data
is written out to disk at every transaction commit. This parameter can
only be set at server start."
http://www.postgresql.org/docs/9.0/static/runtime-config-wal.html

That's quite incorrect. The wal_buffers are shared by all concurrent
transactions, so it needs to be sized appropriately for all
*simultaneous* uncommitted transactions, otherwise you'll get
unnecessary flushing.

Certainly performance testing data posted on this list and -hackers.
bears that out. My suggestion instead:

"The amount of shared memory dedicated to buffering writes to the WAL.
The default is 64 kilobytes (64kB), which is low for a busy production
server. Users who have high write concurrency, or transactions which
commit individual large data writes, will want to increase it to between
1MB and 16MB. This parameter can only be set at server start."

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2011-01-05 21:45:21 Re: Wrong docs on wal_buffers?
Previous Message Marc Antonio 2011-01-05 20:06:41 Re: Major performance problem after upgrade from 8.3 to 8.4