Two perspectives on this: - I believe this is a good application of columnar stores (ie, Clickhouse) rather than traditional Postgres, where handling 1M transa

Two perspectives on this: - I believe this is a good application of columnar stores (ie, Clickhouse) rather than traditional Postgres, where handling 1M transactions is really fast. - You might still choose to use materialized views! This article is a suggestion for a table structure that powers those views.