Edit

HorizonDB - Resource Usage / Background Writer

bgwriter_delay

Attribute Value
Category Resource Usage / Background Writer
Description Background writer sleep time between rounds.
Data type integer
Default value 20
Allowed values 10-10000
Parameter type static
Documentation bgwriter_delay

bgwriter_flush_after

Attribute Value
Category Resource Usage / Background Writer
Description Number of pages after which previously performed writes are flushed to disk.
Data type integer
Default value 64
Allowed values 0-256
Parameter type static
Documentation bgwriter_flush_after

bgwriter_lru_maxpages

Attribute Value
Category Resource Usage / Background Writer
Description Background writer maximum number of LRU pages to flush per round.
Data type integer
Default value 100
Allowed values 0-1073741823
Parameter type static
Documentation bgwriter_lru_maxpages

bgwriter_lru_multiplier

Attribute Value
Category Resource Usage / Background Writer
Description Multiple of the average buffer usage to free per round.
Data type numeric
Default value 2
Allowed values 0-10
Parameter type static
Documentation bgwriter_lru_multiplier