bgwriter_delay v17

Parameter type: Integer

Default value: 200ms

Range: 10ms to 10000ms

Minimum scope of effect: Cluster

When value changes take effect: Reload

Required authorization to activate: EDB Postgres Advanced Server service account

Specifies the delay between activity rounds for the background writer. In each round, the writer issues writes for some number of dirty buffers. (You can control the number of dirty buffers using the bgwriter_lru_maxpages and bgwriter_lru_multiplier parameters.) It then sleeps for bgwriter_delay milliseconds, and repeats.

On many systems, the effective resolution of sleep delays is 10ms. Setting bgwriter_delay to a value that isn't a multiple of 10 might have the same results as setting it to the next higher multiple of 10.

Typically, when tuning bgwriter_delay, you reduce it from its default value. This parameter is rarely increased. Saving on power consumption on a system with very low use is one case when you might increase the value.