News for hackers. Stuff that matters.
Re:ClickHouse raises $350M Series C by fishtoaster on Thursday May 29, 2025 @01:05PM (#44128003)
Yep. Clickhouse is absolutely great for tons of production use cases.

Unless you try to join tables in it, in which case it will immediately explode.

More seriously, it's a columnar data store, not a relational database. It'll definitely pretend to be "postgres but faster", but that's a very thin and very leaky facade. You want to do massively a complex set of selects and conditional sums over one table with 3b rows and tb of data? You'll get a result in tens of seconds without optimization. You want to join two tables that postgres could handle easily? You'll OOM a machine with TB of memory.

So: good for very specific use cases. If you have those usecases, it's great! If you don't, use something else. Many large companies have those use cases.

Re:ClickHouse raises $350M Series C by Boxxed on Thursday May 29, 2025 @02:12PM (#44128644)
Yeah I think that's a good summary. For instance, clickbench is comprised of >40 queries and there's not a single join in them: https://github.com/ClickHouse/ClickBench/blob/main/clickhous...
Re:ClickHouse raises $350M Series C by zX41ZdbW on Saturday May 31, 2025 @09:55PM (#44148139)
There is the "versions benchmark," which includes a lot of queries with JOINs and compares ClickHouse performance on them: https://benchmark.clickhouse.com/versions/
Re:ClickHouse raises $350M Series C by Boxxed on Tuesday June 03, 2025 @09:08AM (#44169640)
I don't think that's right, it looks to be a set of 43 queries with zero joins: https://github.com/ClickHouse/ClickBench/blob/main/versions/...
Re:ClickHouse raises $350M Series C by zX41ZdbW on Tuesday June 03, 2025 @11:57AM (#44171407)
Here are 75 queries from various benchmarks, that form the version benchmark: https://benchmark.clickhouse.com/versions/
Re:ClickHouse raises $350M Series C by Boxxed on Monday June 09, 2025 @01:18PM (#44226706)
Did you look at the queries? There is not a single join in any of them.
Re:ClickHouse raises $350M Series C by adrian17 on Thursday May 29, 2025 @02:44PM (#44128950)
The majority of our queries have joins (plus our core logic often depends on fact table expansion with `arrayJoin()`s) before aggregations and we're doing fine. AFAIK whenever we hit memory issues, they are mostly due to high-cardinality aggregations (especially with uniqExact), not joins. But I'm sure it can depend on the specifics.
Re:ClickHouse raises $350M Series C by legorobot on Thursday May 29, 2025 @03:12PM (#44129215)
Definitely agree with this, I think ClickHouse can do a lot with joins if you don't implement them naively. Keeping the server up-to-date is a part of it too.

They've made strides in the last year or two to implement more join algorithms, and re-order your joins automatically (including whats on the "left" and "right" of the join, relating to performance of the algorithm).

Their release notes cover a lot of the highlights, and they have dedicated documentation regarding joins[1]. But we've made improvements by an order-of-magnitude before by just reordering our joins to align with how ClickHouse processes them.

[1]: https://clickhouse.com/docs/guides/joining-tables

Re:ClickHouse raises $350M Series C by hodgesrm on Thursday May 29, 2025 @01:39PM (#44128316)
> More seriously, it's a columnar data store, not a relational database.

Could you explain why you don't think ClickHouse is relational? The storage is an implementation detail. It affects how fast queries run but not the query model. Joins have already improved substantially and will continue to do so in future.

Re:ClickHouse raises $350M Series C by fishtoaster on Friday May 30, 2025 @06:41PM (#44140464)
The storage is not just an implementation detail because it affects how fast things run, which affects which tasks it's better or worse for. There's a reason people reach for a columnar datastore for some tasks and something like postgres or mysql for other tasks, even though both are technically capable of nearly the same queries.