Oct 2021 Citus Open Source Newsletter

Learn how to scale Postgres for time series data with Citus

How to manage time series data at scale by using Postgres, Citus, and pg_cron. This post shows 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 ⟶

PostgreSQL 14 on Hyperscale (Citus) Within One Day of its Release

This post includes highlights of Postgres 14 features, plus how we keep extensions like Citus, pg_cron, HLL, & TopN compatible with new major versions of Postgres. You’ll also learn how we made Postgres 14 available in production on Azure in our Hyperscale (Citus) managed service, just one day from the Postgres 14 release.

Read Ozgun’s post ⟶

Memory Tuning for workloads in PostgreSQL Flexible Server on Azure

In this Azure-focused introduction to tweaking Postgres server configuration options you’ll find an explanation of the different memory types available in Postgres, when each type is used, and details on server parameters that impact performance—making this post useful even beyond the Azure realm.

Read Gennady’s post ⟶

Updated Citus time series docs

Using new functions built into Citus 10.2, you can now conveniently create and maintain table partitions for time series data. By converting older partitions to columnar storage, you can compress old data and still be able to update the most recent data in row storage.

Read the docs ⟶

Marco’s Twitter thread on latency & scalability

In this multi-part Twitter thread in response to Nikolay Samokhvalov, Marco delves into the complex topics of latency & scalability. He shares how Citus gives you a set of tools to handle data-intensive Postgres workloads, and links to a couple other posts for more info. Worth a look.

Read Marco’s post ⟶

Evolving pg_cron together

Using pg_cron, you can schedule Postgres queries to run periodically, according to the familiar cron syntax. This post covers new features in the pg_cron extension to Postgres, including audit log, background workers, & job names. Also, how engineers from Azure, AWS, & Zalando worked together to evolve pg_cron.

Read Marco’s post ⟶

Video: Postgres tips for optimizing Django & Python performance

With the recent opening of the PyCon 2022 CFP, we’re reminded of this delightful video in which Louise covers django-debug-toolbar, Postgres logs, pg_stat_statements, avoiding loops in Django, and keyset pagination. If you prefer to read, you’ll find highlights in this post.

Watch the video ⟶

Using custom types with Citus & Postgres, from popular hack to transparent feature

Custom types in Postgres, like Postgres extensions, are a powerful Postgres feature envisioned from Day 1 in the original design of Postgres. This post explores how custom types work with Citus & how user-defined PostgreSQL types are automatically propagated to all the nodes in a Citus database cluster.

Read Nils’s post ⟶

Data Exposed: What is exciting about Flexible Server for PostgreSQL on Azure

Join Sunil Agarwal and Anna Hoffman as they discuss all that’s exciting about Flexible Server–cost savings, better performance, zone resilient HA, and developer-friendly.

Watch the video ⟶

Getting started with Azure Database for PostgreSQL – Citus server

This article by Gauri Mahajan on the SQL Shack blog will show you how to deploy the Hyperscale (Citus) server group on Azure Database for PostgreSQL and explore its configuration options. Thanks Gauri! (At the time this article was written, the features mentioned were in preview; they’re generally available now.)

Read Gauri’s post ⟶

ICYMI: What’s new in the Citus 10.2 extension to Postgres

This post covers new Citus 10.2 capabilities for sharding time series data and for using columnar storage in PostgreSQL. It’s the definitive release notes blog post about Citus 10.2, which is ready for PostgreSQL 14.

Read Onder’s post ⟶