November 2023 Citus Open Source Newsletter

✍ From Crunchy Data: Postgres + Citus + Partman, Your IoT Database

Learn why the folks at Crunchy Data recommend Citus & pg_partman as a very compelling approach to IoT architecture.

Read Crunchy Data’s post ⟶

✍ From Cybertec: Citus Live Query Inspection using citus_stat_activity

“What I like about citus_stat_activity is that I can get all the information I need at a glance.”

Read Cybertec’s post ⟶

📝 Availability zone outage resiliency in Citus on Azure

Get improved reliability and disaster recovery with availability zones in Azure Cosmos DB for PostgreSQL.

Read the docs ⟶

✍ Claire Giordano’s Illustrated Guide to Postgres at PASS Data Summit 2023

Part of PGSQL Phriday #014, this illustrated guide to Claire’s first-timer experience at PASS Data Community Summit 2023 shows what the Postgres experience was like.

Read Claire’s post ⟶

🎙️Path to Citus Con Ep10 – Wed Dec 6

Lukas Fittl & Rob Treat will chat with Claire & Pino about their journeys to Postgres monitoring. Join them.

Mark your calendar ⟶

🎙️Episode 9 highlights of Path To Citus Con podcast with Postgres experts Dimitri Fontaine and Vik Fearing

Should you solve every data problem in SQL, or not? Ari shares highlights, or you can listen to the episode to find out.

Read Ari’s post ⟶

✍ Azure Database for PostgreSQL: AI-Ready for Enterprise Applications in Flexible Server

So much goodness announced as part of Azure Database for PostgreSQL at Ignite. Charles covers it all—PG16, pgvector, more extensions, & more regions too.

Read Charles’s post ⟶

✍ PostgreSQL 16 now available on Azure Database for PostgreSQL - Flexible Server

Just two months after PG16 launched, our fully managed service—Azure Database for PostgreSQL Flexible Server—supports PG16.

Read Alicja’s post ⟶

✍From Crunchy Data: Designing Your Postgres Database for Multi-tenancy

You’ll find a shout out to Citus and schema-based sharding in this article covering 3 approaches to multi-tenant database design.

Read Crunchy Data’s post ⟶

✍ From Cybertec: CITUS: Row Store vs. Column Store in PostgreSQL

What’s the difference between row store and column store? Is one method better than the other? This post digs into the differences between the two methods—with examples.

Read Cybertec’s post ⟶

✍ ICYMI: Citus Technical README for distributed PostgreSQL

All about the distributed Postgres (aka Citus open source) technical readme useful to contributors to the Citus extension to Postgres, Citus users, Citus on Azure customers, & more.

Read Onder’s post ⟶