We performed a comparison between Actian Ingres and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."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."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"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 extensibility and efficiency provided by their C++ SDK."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"The performance is very good and the aggregate records are fast."
"I like the projection feature, which increases query performance."
"The most valuable feature of Vertica is the unmatchable database performance."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"The biggest problem is the cost of cloud deployment."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Very bad support, I would rate it two out of 10."
"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."
"Support is an area where it could get better."
"I have found that coding support could be simplified."
"They could improve on customer service."
Earn 20 points
Actian Ingres is ranked 22nd in Data Warehouse while Vertica is ranked 4th in Data Warehouse with 82 reviews. Actian Ingres is rated 9.0, while Vertica is rated 8.4. The top reviewer of Actian Ingres writes "Good multi-platform SQL compatibility, as well as performance and data integrity". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Actian Ingres is most compared with Snowflake, Oracle Database Appliance, Databricks and Teradata, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.