POSETTE: An Event for Postgres 2026
2026-06-16..2026-06-18
-- online --
[POSETTE: An Event for Postgres 2024, POSETTE: An Event for Postgres 2025, POSETTE: An Event for Postgres 2026]
as the organisers put it
POSETTE: An Event for Postgres is a virtual and free developer event that happened on 16-18 June 2026, organized by the Postgres team at Microsoft. You don’t have to watch all 44 talks, but there are bound to be some that will help you in your Postgres work. Get inspired.
who it's for
Postgres core contributors, cloud database engineers, database administrators, site reliability engineers, extension and tooling authors, data engineers, security engineers
topics
logical replication and Drasi; pgvector and DiskANN vector search; SQL/PGQ property graph queries; WAL internals and buffering; vacuuming enhancements in Postgres 18; partitioning and large table maintenance; Azure VM and storage tuning for Postgres; pg_hba.conf and token authentication; fuzzing libpq and Postgres components; pg_squeeze/pg_repack integration; Citus cluster scaling and Elastic Clusters; Postgres as lakehouse with pg_lake
| title | author | length |
|---|---|---|
| KEYNOTE: Driving Postgres forward at Microsoft | Affan Dar, Charles Feddersen | 22m |
Microsoft reports 345 upstream commits and 64,000 lines changed to Postgres 19, plus work on query planning, async I/O, EXPLAIN I/O, and CVE fixes. Azure adds… | ||
| KEYNOTE: Postgres 19 Hackers Panel: What’s In, What’s Out, & What’s Next | Álvaro Herrera, Heikki Linnakangas, Melanie Plageman, Thomas Munro | 31m |
Postgres 19 reaches feature freeze with concrete wins and clear deferrals: pg_squeeze/pg_repack integration lands in core using logical decoding and fixes… | ||
| An MCP for your Postgres DB | Pamela Fox | 24m |
Builds an MCP server for PostgreSQL in Python using the FastMCP SDK, connects agents (demo with GitHub Copilot using Opus 4.6) to query a demo DB (5 tables… | ||
| Building Event-Driven Systems with PostgreSQL Logical Replication and Drasi | Diaa Radwan | 27m |
Compares three concrete CDC paths: wal2json, Debezium with Kafka, and Drasi (CNCF sandbox) by running the same Locust load and measuring latency, WAL cost, and… | ||
| Building safety tooling for risk-free AI tuning of Postgres | Mohsin Ejaz | 27m |
DBtune builds a safety layer for AI-driven Postgres tuning that actually works: it tests across Aurora, RDS (example db.r6g.4xlarge, 128 GB), GCP, Azure… | ||
| Choose the Right Azure Infrastructure to Improve Postgres Performance by Over 60% | Andrew Ruffin | 23m |
Azure v7 AMD VMs like E16asv7 deliver a measured 63% raw throughput uplift versus a five‑year‑old E16asv5 and a 54% throughput‑per‑dollar advantage, cutting… | ||
| Exploring property graphs with SQL/PGQ in PostgreSQL | Ashutosh Bapat | 27m |
Shows how PostgreSQL 19 committed basic SQL/PGQ to overlay a property graph on relational tables using a Ticket to Ride schema, mapping cities/countries to… | ||
| From Dev to Prod: Securing Postgres the Right Way | Sakshi Nasha | 28m |
Covers concrete fixes: a CVE-2025 SQL injection caused by overreliance on escapeString and client-side sanitization, plus a case where a malicious public… | ||
| From Queries to Agents: The Next Era of Data Retrieval on PostgreSQL | Abe Omorogbe | 24m |
Argues Postgres becomes an agent backend by combining MCP servers, schema/semantic/relationship/safety context correction, and in‑DB blended retrieval using… | ||
| From trust to Tokens: A Short History of PostgreSQL Authentication | Murat Tuncer | 22m |
pg_hba.conf is where authentication actually happens and its dozen methods reflect historical trade‑offs: original trust/peer Unix assumptions, MD5 hashes that… | ||
| Fuzzing PostgreSQL | Adam Wolk | 24m |
Shows applying fuzzing to Postgres’ client library libpq, building minimal harnesses that feed mutated protocol inputs directly into library entry points, and… | ||
| Journey of developing a performance optimization feature in PGSQL | Rahila Syed | 33m |
A concrete feature is implemented that lets the WAL sender transmit unflushed WAL ahead of disk flushes, with the protocol carrying a flush pointer so the… | ||
| JSON in PostgreSQL - evil data type or just needs to be tamed? | Boriss Mejias | 25m |
Shows concrete fixes: extract IDs into columns so foreign keys work, add a unique index on JSON->>'id', and pull Frequently Updated Fields (likes/shares) out… | ||
| Linux and PostgreSQL in the Multiverse of Connections | Josef Machytka | 26m |
Postgres’ process-per-connection model creates concrete Linux and DB costs: shared_buffers mapped with 4KB pages can blow PTE tables into tens of gigabytes… | ||
| LISTEN Carefully: How NOTIFY Can Trip Up Your Database | Jimmy Angelakos | 26m |
A trigger that runs NOTIFY on every commit obtains a cluster-wide access-exclusive lock on pg_database to serialize delivery, causing surprising lock timeouts… | ||
| Maintaining Large Tables in PostgreSQL | Sarat Balijepalli | 27m |
Diagnoses specific failure modes—autovacuum falling behind causing silent table and index bloat, cache trashing as working set exceeds memory, vacuum/freeze… | ||
| Migrating VLDBs from Oracle to Azure Database for PostgreSQL | Adithya Kumaranchath | 25m |
Migration strategy for multi‑terabyte Oracle workloads shows a successful 16 TB case that uses a phased approach: Ora2Pg for schema conversion, parallel… | ||
| Modelling Postgres Performance Degradation on Burstable Cloud Instances | Chun Lin Goh | 24m |
Uses a discrete event simulation to compute the exact saturation point of burstable Postgres on B-series/T-series instances, modeling the token‑bucket CPU… | ||
| Move Less, Move Faster: Speeding Up Citus Cluster Scaling | Muhammad Usama | 31m |
A real-world 18–20 TB Citus rebalance that used to take 3–4 days gets two concrete changes: a parallel rebalancer that copies reference tables concurrently… | ||
| My Postgres partitioning cookbook | Derk van Veen | 26m |
After four years of experiments the claim is clear: start partitioning before ~100 GB and use range-based partitioning not hash. Notes include Postgres 14… | ||
| Past, Present, and Future: Logical Decoding and Replication in PostgreSQL | Hari P Kiran | 31m |
Starts with the logical decoding API (Postgres 9.4) plus replication slots and replica identity, extended by pglogical to add publish/subscribe; Postgres 10… | ||
| pg_duckdb in Action: Accelerating Analytics on Azure Database for PostgreSQL | Nitin Jadhav | 24m |
pg_duckdb embeds DuckDB 1.4.3 inside Azure Database for PostgreSQL Flexible Server and converts eligible SELECT plans to DuckDB’s vectorized engine, claiming… | ||
| pg_lake: Postgres as a lakehouse | Marco Slot | 25m |
pg_lake adds Iceberg tables to Postgres, implements a separate DuckDB delegation server (avoiding per-connection memory blowup), and provides pg_incremental… | ||
| pg_stats: How Postgres Internal Stats Work | Richard Yen | 26m |
Shows exactly what pg_stats and pg_statistic contain and how ANALYZE builds them, with concrete numbers: a 1,000,000‑row customers table yields ~17,000 rows… | ||
| pgcov: Bringing Real Test Coverage to PostgreSQL Code | Pavlo Golub | 24m |
pgcov instruments SQL and PL/pgSQL by injecting pg_notify calls before executable statements, listens for those notifications to map executed byte ranges, and… | ||
| Postgres isn’t slow, your storage is | Sai Krishna Srirampur | 27m |
Benchmarks show Postgres on local NVMe achieves about 9x throughput and 4 ms median update latency versus 37 ms on EBS in a 3.3B-row pgbench workload… | ||
| PostgreSQL 17 vs 18: Side‑by‑Side Performance Wins in Real‑World Queries | Divya Bhargov | 26m |
Identical Azure VMs run Postgres 17 and 18 with EXPLAIN ANALYZE, seven measured runs and one warmup so timings are cache‑hot; results show concrete wins: a 43%… | ||
| PostgreSQL Design Patterns | Chris Ellis | 24m |
Shows concrete patterns and working SQL: use a timestamp range column (generated from start/end) plus an exclusion constraint (GiST + btree_gist) to prevent… | ||
| PostgreSQL Generated Columns by Example | Paolo Melchiorre | 26m |
PostgreSQL 18 makes generated columns virtual by default, letting reads compute values on demand while older stored columns persist results; benchmarks shown… | ||
| PostgreSQL queues done right with PgQ | Alexander Kukushkin | 29m |
Postgres queue PgQ claims to replace SKIP LOCKED designs with a lockless, MVCC-based approach that keeps throughput high and bloat low. It stores events in… | ||
| PostgreSQL Tooling Across AI Editors and Agents | Matt McFarland | 20m |
PostgreSQL tools move from a VS Code extension with half a million installs into Cursor and the GitHub Copilot CLI by shipping a standalone MCP server and a… | ||
| PostgreSQL vs. SQL Server: Security Model Differences | Taiob Ali | 28m |
Compares concrete differences: Postgres uses cluster-level roles with database-scoped grants while SQL Server separates logins and users; demo uses Docker… | ||
| Production RAG at Scale with Azure Database for PostgreSQL | Paula Santamaría, Julia Schröder Langhaeuser | 26m |
Serenity Star runs RAG on Azure Database for PostgreSQL using pgvector for embeddings, exploring DiskANN for approximate nearest-neighbor search, and… | ||
| Querying & Visualizing Graphs in Postgres with Apache AGE | Christian Miles | 22m |
Apache AGE runs graph workloads inside Postgres (supports Postgres 11–18, available on major clouds) and exposes embedded Cypher in SQL (the demo shows concise… | ||
| Quorum-Based Consistency for Cluster Changes with CloudNativePG Operator | Jeremy Schneider, Leonardo Cecchi | 28m |
CloudNativePG adds a failoverQuorum CRD (since v1.28) that maps Postgres’ synchronous_standby_names into three values N (target set), W (required standbys) and… | ||
| random_page_cost in Postgres - why the default is 4.0 and should you lower it? | Tomáš Vondra | 27m |
Recreates the original 2000s experiment: large uniform tables, forcing index vs sequential scans, and measuring per-page timings with direct I/O and EXPLAIN… | ||
| The Hitchhiker’s Guide to PostgreSQL Hacking: Don’t Panic, Just Start Small | Xuneng Zhou | 24m |
A practical roadmap: start by reviewing patches, run make check and reproduce tests, then use perf and benchmarks to connect design to measurement. Implements… | ||
| The Rise of PostgreSQL as the Everything Database | VARUN DHAWAN | 25m |
Postgres claims to replace many specialized databases by running documents, search, time-series, vectors, GIS, graph and OLAP in one engine using extensions… | ||
| The Wonderful World of WAL | Bruce Momjian | 26m |
Explains that WAL is the durable change-log that actually contains row bytes (demo: inserted string appears only in WAL until checkpoint), and that replay… | ||
| Vacuuming Enhancements in PostgreSQL 18: Faster, Smarter, More Predictable | Shashikant Shakya | 19m |
Postgres 18 adds a practical set of VACUUM changes: an asynchronous I/O subsystem (io_method=worker, io_workers default 3, scalable to ~12) that overlaps reads… | ||
| What I’ve Learned Teaching Postgres to 200+ field engineers at Microsoft | Paula Berenguel | 23m |
Built an upskilling pipeline for 200+ field engineers focused on Azure Database for PostgreSQL Flexible Server, using modular modules (HA, migration, pgvector… | ||
| What's new with constraints in Postgres 18 | Gülçin Yıldırım Jelínek | 27m |
Postgres 18 adds concrete, usable features: temporal keys WITHOUT OVERLAPS lets a composite key include a range/multirange (GiST + gist_range_ops) to prevent… | ||
| Where Does My INSERT Go? A Logical Replication Story | Hamid Quddus Akhtar | 28m |
Follows one INSERT from executor to subscriber, showing WAL construction, why wal_level=logical adds column and relation metadata, and how ReorderBuffer groups… | ||
| Why we built Azure HorizonDB for PostgreSQL | Dingding Lu | 19m |
Azure HorizonDB claims predictable latency under spikes by separating compute and storage, using shared WAL storage plus a sharded data storage fleet and NVMe… | ||
| nothing matches | ||