Try our new research platform with insights from 80,000+ expert users
Vertica Logo

Vertica pros and cons

Vendor: OpenText
4.1 out of 5
2,617 followers
Post review
 

Vertica Pros review quotes

SO
Sep 18, 2020
Speed and resiliency are probably the best parts of this product.
it_user453681 - PeerSpot reviewer
Jun 21, 2016
The fast columnar store database structure allows our query times to be at least 10x faster than on any other database.
reviewer2323428 - PeerSpot reviewer
Apr 11, 2024
The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
reviewer2132406 - PeerSpot reviewer
Mar 20, 2023
I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data.
JG
Dec 18, 2020
The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.
it_user428343 - PeerSpot reviewer
Jul 20, 2017
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.
reviewer1355733 - PeerSpot reviewer
Sep 13, 2020
For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.
reviewer1355733 - PeerSpot reviewer
Oct 29, 2021
Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation.
it_user114084 - PeerSpot reviewer
Dec 26, 2017
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.
Sima Alexandru - PeerSpot reviewer
Nov 8, 2023
The product's initial setup phase is extremely simple.
 

Vertica Cons review quotes

SO
Sep 18, 2020
The geospatial functionality could be designed better.
it_user453681 - PeerSpot reviewer
Jun 21, 2016
Documentation has become much better, but can always use some improvement.
reviewer2323428 - PeerSpot reviewer
Apr 11, 2024
In our company, we have faced difficulties in scaling the solution for certain use cases.
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
816,406 professionals have used our research since 2012.
reviewer2132406 - PeerSpot reviewer
Mar 20, 2023
In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform.
JG
Dec 18, 2020
They could improve on customer service.
it_user428343 - PeerSpot reviewer
Jul 20, 2017
I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support.
reviewer1355733 - PeerSpot reviewer
Sep 13, 2020
Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.
reviewer1355733 - PeerSpot reviewer
Oct 29, 2021
Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible.
Sima Alexandru - PeerSpot reviewer
Nov 8, 2023
The documentation of Vertica is an area with shortcomings where improvements are required.
ERICK RAMIREZ - PeerSpot reviewer
Jun 3, 2024
Pricing could be more competitive.