Vertica Pros and Cons

Vertica Pros

Trevor Watkins
Managing Partner at Thorium Data Science
The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage.
View full review »
it_user114084
Co-Founder at a tech services company
The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors.
I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution.
View full review »
Jan-Soubusta
Sr. SW Engineer - Databases with 201-500 employees
Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance.
View full review »
François Jehl
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees
The extensibility and efficiency provided by their C++ SDK.
View full review »
Alberto Guisande
Director at Decision Science
Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.
Allows us to take volumes and process them at a very high speed.
View full review »
Alfonso Licir
Technical Leader / Business Intelligence Consultant with 11-50 employees
Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data.
View full review »
Fahd Mirza Chughtai
Cloud Architect, Oracle ACE, Oracle DBA at Pythian
Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI.
View full review »
Luis Henriquez
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees
It maximize cloud economics for mission-critical big data analytical initiatives.
It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands.
View full review »
Han Nguyen
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees
Partition and join back to node are easy and simple for DBAs.
DBAs don’t need to add a partition every month/quarter like with other DBs.
View full review »
Dan Wities
Bi Group Manager at a tech company with 201-500 employees
Vertica gives knowledgeable users and DBAs excellent tools for tuning.
Its projections and encoding are excellent tools for tuning large volumes.
View full review »

Vertica Cons

Trevor Watkins
Managing Partner at Thorium Data Science
I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support.
View full review »
Jan-Soubusta
Sr. SW Engineer - Databases with 201-500 employees
Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata.
Suboptimal projection design causes queries to not scale linearly.
Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes.
View full review »
François Jehl
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees
Whatever's out, the core is not always as great as the engine, especially their first version.
View full review »
Alberto Guisande
Director at Decision Science
Support is an area where it could get better.
Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.
View full review »
Alfonso Licir
Technical Leader / Business Intelligence Consultant with 11-50 employees
I believe the installation process could be streamlined.
View full review »
Fahd Mirza Chughtai
Cloud Architect, Oracle ACE, Oracle DBA at Pythian
One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility.
View full review »
Luis Henriquez
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees
It needs integration with multiple clouds.
View full review »
Han Nguyen
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees
There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs.
Very bad support, I would rate it two out of 10.
View full review »
Dan Wities
Bi Group Manager at a tech company with 201-500 employees
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.
View full review »
it_user431877
Consultant at a tech services company with 10,001+ employees
Limitations in group by projections is where I would like to see an improvement.
View full review »

Sign Up with Email