I faced a problem with very slow INSERTs.
I made such test: create empty table with no projections and start inserting in it in batch, using
Code: Select all
INSERT INTO table SELECT 111,222,333 UNION ALL SELECT 444,555,666 UNION ALL SELECT 777,888,999;
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 machine) 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?