Direct copy slower in Vertica in Version 10
We are migrating our Vertica database to Azure and at the same time we're upgrading from version 9.2 to 10.
For our analytic database we bulk load all of our tables daily to Vertica using Pentaho Data Integration. This goes quite well. Only in Version 10 the wide and large table take up far more time to load than in version 9.2.
One of those tables contains 250 million records and has 141 columns.
I've played with the number of maxconcurrency for TM (Tuple Mover) in the resource pool but to no avail.
Does anyone have an idea of where to look to improve the performance of the direct copy using ROS containers?