Hacker News Reader

Use Clickhouse - it's specifically built for this use case (low latency OLAP).

It also has materialized views built in so you don't have to run dbt manually

Yes, I almost added that -- there are several alternatives, but it takes some testing and tuning to be certain.