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: EPAS 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_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.