Re:ClickHouse, Inc.
by fiddlerwoaroof on Monday September 20, 2021 @03:25PM
(#28597744)
I benchmarked ClickHouse vs. Timescale, Citus, Greenplum and Elasticsearch for a real-time analytics application. With a couple hours learning for each (although I’ve used Postgres extensively and so Postgres-backed databases had a bit of an advantage), ClickHouse’s performance was easily an order of magnitude or two better than anything except ES. ES had its own downsides with respect to the queries we could run (which is why we were leaving ES in the first place).
[ Parent
| on HN ]
Re:ClickHouse, Inc.
by eastdakota on Monday September 20, 2021 @10:36PM
(#28601492)
Cloudflare’s analytics have been powered by Clickhouse for a long time. And I was an early investor in Timescale. They’re both excellent products.
Re:ClickHouse, Inc.
by fiddlerwoaroof on Monday September 20, 2021 @11:36PM
(#28601850)
Yeah, I was a little disappointed because I was rooting for Timescale myself. And, maybe if I had spent more time optimizing, I could have made Timescale work but, between our experiments and Cloudflare’s blog post about migrating from Citus to ClickHouse, ClickHouse seemed like the one most likely to hold up for our production workloads.
Re:ClickHouse, Inc.
by someguy101010 on Monday September 20, 2021 @03:57PM
(#28598173)
What did you end up going with?
Re:ClickHouse, Inc.
by fiddlerwoaroof on Monday September 20, 2021 @05:26PM
(#28599216)
ClickHouse deployed to EKS with Clickhouse operator
Re:ClickHouse, Inc.
by germandiago on Monday September 20, 2021 @07:40PM
(#28600428)
I know of a database that claims to perform even faster than that one, It is commercial, though. For very massive data, in a time-series setup basically.
From docs it seems they use forked ClickHouse code.
Re:ClickHouse, Inc.
by germandiago on Tuesday September 21, 2021 @11:42AM
(#28606162)
As far as I understand, they use a part as a frontend, not as a full engine for everything.