Citus Newsletter

The latest version of Citus, all about Citus 9.3 ⟶

All the things in the latest open source release of Citus. Ft. improved window functions, adaptive connection management, shard pruning, pg_dump, & more. Read Claire’s blog.

BLOG | CLAIRE GIORDANO

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

Propagation of custom types in Citus ⟶

Automated dependency propagation solves a long-time headache for custom types and Postgres extensions in Citus. This is Nils’s take on why you should care.

BLOG | NILS DIJK

High performance HTAP with Postgres & Citus, a video with demo ⟶

This interview & demo—created from our work-from-home Covid-era offices for the recent European Open Source Summit—explores how you can use Citus to serve both transactional & analytical workloads at scale. Marco's demo is a must-see.

VIDEO | CLAIRE GIORDANO & MARCO SLOT

Discussion on recent Jepsen report on PostgreSQL 12.3 ⟶

This comment thread on Hacker News is as interesting as the Jepsen report itself. Especially this quote from Kyle Kingsbury: "the PostgreSQL team really knocked it out of the park on this one."

HN COMMENT THREAD

Video of Citus co-founder’s latest talk about Azure and Postgres ⟶

Even before acquiring Citus, the team at Microsoft has been investing more and more in Postgres. In this video, Umur shares his perspective on what makes Azure unique for Postgres.

VIDEO | UMUR CUBUKCU

20% off discount for Dimitri Fontaine’s book, The Art of PostgreSQL ⟶

With the discount code of "CITUS" you get 20% off Dimitri’s awesome book on Postgres, created to help developers replace 1000s of lines of code with simple SQL queries.

BOOK | DIMITRI FONTAINE

PostgreSQL 13 Beta 2 is released ⟶

Good news: the 2nd beta release of PostgreSQL 13 is now available for download, including previews of all the new Postgres 13 features.

POSTGRESQL GLOBAL DEVELOPMENT GROUP

Migrating from Oracle to PostgreSQL ⟶

Here are the slides from this oversubscribed talk (on a popular topic) from Sai & Saurabh. Of course the talk was higher fidelity than the slides, but since the video hasn’t dropped yet we thought we would at least share these.

SLIDES | SAI SRIRAMPUR & SAURABH MODI

Optimizing Django & Python performance ⟶

Louise wrote this to share highlights of her PyCon2020 video on how to optimize Django & Python performance. Check out the blog (& then watch the video.).

BLOG | LOUISE GRANDJONC

ICYMI: What makes spatial queries special, ft. PostGIS & Postgres ⟶

Tips & tricks for working with spatial joins & spatial queries with PostGIS, from our guest blogger Topi Tjukanov. Learn how to know thy neighbour with PostGIS in this post.

BLOG | TOPI TJUKANOV

How to configure Postgres log settings ⟶

BLOG | POSTGRES LOGS

From Brandur, doubling the sorting speed of Postgres network types ⟶

BLOG | TYPES, INET, CIDR, BITMASK

Tutorial: design a multi-tenant database with Hyperscale (Citus) ⟶

DOCS | MULTI-TENANCY, AZURE, CITUS

Postgres planner & CREATE STATISTICS ⟶

BLOG | EXPLAIN, PG_STATISTIC, EXPLAIN ANALYZE, N_DISTINCT

Choosing a distribution column in Hyperscale (Citus) ⟶

DOCS | SHARDING, TIMESERIES, MULTI-TENANT, REAL-TIME ANALYTICS

Citus 9.2 speeds up large scale HTAP workloads on Postgres ⟶

BLOG | CTE, AGGREGATES, JOINS, HTAP

Asynchronous IO for PostgreSQL ⟶

Andres Freund has been working hard on a new Async IO system for Postgres. Here are the slides from his PGCon 2020 virtual talk.

Reducing I/O & memory stalls ⟶

If you can’t wait until the video drops to get a glimpse into Thomas Munro’s PGCon talk on reducing I/O and memory stalls, these slides are for you.

What’s Missing for Postgres Monitoring ⟶

If you’ve ever seen Lukas Fittl speak, you’ll know he’s passionate about monitoring. Here are his PGCon slides.

PostgreSQL on FreeBSD ⟶

News, observations, and speculation in this slide deck from Thomas Munro’s BSDCan virtual talk.

How to Scale Postgres: Automation, Tuning & Sharding ⟶

Alas, all our conference talks are virtual these days. Here are Lukas Fittl’s awesome slides from his June Postgres Vision talk.

High performance HTAP with Postgres & Citus ⟶

Slides from Claire Giordano’s interview with Marco Slot at the Microsoft European Virtual Open Source Summit (that’s a mouthful), complete with a side-by-side performance comparison of Hyperscale (Citus) vs. Postgres running on a single node.