PostgreSQL Conference Europe 2024
2024-10-22..2024-10-25
Athens, Greece
[PostgreSQL Conference Europe 2023, PostgreSQL Conference Europe 2024, PostgreSQL Conference Europe 2025]
as the organisers put it
A 3-day, 4-track PostgreSQL conference with an extra day of training in Athens, Greece.
| title | author | length |
|---|---|---|
| The PostgreSQL License Fee | Stacey Haysler | 42m |
Argues the real “license fee” is time: voluntary work funds PostgreSQL’s upkeep, governance and events rather than cash. Lists concrete assets and… | ||
| Using Postgres to locate the best coffee near you! | VARUN DHAWAN | 48m |
Uses PostgreSQL 16.4 with the Yelp open dataset (≈6.9M reviews, ~150k businesses), adds a TSVector full‑text column, then creates embeddings stored with… | ||
| connection_builder for PostgreSQL community | Valeria Kaplan | 44m |
An 80‑year Harvard study says relationship quality matters more than quantity, so aim for three meaningful conversations rather than meeting everyone; the… | ||
| Performance Archaeology | Tomáš Vondra | 50m |
Benchmarks reconstruct PostgreSQL performance from 8.0 through the current development tip (PostgreSQL 18) using PGBench from PostgreSQL 18, TPCH, and… | ||
| PostgreSQL Observed—and Explained | Stacey Haysler, Karen Jex | 33m |
Never disable autovacuum — it prevents xid wraparound and you can set log_autovacuum_min_duration=0 to see detailed runs; autovacuum defaults to three workers… | ||
| Smooth Sailing... | Sena Güngör Tavukçuoğlu | 47m |
Migration moves ~900 clusters from CentOS to Ubuntu for Azure Cosmos DB for PostgreSQL and finds glibc-driven collation changes force reindex text indexes… | ||
| Incremental Backup | Robert Haas | 49m |
Implements a block‑level incremental backup in PostgreSQL 17 that decides per 8KB blocks which pages to copy, using a background WAL summarizer that emits tiny… | ||
| Finding and fixing a data-corruption bug... | Patrick Stählin | 33m |
Rolling out PostgreSQL 16 causes 0.15% of instances to alert on read errors that trace to the free space map pointing past file end, amplified by a pg16… | ||
| Unearthing the Past with PostgreSQL... | Ophir Lojkine, Thomas Guillemard | 50m |
French archaeologists build a production Postgres/PostGIS database named B.A.D.A.S.S. (Base Archaeological Data: Attributive and Spatial System) with around 40… | ||
| Untangling the Web of PostgreSQL Permissions | Lætitia Avrot | 47m |
States that create user/group are aliases for create role and roles are cluster-wide not per-database, so use pg_dumpall -g to export them; shows psql… | ||
| Identity at Scale; How Okta uses Postgres | Norberto Leite | 51m |
Operating a fleet of 650+ Postgres clusters across two clouds, Okta runs Postgres alongside Redis, DynamoDB and MongoDB and relies on Kubernetes and DBaaS for… | ||
| Comparing Connection Poolers for PostgreSQL | Julian Markwort | 59m |
Compares pgpool-II, pgbouncer, odyssey, pgagroal and pgcat and shows which features actually work: authentication methods supported, TLS client/server gaps… | ||
| Supporting a New PostgreSQL Version in Your Extension... | Naisila Puka | 52m |
Citus follows the Postgres release timeline and works through three concrete steps: make it build, fix failing tests and crashes, then integrate new Postgres… | ||
| Dissimilarity search... | Jonathan S. Katz | 54m |
PGVector implements IVFFlat and HNSW inside PostgreSQL, trading a fixed 8KB page layout and TOAST constraints against in-memory ANN behavior. Builds sample… | ||
| An ultimate guide to upgrading your PostgreSQL installation | Ilya Kosmodemiansky | 50m |
Covers concrete upgrade paths: pg_dump/restore (simple, double disk and downtime), pg_upgrade with hard links (seconds of downtime but risky, needs both old… | ||
| Leveraging AI as a PostgreSQL DBA | Grant Fritchey | 50m |
Demonstrations use free-chat models (OpenAI derivatives, Google Gemini, Microsoft Copilot, Brave, u.com) and show concrete results: generated schema and… | ||
| pg_ivm - Extensions for Rapid Materialized View Update | Yugo Nagata | 45m |
pg_ivm implements Incremental View Maintenance for PostgreSQL (13–17) as an extension that stores IMVs as tables and wires automatic updates with AFTER… | ||
| Streaming I/O and vectored I/O | Thomas Munro, Nazir Bilal Yavuz | 49m |
PostgreSQL adds a streaming abstraction and vectored I/O so multiple 8KB blocks are combined into larger reads/writes (configurable IO combine limit, default… | ||
| Debugging active queries... | Rafael Thofehrn Castro | 47m |
A patch logs instrumented EXPLAIN ANALYZE plans mid-flight to a catalog view (pg_explain_activity) at a configurable interval (default track_explain_interval =… | ||
| Patroni Deployment Patterns | Michael Banck | 50m |
Patroni manages Postgres high availability using a distributed consensus store (etcd/Consul/ZooKeeper or the deprecated pync raft) plus a REST API and… | ||
| Creating a Board Game Chatbot with Postgres, AI, and RAG | Matt Cornillon | 48m |
A working chatbot uses PostgreSQL plus pgvector to store paragraph-chunked rule text, embeddings from Gemini (about 700-dimension vectors) and Document AI to… | ||
| Actual trees, not b-trees... | Johannes Paul | 24m |
A public database is built on PostgreSQL + PostGIS import pipeline to map trees across Germany, ingesting CSV exports from five different collection systems… | ||
| –Mom, can we have G**gle Maps? –We have G**gle Maps at home | Jimmy Angelakos | 50m |
Claim: avoid paid map APIs by importing OpenStreetMap dumps into PostgreSQL + PostGIS and running geospatial queries yourself. Tools demonstrated: pgmflex to… | ||
| Fearless Extension Development With Rust and PGRX | James Blackwood-Sewell | 46m |
Rust bindings (pgrx) let extensions call the Postgres C API safely, compile to native shared libraries, and run against Postgres 12–17 using the cargo-pgx tool… | ||
| Supporting extensions, but really now | Floor Drees | 49m |
Argues that PostgreSQL’s extension ecosystem is under-resourced and vulnerable, citing concrete numbers: 44% solo maintainers, 58% considered quitting, 22%… | ||
| The Wire Protocol | Heikki Linnakangas | 52m |
Postgres uses Protocol version 3 with messages framed as a 1‑byte type plus a 4‑byte length (length excludes the type byte); startup packet includes… | ||
| Practical Memory Tuning for PostgreSQL | Grant McAlister | 48m |
Poor memory settings cause dramatic slowdowns: a misconfigured server shows an 11x reduction in throughput when buffers and swap are wrong, and the OOM killer… | ||
| Introduction to Fair-Use TPC Benchmarking Kits | Mark Wong | 51m |
Overview of freely available TPC fair‑use kits that run on Linux and OSDL test kits used to generate and load data then run tests; demos use TPC‑C, TPC‑E… | ||
| Speeding up logical replication setup | Euler Taveira | 51m |
pg_createsubscriber for Postgres 17 converts a prepared physical replica into a logical one to avoid slow per-table COPY-based initial sync, creating… | ||
| From VMs to Cloud-Native PostgreSQL in Kubernetes... | David Pech | 50m |
Case study of migrating a medium e‑commerce app (four sites, ~50–70 GB DBs) to Cloud Native PostgreSQL on Kubernetes using an operator, logical replication for… | ||
| High-concurrency distributed snapshots | Ants Aasma | 51m |
Current MVCC snapshots rely on a shared-memory proc array and get_snapshot_data that becomes an N² scalability bottleneck as CPUs and concurrent transactions… | ||
| NUMA vs PostgreSQL | Andres Freund | 52m |
Shows experimental patches that add NUMA visibility, force or interleave shared memory, and change buffer replacement and locking to reduce cross-node… | ||
| A Deep Dive into Postgres Statistics | Louise Grandjonc | 52m |
Explains exactly how Postgres computes selectivity from pg_stats using most common values, histograms and null fraction, and how equal versus scalar operators… | ||
| Exploring Postgres Databases with Graphs | Dian Fay | 51m |
Argues that static ERDs fail as documentation and presents a working CLI called Pdo CLI that introspects a running Postgres and renders up-to-date graphs… | ||
| What's in a Postgres major release?... | Claire Giordano | 48m |
A data-driven audit of the Postgres v17 timeframe: 2,680 commits touching >400,000 changed lines, 232 code and doc authors and 30 committers, 220 commits land… | ||
| UNDELETE data FROM table; | Christoph Berg | 33m |
Postgres rows marked deleted remain on disk and can often be recovered by reading page images or forcing a table scan that ignores visibility. Practical… | ||
| Postgres Platform "Best Practices" for the Modern DBA | Chelsea Dole | 46m |
Ten concrete practices: own the provisioning via forms + Terraform so clusters are consistent; add measured friction to avoid hundreds of tiny DBs; run a… | ||
| Sparta’s Dual Kingship and PostgreSQL Active-Active | Boriss Mejias | 50m |
PostgreSQL 16 makes origin tracking practical so bidirectional logical replication can run, but identical primary keys and concurrent commits create duplicate… | ||
| Hidden gems of WAL-G backup tool | Andrey Borodin | 47m |
WAL-G is a CLI backup tool used at ~25,000 clusters scale with ~11 PB of data and ~10M req/sec that focuses on faster restores and low impact on live CPU/IO… | ||
| Postgres schema migrations using the expand/contract pattern | Andrew Farries | 43m |
Shows how the expand/contract pattern performs zero‑downtime Postgres migrations by keeping old and new schema live simultaneously, using pgroll to automate… | ||
| Growing the PostgreSQL Community... | Andrea Cucciniello | 01h 04m |
Organizing PostgreSQL events since 2013 shows concrete results: a revived PG Day series in Australia (2017–2019) draws 100+ attendees on launch, then pauses… | ||
| Demystifying Kubernetes for Postgres DBAs; A Guide to Operators | Adam Wright | 50m |
Shows an operator-driven Postgres workflow using CloudNativePG and standard tools like kubectl, with a live demo that boots a 3-instance cluster (1 primary + 2… | ||
| Fun with Postgres High Availability Poker | Derk van Veen, Dave Pitts | 33m |
Live demos use playing cards to model WAL, Heap and checkpoints and show that a standalone yields RPO zero but long RTO when recovering from the last… | ||
| My Journey in PostgreSQL bug fixing | Bertrand Drouvot | 47m |
Walks through three real bug stories: one found and located to the exact commit with git bisect, one that crashes an assertion tracked down with a GDB… | ||
| GSoC 2024... | Akshat Jaimini, Pavlo Golub | 31m |
PGWatch v3 adds a new RPC sync layer that makes sinks pluggable and sync-agnostic, replacing the need to hardcode many formats. A small Go receiver interface… | ||
| Discovering Postgres... | Emma Saroyan | 21m |
A personal path from first struggling with Postgres setup and docs to created Postgres challenges on DataCamp, then encountering a production migrated to… | ||
| Lightning Talks | Christoph Berg, Di Qi, Mark Wong, Neeta Goel, Enes Cakir, Jelte Fennema-Nio, Hannu Krosing, Raoul De Guchteneere, Chris Ellis, Marat Bogatyrev, Eren Basak, Claire Giordano | 56m |
A rapid sequence of practical updates and demos: BM25: 500k Quora → SQL: minutes, PL/Rust array agg: ~3s, PGX custom aggregate: ~1s showing how far Postgres… | ||
| Using PostgreSQL in real life | Hans-Jürgen Schönig | 08m |
PostgreSQL runs everywhere: city government runs 500 Postgres databases for housing, banks and embassies use Postgres for critical records, energy markets rely… | ||
| Making Postgres serverless | Heikki Linnakangas | 14m |
neon makes Postgres behave serverless by separating storage and compute, using a custom storage layer and proxy, running Postgres in VMs that it can spin up… | ||
| HELP!!1! The database is slow!! | András Váczi | 49m |
A practical, checklist-style method for emergency DB slowdowns that starts with precise questions and moves to evidence: use PG watch dashboards and… | ||
| Postgres: From Cloud to Hybrid and On Prem Again | Gabriele Bartolini | 54m |
Claims that Postgres runs in Kubernetes with only a 1% storage penalty and a 5% OLTP penalty on bare-metal were validated by benchmarks comparing VM and… | ||
| Security Attacks on PostgreSQL | Laurenz Albe | 45m |
Covers concrete attack techniques and defenses: unauthenticated DoS by spamming connections, authenticated DoS by exhausting work_mem or filling disk with temp… | ||
| What does it take to onboard an extension? | Adam Wolk, Nacho Alonso Portillo | 47m |
Explains the exact gatekeeping steps used to onboard PostgreSQL extensions to Azure: inspect makefiles and control files for file writes and privilege… | ||
| Integrating AI with Postgres... | Bilge Ince | 44m |
Postgres becomes a viable vector store once PGVector is available and EDB ships aidb, which automates document capture, preprocessing, embedding generation… | ||
| Time travel with Neon | Heikki Linnakangas | 45m |
Neon replaces local disks with a networked storage system that keeps every page version and reconstructs pages on demand from WAL-like reshuffled delta files… | ||
| The Elephant Has No Clothes | Jan Wieremjewicz | 43m |
Percona provides an open-source TDE extension for PostgreSQL that encrypts table and index storage, integrates with external KMS, supports online encryption… | ||
| Modern PostgreSQL for AI... | Di Qi, Umur Cubukcu | 53m |
Demonstrates building a retrieval-augmented chatbot over a 600-file codebase using PostgreSQL plus the open-source Lantern extension, Llama 3B for generation… | ||
| Column encryption solutions and ideas | Peter Eisentraut | 48m |
Claims that client-side column encryption gives stronger protection than TDE, demos use of proxies (commercial, e.g. Baffle), application libraries, ORMs, and… | ||
| Postgres Over the Horizon... | Peter Eisentraut | 17m |
Revisits 2013 expectations then lays out concrete anchor points: Postgres needs to scale from transactional core to meet AI and advanced analytics workloads… | ||
| PostgreSQL Executor: Executing your execution plan | Rafia Sabih | 41m |
PostgreSQL execution splits into three clear phases — preparatory, execution, cleanup — starting at exec_simple_query and building a per-query QueryDesc and… | ||
| nothing matches | ||