Eon Mode - Performance if data is not in the Depot and policy to rehydrate

Min_Yun_ChanMin_Yun_Chan Vertica Employee Employee

I imagine that performance will be compromised if the data queried is not in the Depot - is this correct?
What is the policy to rehydrate the Depot?



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

Answers

  • fxingfxing Employee

    Hi,
    If the data queried is in the depot, especially for I/O bound queries, the performance is better than querying against communal storage location(when data is not in the depot). We have observed 2-3 times faster when comparing querying against depot vs. querying against communal storage for certain types of queries, this depends on data volume and query types, for other workloads, there might be more performance benefits if the data queried is in Depot.

    There are some scenarios that depot can be re-hydrated:

    • When a new node is added into the cluster or subcluster, depot warming may happen in background, Vertica will fetch data from communal storage by default.
    • When a query runs, but the data it references does not present in the depot, the query will run against communal storage first, under the over, there Vertica can fetch the data from communal storage to the local depot, once the data files are fetched into depot successfully, the subsequent runs of queries that reference to those data will benefit from depot.

    Hope this help, please feel free to let us know if you have further questions.

    Thanks, Fang

  • Jan_SoubustaJan_Soubusta Vertica Customer

    2 - 3 x slower?
    Is this valid only for AWS (S3) deployment?
    I expect in case of Pure storage the degradation is negligible.
    Do you have any numbers for setup with Minio storage?

  • [Deleted User][Deleted User] Administrator

    In depot query performance is always going to better than communal storage in all Eon deployments cloud and in premise. Differences always depends on complexity of query and amount of data processed. Depot plays key role as performance booster for all Eon deployments and we recommend customers to take advantage of depot that is on local attached storage.

Leave a Comment

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