The auto-distribution to all nodes for fault tolerance and query performance was pretty amazing.
OpenText Analytics Database Vertica enhances data processing with swift queries, scalability, and efficient compression, optimally managing enterprise-level data with minimal storage.

| Author info | Rating | Review Summary |
|---|---|---|
| Database Administrator (DBA) at a computer software company with 501-1,000 employees | 4.0 | I found Vertica excellent for large-scale, columnar data with great auto-distribution and customer service. Early versions had setup challenges, and heavy, sustained loading across many nodes could dramatically decrease performance due to data shuffling. |
The auto-distribution to all nodes for fault tolerance and query performance was pretty amazing.
Our data warehouse at the time was a multi-terabyte PostgreSQL cluster. It worked really well, but we wanted to increase the size to many TB's and our due to our query and loading patterns we found greater performance from Vertica's multi-node warehouse.
In the versions I worked with, if a majority of the nodes were being loaded under heavy, sustained rates the nodes would see some dramatic decreases in performance due to the data shuffling that needed to occur between all the nodes. To work around that we ended up doing most of the loading in one or two nodes and that helped significantly.
The synchronizations problems occurred when loading about 10 billion events, at a rate of about 100k tuples/second/node across 5 nodes. One of the suggestions from Vertica engineering was to increase the number of nodes to offset how much data was being sync'd per node.
Extensive use of Vertica 5 as a production datawarehouse, and a POC for a client.
In earlier versions Vertica, it could sometimes be a pain to install on multiple nodes. In the most recent versions most of that pain has been fixed. Stability in earlier versions was compromised at times when the majority of the nodes were under heavy write loads.
The service and support from Vertica was excellent. Every tech and sales rep I dealt with was very responsive, pleasant, and helped me solve any engineering issues we ran into in very short order.
I have used Greenplum and Postgres extensively. The latter is an excellent general-purpose database and is entirely suitable for most data needs, however Vertica works really well in cases where you are storing and querying a lot of data that can be compressed and stored in columnar format, and you need your data auto-balanced across many nodes.
The installation procedure was reasonably straightforward, but earlier versions of Vertica were a bit more tricky due to libraries and dependencies. The docs were unclear in a few places during the installation, particularly with OS' that were not fully compatible with the required libraries. I expect those issues have been resolved in the newest version (8 at this time).
Implementation was done in-house, with excellent support from the Vertica engineers.
My advice is to clearly define your expectations, and benchmark performance in real-world-like environments. If you expect to be executing 100 queries per second and loading 10 million tuples per minute, then test that, and test several times that so you collect measurements about where the system is liable to break down.
| Product | Mindshare (%) |
|---|---|
| OpenText Analytics Database (Vertica) | 6.5% |
| Teradata | 9.1% |
| Snowflake | 8.8% |
| Other | 75.6% |
| Company Size | Count |
|---|---|
| Small Business | 24 |
| Midsize Enterprise | 20 |
| Large Enterprise | 30 |
| Company Size | Count |
|---|---|
| Small Business | 336 |
| Midsize Enterprise | 97 |
| Large Enterprise | 238 |
OpenText Analytics Database Vertica provides high availability clustering, columnar storage, and parallel processing to deliver fast data ingestion and real-time insights. Projections improve performance and simplify query tuning. The Management Console assists with administration, and integration with BI tools streamlines analytics. Adapted for handling large data volumes, Vertica supports data warehousing, ETL, geospatial analysis, and operational reporting across sectors such as media, finance, and telecom.
What are the most important features of OpenText Analytics Database Vertica?Organizations in media, finance, and telecom rely on Vertica's capabilities to integrate with Power BI and Tableau, facilitating advanced data analytics and machine learning for business improvements. Its support for ETL processes, real-time processing, and geospatial analysis positions Vertica as critical for operational reporting and decision support systems.
OpenText Analytics Database (Vertica) was previously known as Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand.
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.