PGConf.dev 2025
| title | author | length |
|---|---|---|
| Scaling Postgres to the next level at OpenAI | Bohan Zhang | 51m |
Postgres runs as a single-primary, multi-replica fleet and handles millions of QPS by moving shardable writes off-platform, reducing writer count in… | ||
| Compiling Postgres to WASM with PGlite | Sam Willis | 26m |
PG Lite compiles Postgres to WASM using Emscripten, embeds initdb, and replaces forking with single-user mode plus an unwound main loop that avoids syncify… | ||
| What is new in C and POSIX? | Peter Eisentraut | 50m |
C23 is now an ISO standard published 2024 and POSIX 2024 collects many de facto practices into a formal API, while PostgreSQL still targets C99 and POSIX 2008… | ||
| What can Postgres learn from DuckDB? | Jelte Fennema-Nio | 21m |
DuckDB is an in-process analytics engine that claims far faster analytics than Postgres on ClickBench and can read CSV/Parquet/Arrow directly from S3 or HTTP… | ||
| Writing fast C code for a modern CPU (and applying it to PostgreSQL) | David Rowley | 52m |
Modern superscalar CPUs reward predictability: measured on Zen4 and Zen2, branch misprediction stays near 0.03% for 1,000-item patterns but rises to >12% by… | ||
| What went wrong with AIO | Andres Freund | 51m |
Five years of work produces a merged core AIO path landing in PG18 but not full write support yet; a prototype using io_uring and later worker mode survives… | ||
| Investigating Multithreaded PostgreSQL | Thomas Munro | 46m |
Postgres still uses a 1980s process-per-connection design and this work evaluates replacing that with threads by testing prototypes: a pg_threads.h shim… | ||
| Re-engineering Postgres for Millions of Tenants | Gwen Shapira | 52m |
Nile modifies Postgres with an extension, a Go gateway, and a custom storage manager that puts tenant partitions on per-tenant table spaces backed by object… | ||
| Fast-path locking improvements in PG18 | Tomáš Vondra | 28m |
Postgres 18 expands fast‑path locking from a fixed 16‑oid per‑backend buffer to any number of 16‑way set‑associative chunks (size tied to… | ||
| Keynote: From RAP to Snowflake - A Look at 50 Years of SQL DB Scalability | David DeWitt | 53m |
A 50‑year retrospective traces early database machines (RAP, Chasm, Raries) as academic prototypes that mostly fail, the first parallel systems (Direct runs… | ||
| Multidimensional search strategies for composite B-Tree indexes | Peter V Geoghegan | 47m |
Adds Postgres 18 nbtree skip scan that treats composite B‑tree indexes as multidimensional and turns some full index scans into a series of small index… | ||
| What 10 Postgres Major Contributors Did to Become a Hacker | Claire Giordano | 25m |
Ten seasoned Postgres contributors report concrete, repeatable steps: read the Postgres mailing lists end-to-end, study specific books (From Nand to Tetris… | ||
| Vector search is now boring, but PostgreSQL has ways to go | Jonathan S. Katz | 52m |
pgvector extension adds a vector type and custom indexes and yields up to ~150x faster index builds compared to earlier versions, making HNSW defaults work for… | ||
| Designing and implementing a monitoring feature in PostgreSQL | Rahila Syed | 32m |
New core PostgreSQL feature (committed for PostgreSQL 18) implements on‑demand memory‑context dumps using dynamic shared memory: a coordinating backend creates… | ||
| The trouble with extensions | Marco Slot | 52m |
Extensions add features like PG DocumentDB, PG Parquet, Citus and pg_cron but introduce real hazards: binary vs extension version mismatches cause segmentation… | ||
| Debugging Data Corruption in PostgreSQL | Palak Chaturvedi | 20m |
A practical framework walks from extracting clues in PostgreSQL logs to verifying files with ls, stat and dd, using pageinspect and GDB to inspect pages and… | ||
| Application Development Challenges with Postgres | Dian Fay | 41m |
Practical survey of using Postgres as an app backend that names real pain points and concrete tools: ORMs, query builders, PG Promise, JDBC limits, testing… | ||
| Rethinking PostgreSQL Performance in the Age of Monster Hardware | Lætitia Avrot | 26m |
Postgres is largely not NUMA-aware, so on modern multi-socket servers shared_buffers can sit on a different NUMA node than worker processes, increasing… | ||
| Improving scalability; Reducing overhead in shared memory | Matthias van de Meent | 43m |
Work targets big shared structures so autoscaling can shrink shared_buffers without hitting immovable metadata. It replaces dino_hash with co‑allocated buckets… | ||
| Tracking plan shapes over time with Plan IDs, and a new pg_stat_plans | Lukas Fittl | 24m |
A patch adds a plan ID field in PlannedStmt so extensions can record plan shapes; a new pg_stat_plans extension (PGstep 2.0) uses the cumulative statistics API… | ||
| Committer Review: An Exercise in Paranoia | Robert Haas | 50m |
Explains why committers act cautiously: committing creates open‑ended responsibility for breakage and long‑term maintenance, so reviewers follow a hierarchy —… | ||
| Changing shared_buffers on the fly | Ashutosh Bapat, Dolgov, Ashutosh | 52m |
Proposes changing shared_buffers at runtime by splitting the big shared segment into per-structure mappings, reserving address space and using anonymous… | ||
| Exploring the benefits of learned indexes in PostgreSQL: Theory and Implementation | GARY W EVANS, Nishchay Kothari | 50m |
Built an extension that wraps the ALEX learned index and calls its C++ API via the PostgreSQL AM hooks, bulk‑loading tuples from heap into an in‑memory ALEX… | ||
| postgresql.org: The hidden parts | Magnus Hagander | 27m |
Volunteer-run PGInfra of seven people runs git.postgresql.org with a hidden master, the canonical downloads and apt/yum repos, 67 VMs across multiple… | ||
| A journey toward the columnar data store - lessons from past discussions and new proposals | Aya Iwata | 36m |
VCI is an in-memory columnar index that stores read-optimized columns (ROS) and a tiny write-optimized store (WOS) with on-the-fly conversion to temporary… | ||
| Lightning Talks | Grant Zhou, David Wein, Akash Shankaran, James Miller, Rintaro Ikeda, Stacey Haysler, Lukas Fittl, Dian Fay, Ruohung Feng, Alastair Turner, Chioma Onyekpere | 48m |
Claims and patches land fast: a Postgres variant implements time-based MVCC by recording atomic commit times in the clog and using ClockBound to get bounded… | ||
| ChatGPT Ain’t Got $%@& On Me! Next Generation Automated Database Tuning | William Zhang | 48m |
A new ProtoX holistic tuner for PostgreSQL 15 runs on Ubuntu 22 with 192 GB RAM and SSD and uses hypo_pg and pg_hint_plan plus small planner hooks to read… | ||
| My Journey in PostgreSQL bug fixing | Bertrand Drouvot | 42m |
Shows how a real PostgreSQL bug is narrowed from “works in 14, crashes in 13” to a single commit using git bisect, reproduces an assertion crash by attaching… | ||
| Opening Session | Melanie Plageman, Jonathan S. Katz | 10m |
Conference opens with logistics: venue Wi‑Fi is available via Wi‑Fi QR codes and t‑shirts and sponsor swag sit at registration; lightning talk signups close… | ||
| Fraught Feedback: Trying and Failing to Implement Adaptive Behavior in Postgres | Melanie Plageman | 50m |
Attempts use a PID-style feedback controller to pace autovacuum by converting desired removal rates into per-page delays (example: 1,000 dead tuples/sec, ~40… | ||
| PostgreSQL container groups, aka cgroups down the road | Cédric Villemain | 27m |
Prototype integrates postgresql-cgroups branch with systemd cgroup v2 to create hierarchical groups (critical, workload, maintenance), uses systemd delegation… | ||
| Reproducible Postgres | Javier Maestro, Álvaro Hernández | 26m |
Reproducible Postgres builds an Apache‑licensed upstream distribution that guarantees bit-by-bit reproducibility by using hermetic sandboxed builds with Bazel… | ||
| Advanced testing with Injection Points | Michael Paquier | 50m |
PostgreSQL 17 adds injection points as a developer testing toolkit built into core (enabled at configure time) with two API files… | ||
| Introducing a Temporal Benchmark in Benchbase | Paul A Jungwirth | 22m |
A Benchbase benchmark for temporal tables is implemented with two tables (employees, positions) and procedures for inserts, updates, deletes, joins and three… | ||
| What does moving to Pull Requests look like? The nginx story | Alastair Turner | 21m |
nginx moves Sept 2024 move to GitHub, shuts its old forums and bug tracker by end of December, giving about five months of data. code churn is low: 50–60… | ||
| Adventures in Extension Packaging | David E. Wheeler | 50m |
PGXN v2 prototypes a binary distribution: a trunk package format bundled into OCI image index artifacts, with a CLI that pulls the correct image for OS/PG… | ||
| Revisiting XTM: A Practical Case Study Highlighting Its Needs | Yuya Watari | 41m |
Implements a concrete XTM-style change by adding an XTPC field to snapshots and altering heap visibility checks so local shard reads wait for prepared… | ||
| PostgreSQL Europe Diversity Task Force | Karen Jex | 23m |
Postgres Europe creates a Diversity Task Force in 2024, secures a budget by end of 2024, and publishes a first annual report with quarterly interim updates… | ||
| Everything You Need to Know About Diversity in 25 Minutes | Stacey Haysler | 24m |
Postgres community now runs formal programs: PGUS diversity committee, PGEU task force, sponsor ticket donations (Microsoft, PGX) that send 11 attendees via… | ||
| nothing matches | ||