Apr 2023 Citus Open Source Newsletter

Citus Con: An Event for Postgres 2023 is a wrap!

Our virtual Postgres event is over, but you can still watch the Citus Con talks! All 25 on-demand talks are available on YouTube—both livestreams are too. This “Ultimate Guide” blog post helps you find the PG talks you didn’t know you needed.

Use the guide to know what to watch ⟶

Watch Simon Willison’s keynote: Big Opportunities in Small Data

In his Citus Con 2023 keynote, Simon Willison of Django fame explores the world of small data, and the open-source multi-tool he created for exploring, analyzing, & publishing data.

Watch Simon’s keynote ⟶

Watch Marco’s keynote about the Distributed PostgreSQL problem

In his Citus Con 2023 keynote, Marco Slot, lead architect for Citus, shares the main engineering challenges developing Citus—the fastest & most mature Distributed PostgreSQL implementation.

Watch Marco’s keynote ⟶

Join Boriss & Álvaro for Path To Citus Con Ep03 on Wed May 3rd

Path To Citus Con has a life of its own—now a monthly live show on Discord. With guests Boriss Mejías & Álvaro Herrera, Episode 3 is about why giving talks at Postgres conferences matters.

Mark your calendar ⟶

Demo of How to auto-scale Azure Cosmos DB for PostgreSQL with Citus, Grafana, & Azure Serverless

Put off by the manual steps required to scale your Postgres database? Lucas demos how to auto-scale Postgres on Azure.

Watch Lucas’s demo ⟶

Video: Postgres & Artificial Intelligence

Bruce Momjian describes how to do machine learning inside a Postgres database & its specific advantages in this talk from Citus Con 2023.

Watch Bruce’s talk ⟶

Video: Implementing Temporal Features in PostgreSQL

What is temporal data? What are the relationships between SQL standard & bi-temporal data implementation in Postgres? Find out this & more in Hettie’s talk.

Watch Hettie’s Citus Con talk ⟶

Video: Optimizing Postgres for Write-Heavy Workloads

In his talk from Citus Con, Samay shares his performance recommendations for write-heavy workloads, featuring checkpoint and WAL configs.

Watch Samay’s talk ⟶

Data Encryption at rest with Customer Managed keys for Citus on Azure

With customer-managed encryption, you’re in full control of a key’s lifecycle, key usage permissions, and auditing of operations on keys.

Partitioning strategy for Oracle to Postgres migrations on Azure

In this Citus Con talk, learn from Adi about how to migrate partitions from Oracle to Postgres.

Watch Adi’s talk ⟶

Lessons learned: Migrating from AWS-Hosted PostgreSQL RDS to Self-Hosted Citus

Matt & Delaney share their Python/Django journey to stand up a robust and reliable self-hosted Citus infrastructure.

Watch Matt & Delaney’s Citus Con talk ⟶

Video about Citus on Kubernetes

If you want to scale Postgres with Citus on Kubernetes, this is your talk. Álvaro demos how to automate Citus sharded cluster creation & much much more.

Watch Álvaro’s demo ⟶

ICYMI: Patroni 3.0 & Citus: Scalable, Highly Available Postgres

A post for people who care about distributed PostgreSQL and High Availability. A deep dive into the Patroni 3.0 HA integration with the Citus database extension to Postgres.

Read Alexander’s post ⟶