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

Actian Ingres 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

Actian Ingres
Ranking in Data Warehouse
16th
Average Rating
8.6
Reviews Sentiment
7.9
Number of Reviews
2
Ranking in other categories
Relational Databases Tools (27th)
Vertica
Ranking in Data Warehouse
5th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (11th)
 

Mindshare comparison

As of April 2025, in the Data Warehouse category, the mindshare of Actian Ingres is 0.8%, up from 0.5% compared to the previous year. The mindshare of Vertica is 8.6%, down from 8.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

GH
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…
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 for us are reliability and performance."
"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 initial setup was straightforward."
"Allows us to take volumes and process them at a very high speed."
"The extensibility and efficiency provided by their C++ SDK."
"I like the projection feature, which increases query performance."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Its projections and encoding are excellent tools for tuning large volumes."
"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."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
 

Cons

"The seamless integration is a bit of an issue."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"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."
"The biggest problem is the cost of cloud deployment."
"It needs integration with multiple clouds."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"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."
"The integration of this solution with ODI could be improved."
"It should provide a GUI interface for data management and tuning."
 

Pricing and Cost Advice

Information not available
"I am aware that we have licensed it, but I have no knowledge of its cost."
"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"Vertica is an expensive tool."
"The pricing for this solution is very reasonable compared to other vendors."
"The solution is relatively cost-effective."
"It is fast to purchase through the AWS Marketplace."
"Read the fine print carefully."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Government
11%
Educational Organization
9%
Insurance Company
9%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
7%
University
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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.
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

Ingres, Ingres 2006
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Actian Ingres vs. Vertica and other solutions. Updated: April 2025.
846,617 professionals have used our research since 2012.