Resource Usage / Cost-Based Vacuum Delay

vacuum_cost_delay

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description the amount of time (in milliseconds) that the vacuum process will sleep when the cost limit has been exceeded.
Data type integer
Default value 0
Allowed values 0-100
Parameter type dynamic
Documentation vacuum_cost_delay

vacuum_cost_limit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The accumulated cost that will cause the vacuuming process to sleep.
Data type integer
Default value 200
Allowed values 1-10000
Parameter type dynamic
Documentation vacuum_cost_limit

vacuum_cost_page_dirty

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost charged when vacuum modifies a block that was previously clean.
Data type integer
Default value 20
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_dirty

vacuum_cost_page_hit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer found in the shared buffer cache.
Data type integer
Default value 1
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_hit

vacuum_cost_page_miss

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer that must be read from disk.
Data type integer
Default value 10
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_miss

vacuum_cost_delay

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description the amount of time (in milliseconds) that the vacuum process will sleep when the cost limit has been exceeded.
Data type integer
Default value 0
Allowed values 0-100
Parameter type dynamic
Documentation vacuum_cost_delay

vacuum_cost_limit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The accumulated cost that will cause the vacuuming process to sleep.
Data type integer
Default value 200
Allowed values 1-10000
Parameter type dynamic
Documentation vacuum_cost_limit

vacuum_cost_page_dirty

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost charged when vacuum modifies a block that was previously clean.
Data type integer
Default value 20
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_dirty

vacuum_cost_page_hit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer found in the shared buffer cache.
Data type integer
Default value 1
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_hit

vacuum_cost_page_miss

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer that must be read from disk.
Data type integer
Default value 10
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_miss

vacuum_cost_delay

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description the amount of time (in milliseconds) that the vacuum process will sleep when the cost limit has been exceeded.
Data type integer
Default value 0
Allowed values 0-100
Parameter type dynamic
Documentation vacuum_cost_delay

vacuum_cost_limit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The accumulated cost that will cause the vacuuming process to sleep.
Data type integer
Default value 200
Allowed values 1-10000
Parameter type dynamic
Documentation vacuum_cost_limit

vacuum_cost_page_dirty

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost charged when vacuum modifies a block that was previously clean.
Data type integer
Default value 20
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_dirty

vacuum_cost_page_hit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer found in the shared buffer cache.
Data type integer
Default value 1
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_hit

vacuum_cost_page_miss

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer that must be read from disk.
Data type integer
Default value 10
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_miss

vacuum_cost_delay

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description the amount of time (in milliseconds) that the vacuum process will sleep when the cost limit has been exceeded.
Data type integer
Default value 0
Allowed values 0-100
Parameter type dynamic
Documentation vacuum_cost_delay

vacuum_cost_limit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The accumulated cost that will cause the vacuuming process to sleep.
Data type integer
Default value 200
Allowed values 1-10000
Parameter type dynamic
Documentation vacuum_cost_limit

vacuum_cost_page_dirty

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost charged when vacuum modifies a block that was previously clean.
Data type integer
Default value 20
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_dirty

vacuum_cost_page_hit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer found in the shared buffer cache.
Data type integer
Default value 1
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_hit

vacuum_cost_page_miss

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer that must be read from disk.
Data type integer
Default value 10
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_miss

vacuum_cost_delay

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description the amount of time (in milliseconds) that the vacuum process will sleep when the cost limit has been exceeded.
Data type integer
Default value 0
Allowed values 0-100
Parameter type dynamic
Documentation vacuum_cost_delay

vacuum_cost_limit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The accumulated cost that will cause the vacuuming process to sleep.
Data type integer
Default value 200
Allowed values 1-10000
Parameter type dynamic
Documentation vacuum_cost_limit

vacuum_cost_page_dirty

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost charged when vacuum modifies a block that was previously clean.
Data type integer
Default value 20
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_dirty

vacuum_cost_page_hit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer found in the shared buffer cache.
Data type integer
Default value 1
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_hit

vacuum_cost_page_miss

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer that must be read from disk.
Data type integer
Default value 10
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_miss

vacuum_cost_delay

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description the amount of time (in milliseconds) that the vacuum process will sleep when the cost limit has been exceeded.
Data type integer
Default value 0
Allowed values 0-100
Parameter type dynamic
Documentation vacuum_cost_delay

vacuum_cost_limit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The accumulated cost that will cause the vacuuming process to sleep.
Data type integer
Default value 200
Allowed values 1-10000
Parameter type dynamic
Documentation vacuum_cost_limit

vacuum_cost_page_dirty

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost charged when vacuum modifies a block that was previously clean.
Data type integer
Default value 20
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_dirty

vacuum_cost_page_hit

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer found in the shared buffer cache.
Data type integer
Default value 1
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_hit

vacuum_cost_page_miss

Attribute Value
Category Resource Usage / Cost-Based Vacuum Delay
Description The estimated cost for vacuuming a buffer that must be read from disk.
Data type integer
Default value 10
Allowed values 0-10000
Parameter type dynamic
Documentation vacuum_cost_page_miss