We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Question About COPY command in 3 nodes Cluster vs 1 standalone node — Vertica Forum

Question About COPY command in 3 nodes Cluster vs 1 standalone node

edited July 2017 in General Discussion

I have 3 nodes cluster and a standalone node too and want to test load data with COPY command in each of them ...

I have 10 files with 1 million rows and put them into first node of cluster and also in standalone node .

COPY command in 3 node cluster and standalone for same file, takes 50 second ...
so I don't see any optimization in 3 node Cluster
what is the problem ?

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file