You can use multiple connections to load a Vertica database. The optimal number of load streams depends on several factors including the number of nodes, the physical and logical schemas, host processors, memory, disk space, and so forth. Too many load streams can cause systems to run out of memory.
Vertica Systems, Inc. has successfully tested eight streams on four nodes but does not guarantee that you can do the same on your database.
ROS or WOS/ROS?
More limitations or guidelines?