Citus Newsletter

Getting started with Citus ⟶

If one of your friends or teammates is looking to get started with Citus, we've created this page to help them explore Citus in whatever way they learn best: reading docs, watching videos, or trying out Citus themselves. Is this useful?

WEBPAGE | CITUS OPEN SOURCE

New Oracle to Postgres migration guide for Azure ⟶

In the first of a 4-part series, Arun reveals the 8-step Oracle to Postgres migration journey and how it ties into the new migration guide. He takes you from evaluation to cut-over, including what to expect each step of the way.

BLOG | ARUN KUMAR THIAGARAJAN

BNY Mellon sees 24x query performance with Hyperscale (Citus) & AKS ⟶

Global investments company, BNY Mellon shows how they leverage Azure Database for PostgreSQL - Hyperscale (Citus), and Azure Kubernetes Service (AKS) to design an intelligent system for data ingest and transformation.

VIDEO | BNY MELLON

Vaccination Database Tech Talks at Carnegie Mellon University ⟶

Andy Pavlo at CMU has announced a new online seminar series, “The Vaccination Database Tech Talks,” for the spring, with a great lineup. Citus technical lead Marco Slot will be speaking about Citus on Feb 22nd.

TECH TALKS | ANDY PAVLO, CMU

A troubleshooting checklist for Postgres connection issues on Azure ⟶

The Azure Database Support team often deals with connectivity issues. Dandan’s post includes a checklist to investigate connection issues with Azure Database for PostgreSQL - Single Server, but some of the tips apply to Hyperscale (Citus) too.

BLOG | DANDAN ZHANG

Useful diagnostic queries ⟶

This doc includes diagnostic queries for: finding which shard contains data for a specific tenant, finding the distribution column for a table, detecting locks, querying the size of your shards or distributed tables—and so much more.

DOCS | CITUS OPEN SOURCE

work_mem warriors video from PGCon ⟶

This talk covers 3 improvements to the Postgres executor: the addition of memory accounting information to MemoryContexts, the memory-bounding of HashAgg (spilling HashAgg to disk), and the adaptive hashjoin fallback to nested hashloop join. And here are the slides if you prefer.

VIDEO | JEFF DAVIS & MELANIE PLAGEMAN

Shard data on worker nodes in Azure Database for PostgreSQL – Hyperscale (Citus) ⟶

In this tutorial about Citus on Azure you can learn how to: create hash-distributed shards, see where table shards are placed, identify skewed distribution, create constraints on distributed tables, & run queries on distributed data.

TUTORIAL | JOE NELSON

How the Citus distributed query executor adapts to your Postgres workload ⟶

In this post, Marco explains why we moved to a single unified code path and the secret sauce behind the adaptive, distributed executor in Citus.

BLOG | MARCO SLOT

Postgres autovacuum is not the enemy ⟶

Joe shows how autovacuum is typically misunderstood and misconfigured. By taking a low-level look at PostgreSQL internals he arrives at a better autovacuum configuration. Finally he explains how distributing data across a PostgreSQL cluster like Citus can also fight bloat.

BLOG | JOE NELSON

What kind of performance can I get with Postgres? ⟶

It depends. In this post Samay walks through some fermi estimates for what Postgres query performance—both read and ingest—you should expect.

BLOG | SAMAY SHARMA

ICYMI: How to convert 2 billion rows to Bigint ⟶

With 2 billion rows in distributed Citus tables & an integer primary key set to autoincrement, our ConvertFlow customer would soon have an integer overflow issue. Here’s how Colton solved the problem.

BLOG | COLTON SHEPARD

CMU TAs receive limited-edition Citus socks! ⟶

TWEET | CMU, SOCKS, HARD-TO-GET

A collection of Citus video demos ⟶

DEMOS | POSTGRES, CITUS, PERFORMANCE, HTAP, ANALYTICS

Golden Proportions in PostgreSQL ⟶

BLOG | POSTGRESQL, DESIGN, BEAUTY

PostgreSQL is DBMS of the Year 2020 (for the 3rd time!) ⟶

BLOG | DB-ENGINES

Preliminary exploration of dynamic hashing in PostgreSQL ⟶

BLOG | HASH TABLE, POSTGRES

What's Missing For Postgres Monitoring ⟶

In this talk, Lukas looks at specific cases where you need to use system level tools & other creative methods to get the information you need to monitor Postgres.

Mechanical Sympathy for Elephants: Reducing I/O and Memory Stalls ⟶

This talk explores the mechanics of memory and storage, and discusses a selection of opportunities for PostgreSQL to reduce stalls and improve performance.

Postgres Architectures in Production ⟶

Slides from Dimitri’s talk where he explains how to think about the specific HA needs of your production environment & how to achieve your requirements with open source tooling & PostgreSQL.

Asynchronous IO for PostgreSQL ⟶

In this video Andres Freund will discuss the outcome of a prototype to add asynchronous IO support to PostgreSQL.

What is Azure Arc enabled PostgreSQL Hyperscale ⟶

At the virtual Data Platform Summit, Jean-Yves Devant & Nikil Patel presented “What is Azure Arc enable PostgreSQL Hyperscale”. Here are their slides.