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."It's very straightforward to implement the solution. It took us two days to set up everything."
"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."
"You can use Citus Data to write complex scripts. I like its version upgrades and disaster recovery as well."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"I have found the solution to be scalable."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"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."
"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."
"Limitations in group by projections is where I would like to see an improvement."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"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."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"When it is about to reach the maximum storage capacity, it becomes slow."
"The integration of this solution with ODI could be improved."
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.