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

Amazon Redshift vs Vertica comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
6th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
Ranking in other categories
No ranking in other categories
Vertica
Ranking in Cloud Data Warehouse
11th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (8th)
 

Mindshare comparison

As of June 2025, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.4%, down from 8.5% compared to the previous year. The mindshare of Vertica is 5.7%, up from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Sriram-Natesan - PeerSpot reviewer
The ability to create a lot of views or materialized views is beneficial
Improvement in the immediate response and the process of getting into a call could be helpful. We have had to wait for at least twenty-four hours to get a call and then wait for a couple more hours for a solution. Improved connectivity to different BI tools and already published connectors for major tools in AWS could enhance the service.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"The initial setup of this solution is straightforward."
"It allows you write complex queries and perform row by row processes."
"The solution has very competitive pricing."
"Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down."
"The solution is easy to set up and use."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"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."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"I have found the solution to be scalable."
"Its projections and encoding are excellent tools for tuning large volumes."
"The most valuable feature is Vertica's performance and the ease of using the database."
 

Cons

"I rate their support seven out of ten. It's costly when you enable support. The price is high for technical support."
"It is not easy to deal with queries in Amazon Redshift and see the same data."
"Compatibility with other products, for example, Microsoft and Google, is a bit difficult because each one of them wants to be isolated with their solutions."
"The product must provide new indexes that support special data structures or data types like TEXT."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"Should be made available across zones, like other Multi-AZ solutions."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Documentation has become much better, but can always use some improvement."
"The biggest problem is the cost of cloud deployment."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
 

Pricing and Cost Advice

"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"I have heard complaints about the solution’s pricing, and thus I rate it as a five."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"Pricing for Amazon Redshift is reasonable, though it could be somewhat higher than other solutions, such as Azure. Still, when you base your comparison on the services offered and the pricing, it's the most reasonable versus its competitors, such as RDS."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
"The pricing is reasonable."
"The solution is relatively cost-effective."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"The pricing for this solution is very reasonable compared to other vendors."
"The solution is free and we pay for the storage."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
856,873 professionals have used our research since 2012.
 

Answers from the Community

Miriam Tover - PeerSpot reviewer
Jul 16, 2019
Jul 16, 2019
I am assuming you are asking me a question. I have similar points like the one you sent in the link. However, I will narrow it down further with highlighted ones that matter. Redshift is cloud-native so not a good idea if you also need a data center. It does not support document store, so that's another limitation. Vertica works for the hybrid environment and also supports more APIs and suppor...
See 2 answers
KF
Jul 15, 2019
* Flexibility of deployment: Amazon Redshift can only be deployed on the AWS. Redshift lacks support for the hybrid cloud-and-on premises data warehousing combinations. Vertica’s industry-leading deployment options allow customers to run Vertica on AWS, Azure, Google Cloud Platform, on-premise, and on Hadoop. * Speed: The query execution performance of Vertica and Redshift and some of the differentiators in the two products with Vertica query response times on the 5 TB dataset, 20 concurrent user test, for example, were 3.4 times faster. Also, when over 100 users are simultaneously running queries on the same data, Amazon Redshift’s performance degrades considerably, leading to hours or even days of query response times. Which of these two solutions would you recommend to a colleague evaluating cloud data warehouses and why? Vertica. As Vertica has flexibility as your data warehouse evolves long term with best in class speed.
RV
Jul 16, 2019
I am assuming you are asking me a question. I have similar points like the one you sent in the link. However, I will narrow it down further with highlighted ones that matter. Redshift is cloud-native so not a good idea if you also need a data center. It does not support document store, so that's another limitation. Vertica works for the hybrid environment and also supports more APIs and supports all familiar languages. Look at more features as given in the below table and decide. I would go with Vertica if there is a hybrid cloud, needs document store, secondary indexes are a critical need and need support for more APIs (as given in the table). For AWS native environment, go with RedShift. Amazon Redshift X: Description: Large scale data warehouse service for use with business intelligence tools. Primary database model: Relational DBMS Secondary database models: Key-value store Website: aws.amazon.com/­redshift Technical documentation: docs.aws.amazon.com/­redshift Developer: Amazon (based on PostgreSQL) License: commercial Cloud-based only: Yes XML Support: No Secondary indexes: Restricted SQL: Yes APIs and other access methods: JDBC, ODBC Supported programming languages: All languages supporting JDBC/ODBC Server-side scripts: User-defined functions Triggers: No Vertica X: Description: Columnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance. Primary database model: Relational DBMS Secondary database models: Key-value store, Document store Website: www.vertica.com Technical documentation: www.vertica.com/­documentation/­vertica Developer: Vertica / Micro Focus License: Commercial Cloud-based only: No XML Support: Yes Secondary indexes: No SQL: Yes APIs and other access methods: Kafka, Proprietary protocol, RESTful HTTP API, ADO.NET, JDBC, ODBC Supported programming languages: C++, Java, Perl, Python, R Server-side scripts: Yes Triggers: No
 

Top Industries

By visitors reading reviews
Educational Organization
48%
Financial Services Firm
10%
Computer Software Company
8%
Manufacturing Company
4%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
7%
University
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Comparisons

 

Also Known As

No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Amazon Redshift vs. Vertica and other solutions. Updated: May 2025.
856,873 professionals have used our research since 2012.