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.
While Vertica is otherwise stable, sometimes there are issues with restores to the last checkpoint.
I have not encountered any scalability issues.
Customer Service and Technical Support
Technical support is very good and knowledgeable.
I previously used Postgres; switched as performance suffered due to data growth.
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.
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.
Oct 18 2016