[wanderinglight]

Introducing the pg_analytica extension for Postgres.

Tables can be exported to columnar format via this extension to massively speed up your analytics queries. Exported data is periodically refreshed to keep your query results fresh.

[koollman]

would need some benchmark against indexed data

[fabian2k]

Regular indexes are not that useful for this kind of query as you need to read the entire table in most cases.