August 2023 Citus Open Source Newsletter

Citus 12: Schema-based sharding for PostgreSQL

Dive into new Citus 12 features such as schema-based sharding for multi-tenant SaaS applications—plus improvements in Citus support for the MERGE feature.

Read Marco’s post ⟶

What’s new with Postgres at Microsoft

Postgres open source contributions, Citus & other PG extensions, managed services, PG ecosystem work, an event and a podcast—Microsoft does a lot in the Postgres world!

Read Claire’s post with all the things ⟶

Come see the team at PGConf NYC 2023

Our team can’t wait to see your shining faces in New York City in October. Come to one of our 7 talks or stop by the booth for some awesome swag and better conversation.

Get your ticket ⟶

🎙️Say hello to Path To Citus Con

Available on many podcast platforms, Path To Citus Con is a new podcast for developers who love Postgres. Get a behind-the-scenes look from one of the producers.

Read Carol’s post ⟶

Understanding partitioning and sharding in Postgres and Citus

This partitioning vs. sharding blog post explores the concepts and benefits of Postgres native partitioning as well as sharding with Citus.

Read Claire’s PGSQL Phriday post ⟶

Deep Dive on schema-based sharding with Citus

Onur’s deep dive explains all you need to know to start sharding your PostgreSQL database with schemas—plus how we implemented schema-based sharding in Citus.

Read Onur’s post ⟶

How Citus supports the PostgreSQL MERGE command, as of Citus 12.0

Discover some of the practical use-cases and the different strategies employed by Citus for handling MERGE in a distributed environment.

Read Teja’s post ⟶

🎙️Path To Citus Con Ep07 on Wed Sep 6

Paul Ramsey & Regina Obe of PostGIS fame will share their thoughts on why people care about PostGIS and Postgres.

Mark you calendar ⟶

August (and July) updates for Citus on Azure

General availability of Citus 12, the latest PostgreSQL releases, & PGBouncer 1.20 in Citus on Azure. Plus lots more in preview.

Read the docs ⟶

Community Insights on pgBadger: A PGSQL Phriday #010 Recap

In this PGSQL Friday recap post, experts share their insights on the PostgreSQL troubleshooting tool pgBadger.

Read Alicja’s post ⟶

🎙️Episode 6 highlights of Path To Citus Con podcast w/Chelsea Dole & Floor Drees

Highlights & key moments from Ep06—geared toward app developers who are probably already using Postgres. Now what?

Read Carol’s post ⟶

ICYMI: Distributed PostgreSQL benchmarks using HammerDB

Ever wonder why measuring database performance is so hard? Marco explains why using the results of the GigaOM benchmark report as the jumping off point.

Read Marco’s post ⟶