↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Configuration / Resource Usage

bgwriter_lru_percent

Read the PG 8.2 manual

To reduce the probability that server processes will need to issue their own writes, the background writer tries to write buffers that are likely to be recycled soon.

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 probability that server processes will need to issue their own writes, the background writer tries to write buffers that are likely to be recycled soon. In each round, it examines up to bgwriter_lru_percent of the buffers that are nearest to being recycled, and writes any that are dirty. The default value is 1.0 (1% of the total number of shared buffers). This parameter can only be set in the postgresql.conf file or on the server command line.

Version history 3
  1. 8.2 → 8.3 removed
  2. 8.1 → 8.2 changed
  3. 8.0 → 8.1 added

Definition snapshot: english-manuals:723566ce23cb30a99f1e87a4a6e… · English manual source