The amount of shared memory used for WAL data that has not yet been written to disk. The default setting of -1 selects a size equal to 1/32nd (about 3%) of shared_buffers, but not less than
64kB nor more than the size of one WAL segment, typically
16MB. This value can be set manually if the automatic choice is too large or too small, but any positive value less than
32kB will be treated as
32kB. This parameter can only be set at server start.
The contents of the WAL buffers are written out to disk at every transaction commit, so extremely large values are unlikely to provide a significant benefit. However, setting this value to at least a few megabytes can improve write performance on a busy server where many clients are committing at once. The auto-tuning selected by the default setting of -1 should give reasonable results in most cases.
- RE: Protect syscache from bloating with negative cache entries
- AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x
- Re: Protect syscache from bloating with negative cache entries
- Re: explain plans with information about (modified) gucs
- explain plans with information about (modified) gucs