News for hackers. Stuff that matters.

A comment on Show HN: Pg_analytica – Speed up queries by exporting tables to columnar format.

Re:Show HN: Pg_analytica – Speed up queries by exporting tab... by wanderinglight on Saturday June 08, 2024 @10:49AM (#40617896)
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.

[ Parent | on HN ]
Re:Show HN: Pg_analytica – Speed up queries by exporting tab... by koollman on Saturday June 08, 2024 @11:09AM (#40618022)
would need some benchmark against indexed data
[ Parent | on HN ]
Re:Show HN: Pg_analytica – Speed up queries by exporting tab... by fabian2k on Saturday June 08, 2024 @11:23AM (#40618130)
Regular indexes are not that useful for this kind of query as you need to read the entire table in most cases.
[ Parent | on HN ]