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

Min_Yun_ChanMin_Yun_Chan Vertica Employee Employee

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


  • Options
    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