How does Cockroach DB work as a data warehouse database? Are there any use cases / comparisons against, say Oracle or SQL Server?
A data warehouse workload is considered an Analytics/OLAP type workload. At the moment CockroachDB isn’t optimized for these types of workloads. However we always encourage people to try us out and let us know what they find, you may our performance suitable for your specific use case.
We are constantly improving our support for workloads like TPCH which is a benchmark for OLAP workloads, and we hope to be a solution for analytical workloads in the future.