Citus Con: An Event for Postgres 2023
2023-04-18..2023-04-19
-- online --
[Citus Con: An Event for Postgres 2022, Citus Con: An Event for Postgres 2023]
as the organisers put it
Citus Con 2023 is a wrap! Citus Con: An Event for Postgres is a virtual and free developer event that happened on April 18-19 in 2023. Watch the livestream replays and on-demand talks to learn what amazing things people are building with Postgres and with Citus, both on Azure and in open source.
who it's for
citus operators, postgres database administrators, cloud engineers (Azure), platform engineers, site reliability engineers, data engineers, application developers
topics
distributed PostgreSQL with Citus; pg_stat_io observability; jsonb real-time analytics; Patroni high availability; deploying PostgreSQL with Bicep; Postgres compression codecs (lz4, zstd); parallel query in PostgreSQL 15; multi-tenancy and sharding; autovacuum and table bloat; checkpoint and WAL tuning; Postgres on Kubernetes; temporal features in PostgreSQL
| title | author | length |
|---|---|---|
| KEYNOTE: Big Opportunities in Small Data | Simon Willison | 29m |
Demo of an open-source tool that uses SQLite to publish and explore data shows a 1,700-row San Francisco assets CSV rendered on a map, interactive read-only… | ||
| KEYNOTE: The Distributed PostgreSQL Problem & How Citus Solves it | Marco Slot | 31m |
Citus is a Postgres extension that shards and replicates tables across PostgreSQL servers to get “Postgres performance at any scale,” with a decade of… | ||
| Additional IO Observability in Postgres with pg_stat_io | Melanie Plageman | 26m |
pg_stat_io in Postgres 16 introduces a cumulative view that separates flushes from extensions, reports per-backend and per-context IO and records counts like… | ||
| Citus and JSON for real-time analytics at Vizor Games | Ivan Vyazmitinov | 31m |
Vizor Games runs Citus on bare‑metal Gentoo with ~40 workers and 20+ tenant databases, ingesting about 100GB per day of semi‑structured JSONB and getting ~6:1… | ||
| Citus & Patroni: The Key to Scalable and Fault-Tolerant PostgreSQL | Alexander Kukushkin | 33m |
Shows a concrete integration: Patroni+ETCD+HAProxy coordinates a Citus coordinator and multiple worker Postgres clusters, with Citus 11.2 rebalance UDFs used… | ||
| Deploying PostgreSQL to Azure with Bicep | Pamela Fox | 35m |
Shows how to declare and deploy Azure Database for PostgreSQL Flexible Servers with Bicep, using az deployment group create and Azure Developer CLI to create… | ||
| How we keep Azure Database for PostgreSQL free of bloat to maximize disk space | Bob Wuisman, Eleni Siampali | 23m |
Automation runs weekly to read table stats into a central metadata DB, call Databricks analysis, segment tables into seven clusters by reltuples and… | ||
| On compression of everything in Postgres | Andrey Borodin | 32m |
Postgres now ships multiple codecs—PGLZ, zlib, LZ4, zstd—and shows concrete wins: LZ4 decompression ~5 GB/core vs simple copy ~14 GB/core, making TOAST reads… | ||
| Parallelism in PostgreSQL 15 | Thomas Munro | 38m |
Explains how PostgreSQL 15 runs single-query parallelism using OS processes with a leader and workers, implementing parallel sequential scan and parallel… | ||
| Postgres Storytelling: Support in the Darkest Hour | Boriss Mejias | 33m |
A Postgres instance hits transaction ID wraparound risk: a 4 TB, insert-only table (≈7 billion rows) drives oldest XID past autovacuum_freeze_max_age (~200M)… | ||
| Postgres without SQL: Natural language queries using GPT-3 & Rust | Jelte Fennema-Nio | 31m |
A Rust Postgres extension called pg_human grabs the live schema, sends it to GPT‑3/ChatGPT via an OpenAI Rust client, receives raw SQL, runs it through… | ||
| What I learned benchmarking Citus & Postgres performance with HammerDB | Naisila Puka | 32m |
Uses HammerDB TPROC-C against Azure Cosmos DB for PostgreSQL with a 1016+32 cluster and moves from 1,000 to 2,000 virtual users to push concurrency; baseline… | ||
| Auto scaling Azure Cosmos DB for PostgreSQL with Citus, Grafana & Azure Serverless | Lucas Borges | 32m |
Shows a working pipeline that auto-scales an Azure Cosmos DB for PostgreSQL (Citus) cluster using Grafana alerts, Azure Functions (Serverless) calling ARM, and… | ||
| Azure AD authentication with PostgreSQL Flexible Servers | Andrey Chudnovskiy | 27m |
Azure Database for PostgreSQL Flexible Server now accepts Azure AD JWTs instead of passwords, so role mapping uses functions like pgaadauth_create_principal… | ||
| Citus from the Customer eyes | Sai Krishna Srirampur | 24m |
Citus extends Postgres to scale from one node to many as an extension (not a fork) and is available managed as Azure Cosmos DB for PostgreSQL; production users… | ||
| Citus on Kubernetes | Álvaro Hernández | 28m |
StackGres plus Patroni 3.0 integration automates Citus on Kubernetes by handling CREATE EXTENSION, shared_preload_libraries, authentication and the UDF… | ||
| Demystifying Postgres Foreign Key Constraints on Citus | Onder Kalaci | 26m |
Citus 11.3 enforces foreign keys by creating local FKs on nodes so each FK is checked by the Postgres instance that holds the relevant shard. Distributed FKs… | ||
| Divide and Conquer: Multi-tenancy in Postgres | Karen Jex | 28m |
Compares concrete multi-tenant architectures and tradeoffs: one VM per tenant gives maximal isolation and per-tenant tuning but high operational cost… | ||
| Do more with less: How to reduce your PostgreSQL costs on Azure | VARUN DHAWAN | 30m |
Video of a conference talk about 10 things you can do today to reduce the cost of Azure Database for PostgreSQL, delivered at Citus Con: An Event for Postgres… | ||
| For Your Eyes Only: Roles, Privileges, and Security in PostgreSQL | Ryan Booz | 27m |
Explains how PostgreSQL enforces the Principle of Least Privilege by making object owners the de facto gatekeepers, shows a live demo of role inheritance where… | ||
| How to copy a Postgres database? | Dimitri Fontaine | 28m |
A new open source tool, pgcopydb, implements a practical answer: it uses pg_dump/pg_restore for schema but streams table data with a custom COPY protocol, runs… | ||
| Implementing Temporal Features in PostgreSQL: SQL Standard and Beyond | Henrietta Dombrovskaya | 23m |
A prototype extension pg_bitemporal implements bitemporal storage on PostgreSQL using GIST exclusion index for non‑overlapping business keys and efficient… | ||
| In depth guide to Postgres’ new CI | N. Byavuz | 26m |
Explains how Postgres CI uses Cirrus CI to run regression suites across platforms (available on PG16 availability), the exact enablement steps: fork the repo… | ||
| Lessons learned: Migrating from AWS-Hosted PostgreSQL RDS to Self-Hosted Citus | Matt Klein | 24m |
Jellyfish moves from AWS RDS to self-hosted Citus to cut a roughly 40% RDS premium, build a sharded cluster and actually scale; work includes denormalizing… | ||
| Maps with Django (and PostGIS) | Paolo Melchiorre | 22m |
Builds a web map end-to-end: starts with Spatialite and a Django project, adds a Leaflet front end, enables GeoDjango (requires GDAL), uses the Django admin… | ||
| Multi-tenant Saas apps made simple on Azure Cosmos DB for PostgreSQL | Alicja Kucharczyk, Adam Wolk | 27m |
Azure Cosmos DB for PostgreSQL is a managed Postgres service using the Citus extension that shards by a distribution key to scale writes and reads, supports… | ||
| Optimizing Postgres for write heavy workloads ft. Checkpoint and WAL configs | Samay Sharma | 31m |
Explains concrete knobs and measurements: autovacuum threshold defaults to 0.2 and often needs lowering to 0.02 or 0.002 for heavy writes; WAL tuning… | ||
| Partitioning strategy for Oracle to PostgreSQL migrations on Azure | Adithya Kumaranchath | 24m |
Uses ora2pg to convert schemas, Azure Data Factory to run parallel copy jobs (five concurrent copy tasks), and PG Partman to auto-create and manage partitions… | ||
| Postgres and the Artificial Intelligence Landscape | Bruce Momjian | 25m |
Shows an actual PL/Perl demo that builds tensors and neurons inside Postgres, trains on 10,000 training rows, and tests with additional runs, achieving roughly… | ||
| PostgreSQL performance tips you have never seen before | Hans-Jürgen Schönig | 25m |
Shows concrete wins: switching from TCP localhost to a UNIX socket doubles a trivial SELECT 1 throughput (100,000→200,000 tps), packing fixed-size columns… | ||
| PostgreSQL Security: Defending Against External Attacks | Taras Kloba | 32m |
Shows that search engines like shodan io, Censys and BinaryEdge find ~600,000 public Postgres instances and that a Hydra brute-force demo using a… | ||
| Practical approach to building real-time analytics for cybersecurity applications | Slava Moudry | 22m |
Pipeline architecture and hands‑on choices for real‑time cybersecurity analytics using Citus + Postgres: a Kafka front end, per‑tenant sharding with a… | ||
| Self Hosted Citus using Cloud Computing | Paul De Audney | 25m |
SafetyCulture moves a high‑write SaaS workload onto a self‑hosted Citus cluster to handle a >12 TB hottest table with thousands of TPS; tooling and practice… | ||
| Troubleshooting High CPU Utilization in PostgreSQL Databases | Dmitry Romanoff | 26m |
Shows concrete SQL checks and fixes: count connections (example 3,457 of 9,057 slots ≈ 38%), list non‑idle sessions and top queries (one query had 40 active… | ||
| Twisting PostgreSQL into a Document Db and Event Store | Jeremy Miller | 36m |
Marten converts PostgreSQL into a usable document database and event store by using Postgres JSONB and Npgsql, building documents as single JSONB blobs and… | ||
| Unconventional ways to index UUIDs in PostgreSQL | Haki Benita | 34m |
Benchmarking shows no-index point lookups at ~179 ms, while a 30 MB B-tree gives ~0.02 ms and a 32 MB hash index is slightly faster for single-row UUID… | ||
| Understanding & Managing Postgres Table Bloat | Chelsea Dole | 25m |
Explains that Postgres bloat comes from MVCC creating dead tuples (heavy UPDATE/DELETE patterns) plus conservative autovacuum settings; measurable with… | ||
| Post-Americas Livestream Wrap Up | Claire Giordano, Robert Treat | 20m |
Wrap-up lists concrete takeaways: 25 on-demand talks with recorded trailers covering PG performance/security, deep dives like UUID indexing and partitioning… | ||
| Post-EMEA Livestream Wrap Up | Claire Giordano, Jelte Fennema-Nio | 19m |
Wrap-up lists 25 on-demand talks and plays highlight reels covering Postgres performance, security, Azure Cosmos DB for PostgreSQL with Citus, Kubernetes… | ||
| nothing matches | ||