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."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Vertica is easy to use and provides really high performance, stability, and scalability."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"Very bad support, I would rate it two out of 10."
"Support is an area where it could get better."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"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."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"We faced some challenges when trying to use the temporary tables feature."
"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."
"It should provide a GUI interface for data management and tuning."
Earn 20 points
Actian Ingres is ranked 22nd in Data Warehouse while Vertica is ranked 4th in Data Warehouse with 83 reviews. Actian Ingres is rated 9.0, while Vertica is rated 8.2. 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.