INSERT speed highly depends on server load
Posted: Sat Nov 14, 2015 1:43 pm
Hi!
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
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 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?
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?