Cost-Based Vacuum Delay Parameters

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.

Cost-Based Vacuum Delay Parameters

Warning: Using cost-based vacuum delay is discouraged because it runs
asynchronously among the segment instances. The vacuum cost limit and delay is invoked at
the segment level without taking into account the state of the entire Greenplum
array.

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