[ies7]

For a mere 20M-70M rows I'd stick with Postgres, index, and materialized view.

After that is when I'll start migrate to duckdb or clickhouse (or citus if I don't want to move out completely from Postgres)