
- 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 preceding output, notice that the Moveout operation occurs every 300 seconds and the Mergeout operation occurs every 600 seconds.
Helpful Links:
Have fun!