Vertica Review

Its projections and encoding are excellent tools for tuning large volumes

What is our primary use case?

We push both raw and modeled data into a Vertica cluster. It is used mainly for internal analysis and Tableau reports by data scientists and analysts.

How has it helped my organization?

It is tremendously scalability, with excellent performance. Vertica gives knowledgeable users and DBAs excellent tools for tuning.

What is most valuable?

  • Its projections and encoding are excellent tools for tuning large volumes.
  • The product is simple and elegant.
  • It has excellent written documentation. I am able to answer any question by querying on Google.

What needs improvement?

You need to know what you are doing to get the most out of Vertica. If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer.

It would be great if this were a managed service in AWS.

For how long have I used the solution?

Three to five years.

Which version of this solution are you currently using?

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Vertica reviews from users
...who work at a Computer Software Company
...who compared it with Teradata
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: May 2021.
511,607 professionals have used our research since 2012.
Add a Comment
ITCS user