Citus Newsletter

45X faster percentiles with t-digest ⟶

From the diary of a Citus engineer, the story of how we reduced the time to calculate percentiles by 45x—without access to our customer's data. See how Nils determined if approximation algorithms would meet the SLA.

BLOG | NILS DIJK

How to convert 2 billion rows to Bigint ⟶

To avoid an integer overflow issue, Colton had to convert a large number of Postgres rows in ConvertFlow's database from INT to BIGINT. Here’s how Colton did it—with just 20 minutes of downtime.

BLOG | COLTON SHEPARD

When to use Citus to scale out Postgres ⟶

A guide to the use cases that benefit most from scaling out Postgres with Citus. This post is written with an eye to Hyperscale (Citus) on the Azure managed service, but the use case checklists apply to Citus in general. A useful resource.

BLOG | CLAIRE GIORDANO

Making stored procedures 9X faster ⟶

Marco explains how we made Postgres stored procedures 9X faster in Citus (or is it 19x faster?), using the HammerDB benchmark to measure the speed ups.

BLOG | MARCO SLOT

Andres's analysis of PG connection scalability ⟶

Postgres doesn't handle large numbers of connections very well. This post goes deep on why that is. And Part 2—how Andres improved connection scalability in PG 14—is also quite popular.

BLOG | ANDRES FREUND

About 9.5, the latest Citus release ⟶

A useful overview of what's new in Citus 9.5, from PG 13 support to undistribute_table to adaptive connection management for COPY—and more. Also popular were posts on Citus 9.4, Citus 9.3, & Citus 9.2.

BLOG | CLAIRE GIORDANO

Evolving pg_cron with Azure, AWS, & Zalando ⟶

With pg_cron you can schedule your Postgres queries to run periodically, using the familiar cron syntax. This post covers new features like audit log, background workers, & job names. +1 to the engineers from Azure, AWS, & Zalando who worked together to make it happen.

BLOG | MARCO SLOT

New HA features in pg_auto_failover 1.4 ⟶

Built for HA & automated failover, pg_auto_failover is an open source extension to Postgres. This post covers the new stuff in pg_auto_failover 1.4—including powerful new support for multiple standbys.

BLOG | DIMITRI FONTAINE

Taking Postgres's temperature with these 4 system metrics ⟶

No matter where you run Postgres in production, these are the 4 key system metrics to keep your eye on. A walk through each utilization metric.

BLOG | RACHEL AGYEMANG

Video of a Citus demo, featuring rollups ⟶

Marco's talks have a habit of including really good demos. At the Warsaw PostgreSQL Users Group this year, Marco did not disappoint. Starting at 47:06, this demo shows how to scale your data-intensive apps by using Citus & roll-ups.

VIDEO | MARCO SLOT

Postgres Index types (and where to find them) ⟶

Louise's talks on Postgres are never boring. So it's no surprise that this DjangoCon video made the "best of" list. ICYMI earlier in the year, this is your chance to see the talk now.

VIDEO | LOUISE GRANDJONC

Analyzing GPS trajectories at scale with MobilityDB ⟶

Using the example of a public bus, the creators of the open source MobilityDB database system analyze movement trajectories using the PostGIS, MobilityDB, & Citus extensions.

GUEST BLOG | MAHMOUD SAKR

Slides about Async IO for PostgreSQL ⟶

SLIDES | PGCON 2020, BUFFERED IO, AIO

Why the RDBMS is the future of distributed databases ⟶

BLOG | POSTGRESQL, RELATIONAL, SQL, JOINS, STORED PROCEDURES

PostgreSQL for those who can't even, Part 1 ⟶

BLOG | NODE, DOCKER, NAVICAT, AZURE DATA STUDIO, PG-PROMISE

How to securely authenticate with SCRAM in Postgres 13 ⟶

BLOG | PASSWORDS, CHANNEL BINDING, TUTORIAL, HOW-TO

Configuring Postgres log settings ⟶

BLOG | POSTGRES LOGS, DEFAULTS, VERBOSITY, LOCKS

Postgres.tv: The Art of Postgres ⟶

A deep dive interview with Dimitri Fontaine about Postgres things like extensions, advanced SQL, & pg_auto_failover

Video of Andres Freund's brand new Fika & Pierogi interview ⟶

Hot off the press. New video of the interview with Andres Freund from the Warsaw & Stockholm PostgreSQL User Groups. Watch with popcorn?

Azure Friday Interview about Flexible Server ⟶

Video interview with Sunil Kamath on "Azure Friday", all about the new Flexible Server option for the PostgreSQL managed service on Azure.

What is Azure Arc enabled PostgreSQL Hyperscale? ⟶

We're including this "Data Exposed" interview with J-Y because the Citus extension powers this new Azure Arc service. Enjoy.

Oracle to Postgres migration ⟶

Slides from a talk about a migration from Oracle Exadata to Azure Database for PostgreSQL—with success criteria, results, & learnings.