PGConf.dev 2024
| title | author | length |
|---|---|---|
| The road to new SQL/JSON features | Álvaro Herrera | 48m |
Postgres now implements a near-complete SQL/JSON suite landed across several late commit Fests and included in Postgres 17, notably JSON_TABLE with nested… | ||
| How to Engineer Your Developer Blog Posts to Have Bigger Impact | Claire Giordano | 52m |
Argues that empathy as true north beats clever prose: design for skimmers with H2 section headers, bold-start bullets, diagrams, alt‑text and footnotes… | ||
| MySQL replication deep dive, and ideas for PostgreSQL | Jagdeep Sidhu | 52m |
Covers how MySQL writes a binary log (statement vs row formats and the mysqlbinlog decoder), how relay logs and IO/SQL threads move and apply entries, and how… | ||
| Pushing past PostgreSQL’s vertical scaling limits - Running Amazon RDS | Alisdair Owens, Andrei Dukhounik | 40m |
Amazon RDS runs the core metadata Postgres instances at hundreds of thousands TPS and hits vertical limits, so teams use sharding, read replicas, caching… | ||
| Problem in PostgreSQL SLRU - And how we are optimizing it | Dilip Kumar | 48m |
Identifies severe SLRU contention where a 64-entry subtransaction cache overflow plus a long‑running transaction makes pgbench on a 128‑core machine fall from… | ||
| Performance Improvements of Partitioning: Past and Future | Yuya Watari | 50m |
Patch changes equivalence handling so equivalence classes keep only parent members and introduce child members on demand, using bitmap-set indexes to filter… | ||
| Lightning Talks | Keith Fisk, Ashutosh Bapat, Peter Eisentraut, Devrim Gündüz, Lukas Fittl, Bharath Rupireddy, Alena Rybakina, Hannu Krosing, Yurii Rashkovskii, Mohammad Dashti, Yuki Fujii | 46m |
Eleven five‑minute updates cover concrete results and tools: a Prometheus‑focused extension converts slow monitoring queries into materialized views with… | ||
| Time to Go with PostgreSQL | Rafia Sabih | 26m |
Adds a Go module into an existing C PostgreSQL extension (PGDeepThinker) to parse queries and emit advisory messages; uses cgo, a C-side parser (libpg_query /… | ||
| PostgreSQL meets ART - Using Adaptive Radix Tree to speed up vacuuming | Masahiko Sawada | 50m |
PostgreSQL 17 adds an Adaptive Radix Tree plus a new TidStore (bitmap-per-block values plus a combined-pointer leaf) and uses a bump memory context to replace… | ||
| Multi-Entry Generalized Search Trees | Maxime Schoemans | 46m |
PostgreSQL extensions implement MGiST/MSP-GiST to split each tuple into multiple index entries (like GIN but for GiST/SP-GiST) and add an extract_value method… | ||
| Adaptive query optimization in PostgreSQL | Alena Rybakina | 40m |
An extension for PostgreSQL that stores actual cardinalities from executions and uses a K-nearest-neighbors model to predict node cardinalities, sharing those… | ||
| Shaving off bytes at any scale: Space savings in various subsystems of PostgreSQL | Matthias van de Meent | 38m |
Catalog storage switches from verbose text nodes to a binary node format that tests show cuts on-disk catalog size and speeds reads/writes (and still permits a… | ||
| Vectors: how to better support a nasty data type in PostgreSQL | Jonathan S. Katz | 53m |
Explains concrete engineering: pgvector extensions (versions 0.5, 0.6, 0.7) add IVF‑flat and HNSW indexing, SIMD/CPU dispatch and parallel index builds that… | ||
| Online Upgrade of replication clusters without downtime | Hayato Kuroda | 41m |
Explains a concrete, tested upgrade path that converts a streaming pair into a logical replication pair so one node upgrades with minimal downtime: set… | ||
| Implementing Row Pattern Recognition | Tatsuo Ishii | 43m |
Implements SQL:2016 Row Pattern Recognition inside PostgreSQL’s window clause (R020) with a usable subset: RPR in WINDOW clause (R020) supports DEFINE… | ||
| Making PostgreSQL Hacking More Inclusive | Amit Langote, Masahiko Sawada, Melanie Plageman, Robert Haas | 56m |
Postgres hacking faces concrete barriers: non‑native English slows long-form emails, off‑list decisions demoralize authors, and time zones mean many threads… | ||
| Multi-threaded PostgreSQL? | Heikki Linnakangas | 52m |
Proposal to move PostgreSQL from multiprocess to a single-address-space, one thread per connection model that immediately uses fewer TLBs and cheaper forks by… | ||
| Enhancing PostgreSQL Plasticity: New Frontiers in Memory Management | Krishnakumar Ravi | 45m |
Demonstrates experiments that let PostgreSQL shrink live shared_buffers by unmapping cached pages (using mmap/madvise-style tricks) to reduce RSS in a demo… | ||
| Keynote: When Hardware and Databases Collide | Margo Seltzer | 46m |
Argues databases gain most by harnessing GPUs for massive parallel index lookups and OLAP-style batching (academics report 100x improvement in some queries)… | ||
| Analyzing cacheline contention using perf c2c | Andres Freund | 49m |
Demonstrates using perf c2c to locate true cacheline contention in Postgres and traces how that led to snapshot scalability work in PG 14. Covers cache… | ||
| The PostgreSQL Protocol: The Good, the Bad and the Future | Jelte Fennema-Nio | 47m |
Protocol v3 is still the wire standard after 20+ years and uses messages like parse/bind/describe/execute for prepared flows and a ready for query I/T/E status… | ||
| Advice is seldom welcome but efficacious | Tatsuro Yamada | 36m |
Overview of PostgreSQL advisory features with a focus on the execution plan advisor pg_plan_advsr which integrates with pg_hint_plan and pg_cor_stats to… | ||
| Building Petabyte-Scale PostgreSQL Deployments | Chistopher Travers | 48m |
Replaces ElasticSearch after hitting a 1PB limit, citing long GC pauses and cluster rebalances, and builds Bagger: a Kafka-first ingestion pipeline that writes… | ||
| Collations from A to Z | Jeff Davis, Jeremy Schneider | 52m |
Runs a COI torture test of about 26 million strings (91 patterns over 10 years of Ubuntu and RHEL) and finds collation changes in every major release except… | ||
| The future of the extension ecosystem | David E. Wheeler | 54m |
History and numbers frame the case PGXN holds 396 extensions while a GitHub gist finds ~1,200 and ecosystems like crates.io have 146,000 distributions, so the… | ||
| Lessons from the Support Desk | Evan D Macbeth | 48m |
Argues that releases increase support complexity and shows hard numbers: an installation base with ~half still on Postgres 11 or older and six nodes on 9.6, a… | ||
| Pushing boundaries with extensions, for extension | Yurii Rashkovskii | 58m |
Postgres extension limits are measured and patched: minor-version ABI changes break extensions, so an experiment warns on minor mismatches; native library… | ||
| Data Corruption Bugs: Diagnosis and Lessons | Noah Misch | 52m |
Shows concrete debugging sequences using amcheck and pageinspect to find reproducible corruption, with fixes now merged into core. Demonstrates an interval… | ||
| Anarchy in the Database: A Survey and Evaluation of Database Management System Extensibility | Abigale Kim | 52m |
Presents a taxonomy of DBMS extensibility and an automated PostgreSQL extension analysis framework that runs static and dynamic checks on Postgres 15.3 using… | ||
| Tricks from in-memory databases | Andrey Borodin | 48m |
Examines concrete prototypes and numbers: specialization of sort routines shows about 30% faster sort by inlining compare paths; a B-tree variant that embeds… | ||
| Welcome & Opening | Jonathan S. Katz, Melanie Plageman | 19m |
Conference opens with logistics: an evening Rogue West bar social with board games and food, a morning student breakfast, workshops (many signed up) and a… | ||
| PostgreSQL 17 and beyond | Amit Kapila | 43m |
PostgreSQL 17 adds incremental backups via a new background worker that records changed blocks (restored with pg_combine), vacuum improvements using a TID… | ||
| Distributed DDL Replication at Global Scale | Gwen Shapira | 49m |
Nile implements virtual tenant Postgres databases across multiple AWS regions and replicates DDLs by hooking an extension into the process utility hook… | ||
| Postgres and the Artificial Intelligence Landscape | Bruce Momjian | 49m |
Explains how to run machine learning inside Postgres using a PL/Perl demo that builds an 11-neuron tensor and trains it with a 10,000-number training set to… | ||
| Streaming I/O and vectored I/O | Thomas Munro | 48m |
Postgres adds a ReadStream abstraction that groups ReadBuffer calls into larger vectored I/O so scans emit 128k preadv()s instead of many 8k pread()s, using… | ||
| How Autovacuum Goes Wrong: And Can We Please Make It Stop Doing That? | Robert Hass | 59m |
Explains why autovacuum repeatedly fails: the soft cap autovacuum_vacuum_cost_limit is the dominant cause of slow, starved and backlogged vacuums; raising… | ||
| How Postgres is misused and abused in the wild | Karen Jex | 51m |
Many teams treat Postgres like a black box and build fragile workarounds: daily pg_dump jobs run every 20 minutes so point‑in‑time recovery becomes impossible… | ||
| nothing matches | ||