View Tuple Mover Operation Run-time Intervals
Vertica’s Tuple Mover manages WOS and ROS data storage. To do that it performs two operations:
- Moveout: Moves data from WOS to ROS.
- Mergeout: Combines small ROS containers into larger ones and purges deleted data.
The Tuple Mover operations are controlled by a set of configurable parameters. To quickly view the relevant parameter’s current values, you can call the LIST_SERVICES function.
dbadmin=> \a Output format is unaligned. dbadmin=> select list_services('TM'); list_services Service: 'AnalyzeRowCount' is enabled , interval 86400 second(s) Service: 'LGELaggingCheck' is enabled , interval 300 second(s) Service: 'ManageEpochs' is enabled , interval 180 second(s) Service: 'PartitionTables' is disabled , interval 3000 second(s) Service: 'RebalanceCluster' is enabled , interval 300 second(s) Service: 'TM Moveout' is enabled , interval 300 second(s) Service: 'TM Mergeout' is enabled , sub-services: Service: 'TM Mergeout(00)' is enabled , interval 600 second(s) Service: 'TM Mergeout(01)' is enabled , interval 600 second(s) (1 row)
From the output above, we see that the Moveout operation occurs every 300 seconds and Mergeout operation occurs every 600 seconds.