CONCEPTS: Tuple Mover, Mergeout, Moveout

Tuple Mover:

The Tuple Mover (TM) is the HP Vertica database optimizer component that

• moves data from memory (WOS) to disk (ROS). (called moveout operation)

• combines small ROS containers into larger ones, (called mergeout operation)

• and purges deleted data. (called mergeout operation)

During moveout operations, the TM is also responsible for adhering to any storage policies that are in effect for the storage location. The Tuple Mover runs in the background, performing some tasks automatically (ATM) at time intervals determined by its configuration parameters. 

Mergeout:

A mergeout is the

• process of consolidating ROS containers(Smaller, scattered ROS containers are grouped to larger ones) and
• purging deleted records. (Deleted Records older than AHM)

Moveout

Moveout operations move data from memory (WOS) into a new ROS container. A moveout "flushes" all historical data from the WOS to the ROS.