Aug 2021 Citus Open Source Newsletter

Summertime, and the livin’ is easy. ♪ ♬ 🎶 Well, not easy exactly, but our team has been out having some hard-earned time off. So you’ll find this newsletter a wee bit shorter, but no less interesting. Enjoy.

What’s new in the Citus 10.1 extension to Postgres

Release notes for the Citus 10.1 extension to Postgres. An exploration of the operational, performance, and UX improvements in Citus to the shard rebalancer, multi-row INSERTs, adaptive executor, inline VALUES in CTEs, how Citus works with Postgres native partitioning, and more, and more.

Read Claire’s post ⟶

Citus 10 is now GA in Hyperscale (Citus) for Postgres on Azure

Announcing that Citus 10, Postgres 13, columnar storage, basic tier, read replicas, managed PgBouncer, and other useful new features are now GA in the Hyperscale (Citus) option in the Azure Database for PostgreSQL managed service.

Read Nik’s post ⟶

PostgreSQL 13.4, 12.8, 11.13, 10.18, 9.6.23, and 14 Beta 3 Released!

The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, as well as the third beta release of PostgreSQL 14. One security vulnerability has been closed, and over 75 bugs have been fixed. You’ll find the full list of changes in the release notes.

Read the announcement ⟶

Read scalability with read replicas

The read replica feature allows you to replicate data from a Hyperscale (Citus) server group to a read-only server group. With read replicas you can improve the performance and scale of read-intensive workloads.

Read the docs ⟶

Connection pooling for Hyperscale (Citus)

Hyperscale (Citus) now supports PgBouncer as part of the managed service (Sweet!). In some cases, PgBouncer may not be enabled for your Hyperscale (Citus) server group yet. If that’s the case, you can set up PgBouncer yourself following the guidance in this post.

Read the docs ⟶

Have you joined the Citus public Slack?

Our public Slack channel is full of useful Q&A about the Citus extension to Postgres—with Citus engineers, open source users, & customers all participating.

Join us ⟶

Try Flexible Server on Azure Database for PostgreSQL at no cost

In this step-by-step tutorial you’ll learn how to create, configure, and use Flexible Server with an Azure free account.

Start the tutorial ⟶

ICYMI: How Citus Distributes PostgreSQL—a video

In this not-to-be-missed video, Marco Slot, the Citus technical lead, explains how Citus works, what you need to know about the new table types Citus introduces (distributed tables and reference tables), what the distributed query planner does, & how Citus handles distributed database transactions.

Watch Marco’s video ⟶