Apr 2022 Citus Open Source Newsletter

Citus Con: An Event for Postgres is a wrap!

Thanks to all who joined. If you missed the event, you can still watch all 38 of the live and on-demand talks online. If you need help choosing which talks to watch first, you can use the Ultimate Guide blog post—it categorizes and tags each of the talks.

Explore the videos ⟶

Citus 11.0 beta is underway

Marco’s Citus Con talk with a “look at the Elicorn’s horn” discusses what to expect from the upcoming Citus 11 release—with metadata syncing & more. Includes a demo. If you prefer to read, Marco’s recent “test drive the 11.0 beta” blog has all the deets (but no demo).

Watch Marco’s talk and demo ⟶

Citus Con keynotes

The keynotes at Citus Con spanned the past, present, and future. Umur Cubukcu shares the decisions that fueled the growth of Citus. Magnus Hagander tells us why Postgres is not dead. And Andy Pavlo vaults us into the future with his talk on self-driving PostgreSQL. Enjoy!

Watch the keynotes ⟶

Following SELECT through Citus Internals

In his Citus Con video, Onder Kalaci walks you through Citus internals while a SELECT query is processed, showing how the Citus query planner and adaptive executor work with the Postgres database.

Watch Onder’s talk ⟶

Algolia’s migration to Citus on Azure

Algolia needed a new home for their multi-region analytics pipeline (~5TB of data). Antoine Hemery & Matthieu Dumont take you step by step through their zero-downtime migration to Citus on Azure—sharing the lessons they learned along the way.

Watch Antoine & Matthieu’s talk ⟶

How to scale Postgres for time-series data

Postgres has a built-in solution for time series data: partitioning tables by range. Engineer Burak Velioglu guides you through using Postgres with Citus & pg_cron to manage time series data at scale—effectively transforming PostgreSQL into a distributed time series database.

Watch Burak’s talk ⟶

Big spatiotemporal data management

MobilityDB is a PG extension that efficiently stores and queries mobility tracks, such as GPS trajectories. In this Citus Con talk, Mohamed Bakli explains how to use MobilityDB with Citus for big spatiotemporal data management. Mohamed’s colleague, Mahmoud Sakr includes more examples in this post.

Watch Mohamed’s talk ⟶

Hot off the press: new Citus on Azure documentation

The docs overview page for Hyperscale (Citus) is completely revamped. It’s easier to navigate, has better diagrams, and includes a streamlined quickstart, too.

Check it out ⟶

Advanced integer to BIGINT conversions

Integer overflow problems are a headache. In this Citus Con talk, PG expert Rob Treat explains how to avoid integer overflow—in production, at scale, when it is already too late. He also discusses the work he’s done to get customers out of the integer overflow mess.

Watch Rob’s talk ⟶

Scaling a SaaS on Postgres

In his Citus Con talk, SaaS CTO & co-founder Jonathan Denney shares how ConvertFlow scaled its platform to 40M visitors per month and 8B+ events processed, using Postgres and Citus on Azure. Lots of lessons here.

Watch Jonathan’s video ⟶

New PostgreSQL deep dives at Citus Con

Andres Freund, Melanie Plageman, and Thomas Munro all work on PostgreSQL open source at Microsoft. Watch their Citus Con talks to learn about analyzing Postgres performance with perf and eBPF, developing IO prefetching for Postgres, and a little talk about queues in Postgres, featuring SKIP LOCKED.