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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for