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

Actian Ingres vs Amazon Redshift comparison

 

Comparison Buyer's Guide

Executive Summary

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

Actian Ingres
Ranking in Data Warehouse
18th
Average Rating
8.6
Reviews Sentiment
7.9
Number of Reviews
2
Ranking in other categories
Relational Databases Tools (26th)
Amazon Redshift
Ranking in Data Warehouse
5th
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
72
Ranking in other categories
Cloud Data Warehouse (8th), Database Management Systems (DBMS) (9th)
 

Mindshare comparison

As of January 2026, in the Data Warehouse category, the mindshare of Actian Ingres is 1.8%, up from 0.6% compared to the previous year. The mindshare of Amazon Redshift is 4.9%, down from 7.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
Amazon Redshift4.9%
Actian Ingres1.8%
Other93.3%
Data Warehouse
 

Featured Reviews

GH
Sr Sales Engineer at a tech vendor with 10,001+ employees
Reliable performance enhances operations with good technical support
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks and the IRS The most valuable features for us are reliability and performance. Our system is used…
PJ
Data Analytics, Ai & Automation Lead at a venture capital & private equity firm with 10,001+ employees
Performance optimization and scaling adaptations enable efficient data management
Amazon Redshift does not work alone and requires integration with other AWS tools like S3 and Glue for a complete ecosystem. They should bring the entire ETL data management process into Amazon Redshift. Either they should move Amazon Redshift under Glue, or Glue should be brought under Amazon Redshift. The initial setup could also be improved, particularly in terms of sizing, as it requires trial and error to get right.

Quotes from Members

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

Pros

"The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
"The most valuable features for us are reliability and performance."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"Amazon Redshift's performance optimization and scalability are quite helpful, providing functionalities such as scaling up and down."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"It allows you write complex queries and perform row by row processes."
"The product is relatively easy to use because there is no indexing and no partitions."
"I am satisfied with the performance of the product."
"The solution is easy to set up and use."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
 

Cons

"The ability to reset the log file without stopping the DBMS would be helpful for us."
"The seamless integration is a bit of an issue."
"The solution could improve in handling more data formats and more native support for RDF."
"Improvement in the immediate response and the process of getting into a call could be helpful."
"It would be good to see Redshift as a serverless offering."
"During the setup, whenever we try to give any permissions, if I have a data warehouse in Amazon Redshift and want to provide access to a user to just check the data without making any changes, it is a long process to create a policy in Amazon and share it with that policy."
"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 technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"It takes a lot of time to ingest and update the data."
 

Pricing and Cost Advice

Information not available
"It is an expensive product."
"It's pay per use. You can have multiple models."
"The product is cheap considering what it provides; I rate it five out of five for affordability."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"It's not very pricey compared to other tools. I would rate the price as 5 out of 10."
"The best part about this solution is the cost."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
881,082 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
18%
Outsourcing Company
9%
Manufacturing Company
9%
Legal Firm
7%
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
10%
Media Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business27
Midsize Enterprise21
Large Enterprise28
 

Questions from the Community

What needs improvement with Actian Ingres?
The seamless integration is a bit of an issue. I would like to see more direct connectors and stuff like SQLAlchemy. It's there but isn't available as a standard, so it involves going to GitHub to ...
What is your primary use case for Actian Ingres?
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks ...
What is your experience regarding pricing and costs for Actian Ingres?
Initially, it's a lot less expensive than competitors. Price performance has always been a priority, ensuring we remain competitive in the market.
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.
 

Also Known As

Ingres, Ingres 2006
No data available
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Find out what your peers are saying about Actian Ingres vs. Amazon Redshift and other solutions. Updated: January 2026.
881,082 professionals have used our research since 2012.