Citus on Kubernetes

on YouTube ↗28m

" summary

StackGres plus Patroni 3.0 integration automates Citus on Kubernetes by handling CREATE EXTENSION, shared_preload_libraries, authentication and the UDF registration that used to be manual. A new SGShardedCluster CRD composes multiple SGCluster objects so a three‑shard topology with two replicas per shard and two coordinators is expressible in a short YAML (demo uses ~15–29 lines) and provisions eight Postgres pods in under 100s to build. SGPostgresConfig and optional SGScripts remain available for custom tuning.

AI-written summary · about

" chapters (5)

1. 0:00Introduction
2. 2:47Why databases on Kubernetes?
3. 14:26Patroni 3.0 and Citus
4. 16:09Citus on StackGres 1.5
5. 20:52Demo of Citus on Kubernetes

" related talks

• 44mDistributed Postgres with CitusWill Leinweber · HighLoad++ 2017
• 31mSharding Without the ComplexityCédric Villemain · PG Day France 2024
• 16mKeynote – Umur CubukcuUmur Cubukcu · PGConf Silicon Valley 2015
• 08mFoundations of Distributed PostgreSQL with CitusOnder Kalaci · Azure Cosmos DB: Liftoff 2022
• 54mContainerized Clustered PostgreSQLJosh Berkus · PGConf Silicon Valley 2016
• 32m8 keys to the growth of Citus & Distributed PostgreSQLUmur Cubukcu · Citus Con: An Event for Postgres 2022
• 28mEfficiently distributing Postgres with Citus – How to choose the right shard key?Sai Krishna Srirampur · Citus Con: An Event for Postgres 2022
• 52mScaling a Saas application beyond a single Postgres with CitusJesse H. Willett · PostgresOpen Silicon Valley 2017