I've done a lot of ClickHouse versus X comparisons for Posthog. This one was particularly hard because Redshift keeps issuing big updates, but I'm pretty happy where it ended up and wanted to share it.
It does amaze me how ClickHouse does hold up against a lot of these databases backed by BIG companies—it really is a drag racer (Robert Hodges' analogy, not mine).
I think that analogy has been around for a while. ;)