System Resource Consumption Parameters
Memory Consumption Parameters
These parameters control system memory usage. You can adjust gp_vmem_protect_limit to avoid running out of memory at the segment hosts during query processing.
gp_vmem_protect_segworker_cache_limit |
Free Space Map Parameters
These parameters control the sizing of the free space map, which contains expired rows. Use VACUUM to reclaim the free space map disk space.
OS Resource Parameters
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