Citus Con: An Event for Postgres 2022
2022-04-12..2022-04-13
-- online --
[Citus Con: An Event for Postgres 2022, Citus Con: An Event for Postgres 2023]
as the organisers put it
Join us at Citus Con: An Event for Postgres, a virtual, free, and global event happening on April 12-13 in 2022. Come learn with us and discover what amazing things people are building with Postgres and with Citus, both on Azure and with open source. Mark your calendar!
who it's for
postgres DBAs, Citus users, cloud engineers, data engineers, database architects, open source contributors
topics
Citus 11 metadata syncing; Hyperscale Citus migrations; shard key selection for Citus; PostGIS on Citus at scale; perf and bpftrace tracing; IO prefetching for Postgres; pg_stat_statements observability; Postgres query optimizer internals; autovacuum optimization; Azure Database for PostgreSQL Flexible Server; point-in-time query tuning; Django with PostgreSQL
| title | author | length |
|---|---|---|
| The Building Blocks for Self-Driving PostgreSQL | Andy Pavlo | 33m |
Claims a working path to a true self-driving database by combining workload forecasting, learned component behavior models, and automated action deployment… | ||
| PostgreSQL—more relevant than ever | Magnus Hagander | 30m |
PostgreSQL proves relevance with concrete wins: a permissive license that lets vendors and users redistribute and embed it, wide adoption like three Azure… | ||
| 8 keys to the growth of Citus & Distributed PostgreSQL | Umur Cubukcu | 32m |
Citus adds distributed tables to PostgreSQL by shipping as an extension rather than a fork, enabling unforking from Postgres and same-day support for new PG… | ||
| Analyzing Postgres performance problems using perf and eBPF | Andres Freund | 27m |
Uses perf to find kernel-side hotspots (high CPU in TLS/crypto locks) and shows that upgrading OpenSSL 1.0.2 → 1.1 raises pgbench throughput ~4x and halves… | ||
| Building geospatial apps on Postgres, PostGIS, & Citus at large scale | Nirav Savani, Mahipal Ramidi | 30m |
A geospatial analytics platform built on PostGIS + Citus on Azure Hyperscale handles a 25 TB dataset and supports 3,000 users with 10–50 concurrent analysts… | ||
| Citus 11: A look at the Elicorn's Horn | Marco Slot | 32m |
Citus 11 enables query via any node by replicating table schemas, functions, indexes and sequences to workers with automatic schema and metadata syncing… | ||
| Citus Cluster: our zero-downtime migration story | Matthieu Dumont, Antoine Hemery | 28m |
Algolia migrates a 5TB analytics Citus cluster (spread over 20 machines) from Citus Cloud to Azure Hyperscale with goals of zero downtime, stability, and no… | ||
| Developing IO Prefetching for Postgres | Melanie Plageman | 30m |
A feedback-driven prefetcher is developed and evaluated with a custom prefetch simulator that models io_uring submission/completion rings, a max IOPS + latency… | ||
| Efficiently distributing Postgres with Citus – How to choose the right shard key? | Sai Krishna Srirampur | 28m |
Citus uses a create_distributed_table shard key to hash and place rows across workers; pick a column with hundreds-to-tens-of-thousands cardinality to avoid… | ||
| Explaining the Postgres Query Optimizer | Bruce Momjian | 29m |
Explains how PostgreSQL chooses sequential, bitmap or index scans and when it picks nested loop, hash or merge joins, using EXPLAIN on temporary sample tables… | ||
| Fibonacci Spirals and Ways to Contribute to Postgres—Beyond Code | Claire Giordano | 32m |
Postgres grows beyond code with 18 ways to contribute including concrete actions: publish blogs syndicated on Planet Postgres, make short videos with rich… | ||
| First Experiences with Azure Database for PostgreSQL Flexible Server | Johannes Schuetzner | 33m |
Hands-on Azure Flexible Server deployment for MB.OS uses Terraform 2.91.0 and Azure DevOps pipelines, provisioning consolidated Postgres instances on Linux… | ||
| How secure is your database? Hacking Postgres with Hathi | Anthony Shaw | 30m |
A free MIT‑licensed tool called Hathi automates database dictionary attacks against Postgres (also MySQL and SQL Server): install with pip install hathi on… | ||
| Lesser known features of PostgreSQL | Haki Benita | 30m |
Shows concrete Postgres tricks: use the system column xmax to tell xmax = 0 trick which upsert rows were inserted vs updated, use pg_sleep_for(interval) to… | ||
| Localization on PostgreSQL | Keisuke Takahashi | 29m |
Compares 10 collations (libc and ICU) on Hyperscale (Citus) using 165 Unicode characters across English, Japanese, and Chinese, measuring planner cost with… | ||
| New features of the Odyssey connection pooler | Andrey Borodin | 30m |
Odyssey 1.3 ships two concrete features: standby lag polling and prepared statement pooling. Standby lag polling runs a watchdog query on each replica, records… | ||
| OSSom for Better Oracle to Postgres Assessments | Alicja Kucharczyk, Diaa Radwan | 27m |
A tool called OSSom (OSS Open Migrator) wraps ora2pg in a containerized Flask UI that runs ora2pg, applies the converted DDL to Postgres and reports counts and… | ||
| Queues in PostgreSQL | Thomas Munro | 30m |
Argues PostgreSQL is a practical choice for moderate single-node job queues when work must be transactional and ops already manage the database. Recommends… | ||
| Advanced INT to BIGINT Conversions | Robert Treat | 25m |
Postgres integer overflow hits around 2.1 billion and causes sudden outages; recommended quick fix is ALTER SEQUENCE to restart at a negative min (buying ~2… | ||
| Big Spatiotemporal Data Management Using MobilityDB & Citus | Mohamed Bakli | 25m |
MobilityDB + Citus on Azure stores and queries continuous trajectories (tgeompoint) and achieves dramatic compression and scale: converting flat logs to… | ||
| Build Your Business Based On PostgreSQL Databases | Bob Wuisman, Alan Palacio | 20m |
Ebiquity’s Digital Innovation Center runs PostgreSQL as the central store, migrating from a single node to PostgreSQL 13 on Azure Flexible Server and keeping… | ||
| Data modeling for those who want to save time and money! | Danielle Monteiro | 34m |
Postgres on Azure is practical: redesigning a normalized schema reduces storage by 15× smaller and cuts index bloat to 10× fewer indexes, replaces a separate… | ||
| Data modeling, the secret sauce of building & managing a large scale data warehouse | Min Wei | 25m |
VeniceDB sits on PostgreSQL + Citus on Azure and handles telemetry from ~1.5 billion devices, serving ~10 million queries/day (≈2 million distinct). Schema… | ||
| Django with PostgreSQL superpowers | Paolo Melchiorre | 23m |
Shows how to wire PostgreSQL into Django using psycopg3, Django’s contrib.postgres and a few third‑party packages, demonstrates updating nearly one million… | ||
| Fix your Strings in PostgreSQL | Francesco Tisiot | 30m |
Shows concrete fixes: convert freeform columns to proper types (dates, integers, arrays), add a phone domain with a regex so bad formats fail, and split… | ||
| Following Select Statements Through Citus Internals | Onder Kalaci | 23m |
Citus extends Postgres planner and executor to produce a distributed plan made of task is a SQL command units that run on regular Postgres shards tracked in… | ||
| Handle Azure PostgreSQL Auditing With Ease | Josephine Bush | 23m |
Shows how to enable pgaudit on Azure Database for PostgreSQL by checking shared_preload_libraries, restarting the server, and running CREATE EXTENSION per… | ||
| How to scale Postgres for time series data with Citus | Burak Velioglu | 28m |
Shows how to turn Postgres partitioned time-series into a distributed, compressed store using Citus UDFs and pg_cron. Demonstrates create_time_partitions and… | ||
| Lessons from Optimizing Citus Queries at Heap | Matt Dupree | 23m |
Heap uses confidence intervals to prove performance changes are real, not noise, and turns index-only scans into real wins by either including the expression… | ||
| Lessons learned scaling our SaaS on Postgres to 8+ billion events | Jonathan Denney | 20m |
ConvertFlow scales from Rails on Heroku Postgres to a Citus sharded cluster on Azure, processing 8.7 billion events and serving ~40M monthly visitors… | ||
| Loading at Hyperscale: Advanced Data Import Techniques for Citus | Colton Shepard | 32m |
Citus parallelizes writes so COPY at 500k/sec becomes realistic while microbatching (100–1,000 rows per COPY) commonly reaches ~100k inserts/sec; index… | ||
| NO ARRAY OF SUNSHINE: an introduction to data types from a data quality perspective | Renee Huinker | 19m |
Choice of PostgreSQL data types directly changes data quality: smallint (2 bytes, ±32k), integer (4 bytes, ±2 billion) and bigint (8 bytes) determine storage… | ||
| Optimizing autovacuum: PostgreSQL’s vacuum cleaner | Samay Sharma | 32m |
Autovacuum wakes by default every minute (autovacuum_naptime = 60s) and triggers when dead tuples exceed a scale factor (example: a 100M‑row table with… | ||
| Point-in-time query tuning and observability with pg_stat_statements | Ryan Booz | 25m |
pg_stat_statements is cumulative by default (resets on restart or manual reset) and exposes 31 columns of stats; the method shown snapshots that view… | ||
| Top 10 reasons to choose Flexible Server for Azure Database for PostgreSQL | Sunil Agarwal | 26m |
Flexible Server runs on Linux with premium SSDs, synchronous HA standby for zero data-loss failover, and zone‑redundant backups with transaction log uploads… | ||
| What I learned creating Postgres monitoring metrics for Citus on Azure | Sena Gungor | 13m |
Practical guide to Hyperscale (Citus) monitoring on Azure: recommends exporting constant, tagged metrics at a tunable granularity and alerting disk at ~90%… | ||
| What I learned interviewing the PostgreSQL Community | Andreas Scherbaum | 22m |
Project runs weekly interviews (97 by Feb 2022) stored in a private GitHub site built with Hugo and edited via a Google Doc template; 383 people are on the… | ||
| Why Postgres Is Better Than MySQL for Automated Knob Tuning | Dana Van Aken | 18m |
OtterTune deploys an agent that collects runtime metrics and current settings, trains ML models, and iteratively applies new configs for AWS Postgres and MySQL… | ||
| nothing matches | ||