performance consideration for bulk loading

Moderator: NorbertKrupa

Post Reply
hoseiney
Newbie
Newbie
Posts: 1
Joined: Wed Jul 12, 2017 4:39 pm

performance consideration for bulk loading

Post by hoseiney » Wed Jul 12, 2017 4:51 pm

We have 1 Node Vertica Database ...
how can we increase performance for loading data using COPY command in vertica?
based on our tests, in a server with 2 CPU core and 8 GB RAM, loading a json file with 1 million (900 MB size) takes 70 seconds, same file in a server with 128 GB RAM and 32 CPU core takes 30 seconds...
if we want for example loading this file takes 10 seconds what we should do ?

Post Reply

Return to “Vertica Performance Tuning”