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

Min_Yun_ChanMin_Yun_Chan Vertica Employee Employee
in General Discussion

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

Tagged:

Answers

  • 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...