You mentioned materialized views. How did you use them and what were the specific benefits? I agree they are one of the more amazing features in ClickHouse but you can always learn more about how to use them.
Meanwhile Thanks for the post and the shout-outs to Altinity videos!
p.s., I work at Altinity.
Neat post! I'd be curious to see some simple examples of each what the slow queries looked like. It seems to my limited knowledge they attempted to use row based dbs / mongo for column based workloads then saw a large perf boost after switching to Clickhouse.
That's exactly right! As I explained in the post, we made a big tradeoff to get things started at the beginning, which was using mongo to handle large analytics workloads. It's been a year since I wrote this post but we've had a lot of success improving query performance within ClickHouse as well. Will write about that soon :)