11–20 of 187 posts
I'd love to hear from someone who has implemented this in production. Seems like really cool tech, but haven't had a chance to use it on a project yet.
Using it in production currently with dual-write and dual-read to compare perf. I'll do a write-up showing how Cockroach performs to Citus and Cassandra for my use case.
What drug was the person who drew that graphic on?
Earlier quoted context omitted.
Using it in production currently with dual-write and dual-read to compare perf. I'll do a write-up showing how Cockroach performs to Citus and Cassandra for my use case.
We use Citus and Memsql (big data analytics use cases). How does Cockroach handle joins and other OLAP style queries?
Earlier quoted context omitted.
Using it in production currently with dual-write and dual-read to compare perf. I'll do a write-up showing how Cockroach performs to Citus and Cassandra for my use case.
We use Citus and Memsql (big data analytics use cases). How does Cockroach handle joins and other OLAP style queries?
Citus is great if you want the Postgres interface but is still using standard rowstore tables. CockroachDB is similar with rowstore performance but with added distributed consensus overhead. They are both much better for OLTP and sharding. CockroachDB also provides easy high-availability and replication.
(PS: As expected ppl will downvote this, but just trying to give a very valuable feedback to ppl who don’t understand cockroach phobia.)
Earlier quoted context omitted.
Using it in production currently with dual-write and dual-read to compare perf. I'll do a write-up showing how Cockroach performs to Citus and Cassandra for my use case.
We use Citus and Memsql (big data analytics use cases). How does Cockroach handle joins and other OLAP style queries?
Earlier quoted context omitted.
We use Citus and Memsql (big data analytics use cases). How does Cockroach handle joins and other OLAP style queries?
You're not going to get better performance for OLAP than MemSQL's columnstore and in-memory rowstore for reference tables to join. Citus is great if you want the Postgres interface but is still using standard rowstore tables. CockroachDB is similar with rowstore performance but with added distributed consensus overhead. They are both much better for OLTP and sharding. CockroachDB also provides easy high-availability…
Earlier quoted context omitted.
We use Citus and Memsql (big data analytics use cases). How does Cockroach handle joins and other OLAP style queries?
We use clickhouse cluster with 1000 nodes and 50000 GB clickstream data.