Vertica Review

Columnar database supports our advanced analytics and ETL process

How has it helped my organization?

Before we used Vertica we used another columnar database which turned out to be very unstable and its performance was inconsistent. Vertica turned that around, to the point that it is now our go-to database. We became Vertica partners.

What is most valuable?

Vertica is a columnar database, this support our developments in analytics, advanced analytics, and our ETL process with large sets of data.

What needs improvement?

I believe the installation process could be streamlined.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

No stability issues.

What do I think about the scalability of the solution?

No scalability issues.

How are customer service and technical support?

They are very professional and responsive.

Which solution did I use previously and why did I switch?

See "Improvements to organization," above.

How was the initial setup?

There are some considerations to be evaluated before you start the installation, but the installer does the respective checks so things will function properly. And there are a lot of options.

What's my experience with pricing, setup cost, and licensing?

The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation.

Which other solutions did I evaluate?

Infobright and MonetDB.

What other advice do I have?

The technical requirements for the product are really important. The design tool for vertica is the core of the database for performance. Never forget to use it to create projections to optimize the storage compression and response times. Better compression means the 1TB mark takes longer to be reached.

Which version of this solution are you currently using?

**Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
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.
512,711 professionals have used our research since 2012.
Add a Comment
ITCS user