Citus Newsletter

Millions use the UK COVID-19 dashboard built with Postgres & Citus

Why and how the GOV.UK Coronavirus dashboard team built their analytics service on top of PostgreSQL and Citus in the cloud. And a deep dive into time series data, performance tuning, data model, open-access data, and distributed scale.

Read Pouria & Claire’s post ⟶

CFP is open for Citus Con: An Event for Postgres

Every great event starts with great speakers. Do you have a Citus (or Postgres) story to share? Brought to you by the Postgres team at Microsoft—Citus Con: An Event for Postgres, a virtual and free developer event happening on April 12-13 in 2022. CFP open until Feb 6, 2022.

Call for proposals ⟶

Postgres 14 available on Azure within 1 day of release

Find out how we shipped Postgres 14 on Azure in our Hyperscale (Citus) managed service just one day after Postgres 14 was released.

Read Ozgun’s post ⟶

Video: How Citus Distributes PostgreSQL

In this talk based on his SIGMOD paper, Marco explains how Citus uses the PostgreSQL extension APIs. You’ll also learn about table types in Citus, the distributed query planner, and how Citus handles distributed database transactions.

Watch Marco’s video ⟶

About Citus 10–the latest major Citus release

Says Marco Slot in his Citus 10 post: "We wanted to make number 10 something special, but I could not have imagined how truly spectacular this release would become." Columnar storage, sharding on a single node, open sourcing of the shard rebalancer, and more. Also popular were posts on Citus 10.2 and Citus 10.1.

Read Marco’s post ⟶

Columnar compression for Postgres with Citus 10

A quickstart for using the new Citus columnar feature—plus performance measurements for data loading, compression ratios, and query response times. Index support added in Citus 10.2. If you prefer to see Citus columnar in action, here’s a demo Jeff made.

Read Jeff’s post ⟶

How, why, & when to shard Postgres on a single Citus node

Deep dive into sharding Postgres on a single Citus node, now available as part of Citus 10. Includes a Quick Start guide and a docker container to try things out. Also available in Hyperscale (Citus), where it’s called Basic Tier.

Read Onder’s post ⟶

Citus shard rebalancer is now open source

This post explains how the shard rebalancer works, options for different rebalancing strategies, and how to use it. As of Citus 10.1, you can now monitor the progress of an ongoing shard rebalance.

Read Jelte’s post ⟶

All the goodness of Citus 10 is available in Hyperscale (Citus) on Azure too

Nik summarizes all the Citus 10 goodness in this post–and you’ll find Azure-specific info in these posts about the new Postgres superpowers introduced with Citus 10, columnar compression, and basic tier.

Read Nik’s post ⟶

Migrate data faster in Postgres

Learn how to speed up Postgres database migrations using pg_dump, pg_restore, and python scripts such as Parallel Loader.

Read Sai’s post ⟶

Faster recovery and VACUUM in Postgres 14

From one of our Postgres committers, this deep dive walks you through the performance engineering work that is speeding up recovery and vacuum in Postgres 14.

Read David’s post ⟶

Scaling Postgres for time series data with Citus

How to use partitioning, columnar compression, pg_cron for automation, new Citus functions for easy partition management, and Citus for sharding and distributing across a cluster.

Read Burak’s post ⟶

SIGMOD paper about Citus: Distributed PostgreSQL for Data-Intensive Applications

at SIGMOD/PODS ‘21

Citus Talk at CMU: Distributed PostgreSQL as an Extension

by Marco Slot on the Citus blog

Oracle to Postgres Migration Guide

by Arun Thiagarajan on GitHub

Scott Hanselman & Claire Giordano explore ways to get started with Azure Database for PostgreSQL

on Azure Friday

Citus Con: An Event for Postgres—CFP open thru Feb 6, 2022

Online | Apr 12-13, 2022 | CFP open

PostgreSQL devroom @ FOSDEM

Online | Feb 6, 2022

NORDIC PGDAY 2022—CFP open thru Dec 31, 2021

Helsinki, Finland | March 22, 2022 |CFP open

pgDay Paris 2022—CFP open thru Dec 31, 2021

Paris, France | Mar 24, 2022 | CFP open

PGCon 2022–CFP open thru Jan 19, 2022

Ottawa, Canada | CFP open | May 24-27, 2022