Public preview: Azure Database for PostgreSQL – Hyperscale (Citus) columnar compression
Published date: 25 May, 2021
Azure Database for PostgreSQL - Hyperscale (Citus) now supports columnar compression with Citus 10 in preview. You can use columnar compression with or without the scale-out features of Citus. Postgres typically stores in rows, and row-based tables are good for transactional workloads, but can cause excessive IO for some analytical queries. Columnar groups data together by column instead of by row to compress the data as well. Arranging data by column tends to also compress well and means that queries can skip over columns they do not need. Currently, this feature is available in the East US region only.