We performed a comparison between CockroachDB 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."The best feature of CockroachDB is the ability to keep the nodes in different locations."
"The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities."
"I use CockroachDB to test big data samples and to create the best structure for databases. We have four users and required 10 people for deployment and maintenance."
"The product has valuable security features."
"The initial setup and deployment are simple."
"CockroachDB is highly reliable."
"The subset of SQL that my client is using is completely supported."
"The availability and the easy to use feature is the most valuable. The documentation is also good."
"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."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The most valuable feature of Vertica is the unmatchable database performance."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The most valuable feature is Vertica's performance and the ease of using the database."
"We are looking for more features to support distributed high availability and geo-partitioning."
"The initial setup and pricing could be improved."
"The product must improve its disaster recovery features."
"I find the serverless offer a bit confusing."
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."
"CockroachDB needs to improve store processes."
"The platform could be more extensible."
"The closer they can make CockroachDB to being completely compatible with Postgres, the better. It's almost compatible, but not completely. If it was, it would be nice to just be able to use Postgres libraries without any fiddling."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"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."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"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."
CockroachDB is ranked 10th in Relational Databases Tools with 10 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. CockroachDB is rated 8.0, while Vertica is rated 8.2. The top reviewer of CockroachDB writes "Open source with extensive documentation and a University for training". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". CockroachDB is most compared with Oracle Database, MySQL, Citus Data, Amazon Aurora and SQL Server, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and BigQuery.
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.