Vertica Pros and Cons

Vertica Pros

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 »
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 »
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse. Updated: September 2019.
370,827 professionals have used our research since 2012.
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 »
it_user431877
Consultant at a tech services company with 10,001+ employees
I like the projection feature, which increases query performance.
View full review »
Srikanth Potluri
Architect at a tech services company with 51-200 employees
Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics.
Any novice user can tune vertical queries with minimal training (or no training at all).
View full review »

Vertica Cons

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 »
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 »
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse. Updated: September 2019.
370,827 professionals have used our research since 2012.
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 »
Srikanth Potluri
Architect at a tech services company with 51-200 employees
It should provide a GUI interface for data management and tuning.
Monitoring tools need to be lightweight. They should not take up heavy resources of the main server.
View full review »
Ben Santos
Sr. Business Intelligence Analyst / Developer with 10,001+ employees
Fact-to-fact joins on multi-billion record tables perform poorly.
View full review »
Find out what your peers are saying about Micro Focus, Oracle, Teradata and others in Data Warehouse. Updated: September 2019.
370,827 professionals have used our research since 2012.
Sign Up with Email