Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Resource and time to copy schema & tables into another cluster?

In Eon Mode, if I want to copy schema/tables into another cluster, how much time and resources will be used? If my raw data is 40T for example.

@dsprogis @ybei
Question from Eon Mode: Past, Present, Future


  • dsprogisdsprogis Employee

    The time to move data from one cluster to another cluster is not really impacted by the mode (Eon or Enterprise), it is impacted by the bandwidth that connects the clusters. This is a time and distance problem. You could compute the bandwidth and do the math but with handshakes and collisions you are unlikely to get the full pipe. I would run a test COPY of 1TB, review the time then multiply by the total size of the DB (40T).

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.