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:

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.