Yeah it is clearly a showcase for ClickHouse which is worth bragging about since it is quite performant. And it has a very strong community as the following shows:
https://devboard.gitsense.com/ClickHouse/ClickHouse
I am honestly not sure if my solution can handle HackerNews at this point since generating deep insights for ClickHouse (which has a lot of history) is very expensive.
For those curious, I'm running DevBoard on a single 128 GB machine with 6TB of SSD in RAID 0 (I'm willing to take the risk) and the Postgres database has over 1000 partitions (including sub-partitions) that are optimized for my queries. I'm pretty sure ClickHouse can be more performant and if the creator of https://ghe.clickhouse.tech is reading this, I'm open to seeing if I can't get my solution working on ClickHouse.