View Tuple Mover Operation Run-time Intervals

Posted February 26, 2019 by Jim Knicely, Vertica Principal Solution Architect

Vertica’s Tuple Mover manages WOS and ROS data storage. To do that, the Tuple Mover 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.
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 preceding output, notice that the Moveout operation occurs every 300 seconds and the Mergeout operation occurs every 600 seconds.

Helpful Links:


Have fun!