Set Up Incremental (Trickle) Loads
Once you have a working database, you can use trickle loading to load new data while concurrent queries are running.
Trickle load is accomplished by using the COPY command (without the DIRECT keyword) to load 10,000 to 100,000 rows per transaction into the WOS. This allows Vertica to batch multiple loads when it writes data to disk. While the COPY command defaults to loading into the WOS, it will write ROS if the WOS is full.
See Trickle Loading Data for details.