Hacker News Reader

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

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.