Jun 2021 Citus Open Source Newsletter

A new kind of database: Combining Postgres & Citus tables, ft. foreign keys

One of the new superpowers introduced in Citus 10, is the ability to mix local and distributed tables. And mixing Citus and Postgres tables wouldn’t be possible without support for foreign keys.

Read Onur’s very first post ⟶

The latest in Hyperscale (Citus) for Postgres on Azure (ft. read replicas)

The Hyperscale (Citus) team has been busy adding lots of new features and functionality. Nik shares all the deets in this post—Basic tier, Postgres 13 support, read replicas and more.

Read Nik’s post ⟶

Citus: Distributed PostgreSQL for Data-Intensive Applications

This SIGMOD/PODS 2021 paper describes the requirements of 4 workload patterns and how Citus addresses those requirements. And, there’s performance benchmarks and a video presentation of the paper too.

Read the paper, watch the preso, or both ⟶

DEMO: 3 Hyperscale (Citus) superpowers to scale PostgreSQL ft. UK COVID-19 website

See three of the Citus superpowers in action in this demo excerpted from Rohan Kumar’s Microsoft Build keynote. Umur demos columnar compression, seamless no-down-time scale out, and linear performance gains by looking under the covers of the official UK COVID-19 website.

Watch the demo ⟶

Welcome pg_auto_failover v1.5.2

In this release of pg_auto_failover the restriction to always have at least two nodes with non-zero priority in a group has been lifted. There are bug fixes too.

Read the release notes ⟶

PostgreSQL 14 – beta 2 released

The 2nd beta release of PostgreSQL 14 is now available for download. There’ve been tons of changes since beta 1, and all PostgreSQL 14 features are included in this release. Check out the release notes for more details.

PostgreSQL as a Microservice? Mais oui.

Recently, Dimitri was a guest on the MACI French podcast where they discussed, among other things, looking at PostgreSQL as one of the components of your application—in other words, a microservice. This blog post elaborates on their discussion, and if you speak French, you might enjoy watching the episode.

Read Dimitri’s post ⟶

Lab: Explore Azure Database for PostgreSQL - Flexible Server with Python

In this lab, learn how to import data into your Flexible Server instance of Azure Database for PostgreSQL. Then, explore the weather data from weather sensors around the world in this dataset meant to simulate an IoT use case.

Try the Flexible Server lab ⟶

Getting started with Citus – Setting up a four node cluster

Daniel Westerman of dbi services shares how easy it is to set up a 4-node Citus cluster. He starts with a single node and by the end of the post he has a coordinator and 3 worker nodes. Sweet.

Read Daniel’s post ⟶

ICYMI: Citus Tips for Postgres: How to alter distribution key, shard count, & more

Two new user-defined functions in Citus 10 make it easier to change your distributed Postgres tables. Ozan shares tips on how to change your distribution key, shard count, or colocation properties, and on how to change a table’s access method in Citus too.

Read Ozan’s post ⟶