Citus Newsletter

Happy Happy 2024. May it be full of lots of Postgres goodness! We’ve gathered some of our most popular Citus & Postgres posts & videos in one place for your reading and viewing pleasure. We hope you enjoy them.

✍ Citus 12: Schema-based sharding for PostgreSQL

Dive into new Citus 12 features such as schema-based sharding for multi-tenant SaaS applications + improvements in the Citus support for the Postgres 15 MERGE feature.

Read Marco’s post ⟶

✍ Citus Technical README for distributed PostgreSQL

All about the deep-dive technical readme for the Citus extension to Postgres—useful for contributors to Citus open source, Citus users, Citus on Azure customers, & more.

Read Onder’s post ⟶

✍ What’s new with Postgres at Microsoft

Learn about Microsoft’s contributions to Postgres—from improvements to Azure database services for Postgres to contributions across the entire PG ecosystem.

Read Claire’s post ⟶

🎙️ New in 2023: Path To Citus Con Podcast

In 2023 Claire & Pino started a brand new podcast for developers who love Postgres—all about the human side of Postgres. Here’s highlights from the most recent episode.

Listen to previous episodes ⟶

🎙️Path To Citus Con Ep11 – Wed Jan 10, 2024

Jelte Fenemma-Nio will join Claire & Pino to discuss his journey into performance benchmarking.

Mark your calendar ⟶

✍ Adding Postgres 16 support to Citus 12.1, plus schema-based sharding improvements

Postgres 16 is now supported by Citus! You’ll also find schema-based sharding improvements for multi-tenant SaaS apps (and microservices) in Citus 12.1.

Read Naisila’s post ⟶

✍ What’s new in Citus 11.3 & Postgres for multi-tenant SaaS workloads

The Citus 11.3 extension to Postgres includes support for tenant monitoring for SaaS workloads, parallel shard re-balancing, & more.

Read Marco’s post ⟶

✍ Ultimate Guide to Citus Con: An Event for Postgres, 2023 edition

Stay tuned for the announcement of the 2024 event. In the meantime, this ultimate guide will help you navigate all 37 talks at the 2nd annual Citus Con: An Event for Postgres 2023.

Read Claire’s post ⟶

✍ What’s new in Citus 11.2 for Postgres, plus Patroni HA support for Citus

Citus 11.2 includes improved support for outer joins between reference tables & distributed tables, better DDL support, shard rebalancer progress tracking, and Citus support in Patroni.

Read Marco’s post ⟶

✍ November 2023 Recap: Azure PostgreSQL Flexible Server

In November, features that bolster your database's security, optimize storage scalability, and streamline the migration process were rolled out.

Read Varun’s post ⟶

✍ Mastering the Move: Migrating from Azure Database for PostgreSQL Single to Flexible Server

This article will help you make a knowledgeable decision about the best tools and steps to use to migrate from Azure Database for PostgreSQL Single Server to Flexible Server.

Read Hideo’s post ⟶

The Distributed PostgreSQL problem & how Citus solves it

Marco Slot’s keynote @ Citus Con 2023

Big Opportunities in Small Data

Simon Willison’s keynote @ Citus Con 2023

PostgreSQL performance tips you have never seen before

from Hans-Jürgen Schönig @ Citus Con 2023

Citus & Patroni: The Key to Scalable and Fault-Tolerant PostgreSQL

from Alexander Kukushkin @ Citus Con 2023

Azure AD authentication with PostgreSQL Flexible Servers

from Andrey Chudnovskiy @ Citus Con 2023

What I learned benchmarking Citus & Postgres performance with HammerDB

from Naisila Puka @ Citus Con 2023

Optimizing Postgres for write heavy workloads ft. Checkpoint and WAL configs

from Samay Sharma @ Citus Con 2023

How to copy a Postgres database?

from Dimitri Fontaine @ Citus Con 2023

Citus on Kubernetes

from Alvaro Hernandez @ Citus Con 2023

Understanding & Managing Postgres Table Bloat

from Chelsea Dole @ Citus Con 2023

NORDIC PGDay 2023 – CFP open until Jan 5, 2024

Oslo, Norway | Mar 12, 2024

PGConf.dev 2024 – CFP is open until Jan 15, 2024

Vancouver, Canada | May 28-31, 2024

Chicago PGDay 2024 – CFP is open until Jan 15, 2024

Chicago, IL | Apr 26, 2024

PGConf.de 2024 – CFP is open until Feb 8, 2024

Munich, Germany | Apr 12, 2024

FOSDEM PGDay 2024 – Registration open!

Brussels, Belgium | Feb 2, 2024