Data Warehouse » Vertica Reviews » Version 9.0 » Review

Vertica Review

Has improved the majority of our ETL operations, but performance degrades seriously for large datasets

What is our primary use case?

We use this solution as our data warehouse. It handles our analytics and we have power users connected.

How has it helped my organization?

Eighty percent of the ETL operations have improved since implementing this solution. Complex queries are challenging to improve.

What is most valuable?

This most valuable feature is the database designer, which helps significantly improve our storage footprint.

What needs improvement?

There is serious performance degradation for large datasets. Fact-to-fact joins on multi-billion record tables perform poorly. Star schema joins also perform poorly if the fact tables reach more than one billion records and the dimension tables reach more than one million records.

For how long have I used the solution?

Two years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Guest
Author
Highlights
Pros
Eighty percent of the ETL operations have improved since implementing this solution.
Cons
Fact-to-fact joins on multi-billion record tables perform poorly.
Sign in to see all reviews and comparisons. It's free!
By clicking Sign in with LinkedIn™ you agree to let IT Central Station use your LinkedIn profile and email address in accordance with our Privacy Policy and agree to the Terms of Service.
Sign Up with Email
  • Unlimited access to 29000+ reviews from real users
  • Your own page to promote your professional skills
  • Join a community of experts to call upon for support
As seen in:

By registering, you agree to our Terms of Service and Privacy Policy.
  • Unlimited access to 29000+ reviews from real users
  • Your own page to promote your professional skills
  • Join a community of experts to call upon for support
As seen in