Azure Database for PostgreSQL - Hyperscale (Citus): Columnar compression now generally available

Azure Updates

Discussionpowered by zap.ms

Published

Aug 18, 2021

Status

Launched

Timeline

  • August 2021
    General Availability

Product

Azure Database for PostgreSQL

Tag

Features
Open Source

Category

Databases
Hybrid + multicloud

Description

Azure Database for PostgreSQL - Hyperscale (Citus) now supports columnar compression with Citus 10. 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.

Learn more about columnar compression.