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.
Question from Eon Mode: Past, Present, Future
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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).