DEMO - Citus 10 brings columnar to Postgres

A demonstration of how to use the Citus 10 columnar storage feature in PostgreSQL to achieve high compression and faster queries.

In this Citus open source demo, you’ll learn how to use the Citus 10 Columnar feature for Postgres to achieve 3x-10x compression ratios, reduce IOPs, and deliver faster query responses—particularly for data where your Postgres queries can skip unneeded columns. Citus is an open source extension to Postgres that transforms Postgres into a distributed database. New as of Citus 10, you can now use columnar storage in Citus, both for single-node Citus as well as for distributed Citus database clusters. With Citus 10, you can also mix and match both columnar and row tables. Using Citus columnar in combination with native Postgres range partitioning features is especially powerful, as you can compress older data that won’t be changing while still able to update and delete your “hot” tables. The Citus 10 Columnar demo covers how to create a columnar table, the type of significant performance and compression improvements you might gain, and how to use Citus columnar in combination with native Postgres range partitioning features. Demo given by Jeff Davis, a Principal Software Engineer at Microsoft and Postgres committer. Video bookmarks: ► 0:32 What is Columnar? ► 2:01 Demo begins ► 5:41 What is Postgres range partitioning ► 7:05 Columnar with range partitioning demo 📌 Let’s connect: Twitter – Citus Data, twitter.com/citusdata Twitter – AzureDBPostgres, twitter.com/AzureDBPostgres 🔔 Subscribe to the Citus monthly technical newsletter: aka.ms/citus-newsletter ✅ Learn more: Blog post about Citus 10 Columnar: aka.ms/citus-columnar Citus open source GitHub repo: github.com/citusdata/citus Azure Database for PostgreSQL Blog: aka.ms/azure-postgres-blog Hyperscale (Citus) on Azure Database for PostgreSQL docs: aka.ms/docs-hyperscale-citus-azure #PostgreSQL #Databases #AzureDBPostgres