Clickhouse is absolutely incredible at storing time series metrics.

What does your schema for metrics look like? Using materialised views? I am particularly interested in storing metrics with labels(key/val pairs) Eg, Prometheus metrics. You can't flatten them out into columns due to high dimensionality(can need millions of columns). Do you store the labels in an array?

Not the person you're replying to, but you can see how SigNoz did it here [1]

Essentially you add: keys Array(String), values Array(String) and write the pairs accordingly.

https://github.com/SigNoz/signoz/blob/develop/deploy/docker-...

I see this viewpoint occasionally but have never seen what features a TSDB offers that Clickhouse can’t do just as effectively if not better?

I would have thought better compression was one, but it looks like Clickhouse now supports all the time series-optimized encodings like delta and gorilla - https://altinity.com/blog/2019/7/new-encodings-to-improve-cl....