Vertica Review

It delivers speed and performance in query response time. Complicated multi-table queries perform well.

Valuable Features

Speed and performance: Vertica stands top among its peers in the MPP world, delivering unparalleled speed and performance in query response time. Its distributed architecture and use of projection (materialized version of data) beats most of its competitors.

Improvements to My Organization

This product is used for in-database analytics for reports and queries that require very fast response times. Complicated multi-table queries perform very well, and the company has improved on business operations looking at hot data from various dimensions.

Room for Improvement

Projections take up a lot of space and hence, compression can be improved. Installation can be more intuitive via a simple, lightweight web client instead of the command line.

Use of Solution

I have used it for two years.

Stability Issues

While Vertica is otherwise stable, sometimes there are issues with restores to the last checkpoint.

Scalability Issues

I have not encountered any scalability issues.

Customer Service and Technical Support

Technical support is very good and knowledgeable.

Previous Solutions

I previously used Postgres; switched as performance suffered due to data growth.

Initial Setup

Initial setup was straightforward through the command line.

Pricing, Setup Cost and Licensing

Negotiate; with HDFS, storage is cheap. Vertica charges per terabyte of compressed data. But the underlying architecture materializes data in a different order and hence space utilization is always heavy, even for a single table; add to that the replication factor.

Other Solutions Considered

Before choosing this product, we evaluated Netezza and ParAccel.

Other Advice

Make sure the data and table structures are compact. Vertica will create many versions of the same data as a projection and isolated tables will increase size, increasing licensing cost.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email