What is difference purge() and DO_TM_TASK('mergeout') ?
Is the purge mergeout's sub task??
PURGE permanently removes delete vectors from ROS storage containers so disk space can be reused.SELECT DO_TM_TASK('mergeout'); runs a Tuple Mover operation to merge ROS containers.
Purging deleted records in a storage container requires a rewrite of the storage container. Purging deleted records more often than is necessary results in a significant increase in I/O. Because the I/O can increase significantly, Vertica purges deleted records only when storage containers are rewritten by node-based operations, such as:
The mergeout operation merges ROS containers that qualify for mergeout based on a strata algorithm for active partitions and for tables without partitions. During mergeout, the Tuple Mover purges any records from qualifying ROS containers deleted prior to the AHM epoch.
When a new partition is created, the current active partition becomes inactive. ROS containers of the most recent inactive partition are merged into a single ROS container. Records deleted prior the AHM epoch are purged during this process.