[AsianOtter]

Adding Merge Tree compaction, a la ClickHouse, should solve this, right?

[pauldix]

That's right, compaction is the way to solve for performance over longer time ranges. This is what we have in our commercial Enterprise product.