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 availability and the easy to use feature is the most valuable. The documentation is also good."
"The most valuable features of the solution are its resiliency features and the geo-partitioning capabilities."
"CockroachDB is highly reliable."
"The subset of SQL that my client is using is completely supported."
"The tool's most valuable feature is node syncing, which takes only 0.54 milliseconds."
"The product has valuable security features."
"The best feature of CockroachDB is the ability to keep the nodes in different locations."
"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."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"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."
"I have found the solution to be scalable."
"Allows us to take volumes and process them at a very high speed."
"Its projections and encoding are excellent tools for tuning large volumes."
"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 platform could be more extensible."
"Cockroach does not support all types of protocols. I need to improve it myself to support a CouchDB on my network."
"The product must improve its disaster recovery features."
"The initial setup and pricing could be improved."
"CockroachDB needs to improve store processes."
"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."
"We are looking for more features to support distributed high availability and geo-partitioning."
"I find the serverless offer a bit confusing."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"They could improve the integration and some of the features in the cloud version."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"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."
"The geospatial functionality could be designed better."
"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 would be great if this were a managed service in AWS."
"When it is about to reach the maximum storage capacity, it becomes slow."
CockroachDB is ranked 9th in Relational Databases Tools with 10 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. CockroachDB is rated 8.0, while Vertica is rated 8.4. 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 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.