Cost-Based Vacuum Delay Parameters
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.
Cost-Based Vacuum Delay Parameters
You can configure the execution cost of VACUUM and ANALYZE commands to reduce the I/O impact on concurrent database activity. When the accumulated cost of I/O operations reaches the limit, the process performing the operation sleeps for a while, Then resets the counter and continues execution
vacuum_cost_delay vacuum_cost_limit vacuum_cost_page_dirty |
vacuum_cost_page_hit vacuum_cost_page_miss |