How Loading Works
When you load data into a database, Vertica first moves it into memory (WOS) by default. You can override this default, and specify that Vertica move the data directly to disk (ROS). Periodically, the Tuple Mover:
- Moves data from the WOS to the ROS.
- Combines like-size ROS containers.
- Deletes purges records.
If the you move too much data too frequently to the WOS, the data can spill to disk. No data is lost, but such spillover can cause performance problems.