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."
"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 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."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"The product's initial setup phase is extremely simple."
"I enjoy the cybersecurity and backup features."
"More features in monitoring and the reporting could make it better."
"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."
"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."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Support is an area where it could get better."
"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."
"They could improve the integration and some of the features in the cloud version."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"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 82 reviews. Citus Data is rated 8.0, while Vertica is rated 8.4. 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, SQL Server and Oracle Multitenant, 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.