We performed a comparison between Citus Data and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well."
"Its distributed processing capabilities are a standout feature. It requires minimal changes to get up and running if you already have a system on PostgreSQL. Citus can run in its natural state."
"It's very straightforward to implement the solution. It took us two days to set up everything."
"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. "
"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."
"Eighty percent of the ETL operations have improved since implementing this solution."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"The most valuable feature is Vertica's performance and the ease of using the database."
"It has improved my organization's functionality and performance."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"More features in monitoring and the reporting could make it better."
"Citus Data needs to improve its stability. Do not consider this product if you have the budget. It is still developing and has a lot of issues."
"There are many areas of improvement , especially in terms of DDL query routing. Even though it's masterless, DDL queries need to be sent to the coordinator node. Also, setting up a multi-node environment could be more straightforward."
"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."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"The integration with AI has room for improvement."
"The biggest problem is the cost of cloud deployment."
"The integration of this solution with ODI could be improved."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
Citus Data is ranked 18th in Relational Databases Tools with 3 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Citus Data is rated 8.0, while Vertica is rated 8.2. The top reviewer of Citus Data writes "Efficiently handles high-traffic scenarios and compatible with PostgreSQL extensions, offering flexibility in database management". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Citus Data is most compared with YugabyteDB, CockroachDB, Amazon Aurora and SQL Server, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Relational Databases Tools 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.