Configuration / Resource Usage
bgwriter_all_percent
Read the PG 8.2 manualTo reduce the amount of work that will be needed at checkpoint time, the background writer also does a circular scan through the entire buffer pool, writing buffers that are found to be dirty.
Reading PG 8.2·documented in 2 of 24 versions, 8.1 to 8.2
Historical documentation for a PostgreSQL version that is no longer supported.
- Type
- real
- Context
- See manual
- Measured default
- No measurement for this version
- Unit
- —
Definition PG 8.2 manual
To reduce the amount of work that will be needed at checkpoint time, the background writer also does a circular scan through the entire buffer pool, writing buffers that are found to be dirty. In each round, it examines up to bgwriter_all_percent of the buffers for this purpose. The default value is 0.333 (0.333% of the total number of shared buffers). With the default bgwriter_delay setting, this will allow the entire shared buffer pool to be scanned about once per minute. This parameter can only be set in the postgresql.conf file or on the server command line.
Definition snapshot: english-manuals:352c41f450552819bff54df1276… · English manual source