I faced a problem with very slow
I made such test: create empty table with no projections and start inserting in it in batch, using
> INSERT INTO table SELECT 111,222,333 UNION ALL SELECT 444,555,666 UNION ALL SELECT 777,888,999;
1000 rows in one query.
On idle server one query runs about 2sec and it's alright, but then I start generating some load making
SELECTs (not very big load though, about 10 LA on 32 core server) and
INSERTs start to performs 20x slower ( 40-60 sec each 1000 rows
INSERT). It's too slow for my conditions. What can I do besides copying files to Vertica server and make COPY which seems to perform good, but too complicated?