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.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of queries

queries

Photo of Postgres

Postgres

Photo of upto

upto

Related news:

News photo

How Novy Built Zelma for Emily Oster Using OpenAI and Postgres

News photo

Show HN: Neosync – Open-Source Data Anonymization for Postgres and MySQL

News photo

Using Postgres for Everything