Get the latest tech news
Show HN: Pg_analytica – Speed up queries by exporting tables to columnar format
Postgres extension that speeds up analytics queries by upto 90% - sushrut141/pg_analytica
pg_analytica automatically exports specified columns from your table into columnar format at regular intervals. The extension periodically exports data from registered tables in columnar format to provide speed ups in querying. To register a table for export use the command below in the psql session where the extension was loaded.
Or read this on Hacker News