Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

case studies and performance benchmark

edited July 2019 in General Discussion

Hallo.

Do you have case studies and benchmark tests on Vertica for star schema joins and aggregate queries where fact tables are >1B and dimension tables are >100M records that I can access? If it's not public or free information, will I be granted access if I have a license/contract number with Vertica?

My objective here is I want to know what is normal processing time and resource consumption for Vertica for huge tables on join and aggregate operations. I want to be able to look at the explain plan (verbose) and see resources consumption and say, this is too much for this operation, there's something wrong.

Thanks.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.