View Tuple Mover Operation Run-time Intervals

Jim_Knicely

Vertica’s Tuple Mover manages WOS and ROS data storage. To do that it performs two operations:

1. Moveout: Moves data from WOS to ROS.
2. 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.

Example:

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.

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/Glossary/TupleMover.htm
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/TupleMoverParameters.htm

Have fun!