The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Determining depot size

Is it a good rule of thumb to say something like data/node count = depot size? e.g should a 2TB data size and 4 nodes should have 500-600GB depot size for each node?

Sizing and Configuring Vertica in Eon Mode for Different Use Cases
@skeswani @skamat

Answers

  • skeswaniskeswani - Select Field - Employee

    This calculation is fine if you want your entire database to fit in the depot. This is fine for smaller databases.
    However its not necessary. The node count depends on the data that will be accessed/processed by your workload/query, not your entire data.
    For example if you keep yearly data, and usually only access the current and/or last years data.
    Then you can do the same calculation of a years worth of data (data for a year)/nodecount= depot size.

Leave a Comment

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