PostgreSQL Conference Europe 2023
2023-12-12..2023-12-15
Prague, Czechia
[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 Prague, Czechia.
| title | author | length |
|---|---|---|
| The Next 20 Years | Simon Riggs | 47m |
Postgres is already the Stack Overflow top database and the plan is to push from broad popularity toward pervasiveness by addressing specific gaps: about… | ||
| So you want a PGDay in your city | Henrietta Dombrovskaya, Teresa Giacomini | 45m |
Organizing a PGDay requires an advocate from PGUS to get approval, a secured budget (expect weeks of back-and-forth), and about six months minimum of elapsed… | ||
| Learning advanced SQL the weird (and hard) way | Lætitia Avrot | 47m |
Claims to solve Advent of Code puzzles using only Postgres SQL and succeeds on many days, beating a Java attempt by one home competitor. Uses Postgres 17 with… | ||
| Understanding and Fixing Autovacuum | Robert Haas | 49m |
Explains why autovacuum misjudges work and lists concrete diagnostics and fixes: check OS tools (top/ps), inspect wait_event in pg_stat_activity and phase in… | ||
| Should I use JSON in PostgreSQL? | Boriss Mejias | 49m |
Conclusion: PostgreSQL works well with JSON when design splits stable columns (id, foreign keys) from dynamic fields stored as JSONB; the demo builds bands… | ||
| PostGIS and pgRouting: Extensions for spatial data in PostgreSQL | Marion Baumgartner | 47m |
PostGIS provides geometry types, spatial indexes and functions like ST_Simplify for reducing polygon complexity; pgRouting adds SQL routing functions (pgr_)… | ||
| Vectors are the new JSON | Jonathan S. Katz | 48m |
PostgreSQL already stores vectors via the pgvector extension, adding a vector type plus IVF‑flat and HNSW indexes; common embeddings are 1,536‑dim (~6 KB each)… | ||
| The journey towards active-active replication in PostgreSQL | Jonathan S. Katz | 44m |
PostgreSQL moves from single-primary setups toward multi-primary capability by extending logical replication: Postgres 16 adds bidirectional replication via… | ||
| Blazingly Fast Message Queue on Postgres with Rust | Adam Hendel | 43m |
An open source Postgres extension called PGMQ implements a SQL API and Rust client via PGX, stores messages as JSONB with optional archive tables, and… | ||
| Postgres vs. Linux filesystems | Tomáš Vondra | 50m |
Benchmarks run on 6.3 kernels with pgbench and pg_dump against NVMe and SATA SSDs on a two‑socket 32‑core box, scale factors 100/500/2000 (IO‑bound at the… | ||
| Counting things at the speed of light with roaring bitmaps | Ants Aasma | 49m |
Counts faceting for a 100 million row table runs using pg_roaringbitmap bitmaps and PostgreSQL SQL, producing a 200 MB facets table of posting lists (some ~12… | ||
| Use Ansible to herd your Elephants! | Julian Markwort | 48m |
Ansible uses SSH and Python plus psycopg2 on targets to install and configure PostgreSQL clusters, with inventories, playbooks and Jinja templates to initdb… | ||
| The SQL standard: Where does it come from? Where does it go? | Peter Eisentraut | 49m |
Explains how ISO JTC1 SC32 WG3 actually makes SQL changes by publishing papers, resolving CD/DIS/FDIS ballots and having editors commit the text; meetings run… | ||
| What can't pgBackRest do for you? | Stefan Fercot | 49m |
pgBackRest demonstrates a working asynchronous archiving pipeline that uses multiple processes and a local spool status file to ship WAL segments ahead of… | ||
| Professional PostgreSQL monitoring made easy | Pavlo Golub | 49m |
A ready-to-run Go binary collects SQL-defined Postgres metrics with one-minute setup, noninvasive queries (no superuser objects required) and autodiscovery for… | ||
| How I found my Pokémon cards thanks to Postgres: an AI journey | Matt Cornillon | 48m |
A complete pipeline identifies and finds specific Pokémon cards by combining object detection, embedding generation and vector search: images are labeled with… | ||
| Postgres 16 highlight: Logical decoding on standby | Bertrand Drouvot | 38m |
Postgres 16 implements logical decoding on standby by moving decoding off the primary, adding code to detect catalog vs non‑catalog WAL conflicts, passing… | ||
| Beginner's Guide to Partitioning vs. Sharding in Postgres | Claire Giordano | 40m |
Explains when native Postgres partitioning versus sharding with the Citus extension actually speeds queries: partitioning gives partition pruning and data… | ||
| Explaining the PG concurrency control mechanisms using rollercoasters | Derk van Veen | 50m |
Visual, timestamp-based walkthrough of PostgreSQL MVCC using rollercoaster metaphors that maps inserts, updates (as insert+delete) and deletes onto page-level… | ||
| It's Not You, It's Me: Breaking Up with Massive Tables via Partitioning | Chelsea Dole | 45m |
Shows four concrete migration recipes: a full offline duplicate-and-rename, an online duplicate with triggers and backfill, a single-host view+trigger trick… | ||
| A journey into postgresql logical replication | José Neves | 38m |
Built an in-house CDC pipeline using Postgres logical replication and a Golang logical replication client, the team finds that two wrong assumptions cause… | ||
| Don't Do High Availability, Do Right Availability | Greg Vernon | 42m |
Argues that full high availability often adds cost and complexity and instead matches design to the SLA: examples include replacing a three-node cluster with a… | ||
| Advanced Authentication and Encrypted Connections | Stephen Frost | 48m |
Covers concrete setups: Kerberos/GSSAPI (ktpass/keytab on AD, kadmin/ktadd on MIT KDC), TLS client certificates with OpenSSL root/intermediate/server/client… | ||
| How to corrupt your database (and how to deal with data corruption) | Laurenz Albe | 42m |
Turning off fsync=off yields a measured 2.5x speedup but an OS crash can “toast” the cluster; enabling synchronous_commit instead gives safer performance… | ||
| PostgreSQL Distributed: Architectures & Best practices | Marco Slot | 42m |
Compares concrete PostgreSQL deployments and their tradeoffs: cloud block storage (EBS) raises disk latency ~10x and drops IOPS from ~1,000,000 NVMe to… | ||
| Elephant in a nutshell - Navigating the Postgres community 101 | Valeria Kaplan | 33m |
Overview of community structure, practical entry points and concrete processes: boards and committees (funds, code‑of‑conduct, user‑group committee), user… | ||
| Making pgweb rock-solid: Using the Testing Harness to ensure the quality of pgweb | Akshat Jaimini | 26m |
An automated testing harness for the Official PostgreSQL website runs in a separate repo under GitHub Actions and monitors pgweb commits every six hours… | ||
| SQLPage — Building a full web application with nothing but Postgres and SQL queries | Ophir Lojkine | 49m |
An open-source Rust single-binary server turns plain .sql files into server-rendered pages: one SQL file per page, components rendered by column names, and… | ||
| PostgreSQL Replication: 20 Pitfalls and Solutions | Julian Markwort | 48m |
Covers 20 concrete replication failures and fixes for PostgreSQL binary and logical replication, with examples: lost WAL due to WAL recycling, out‑of‑disk from… | ||
| Performance tricks you have never seen before 2.0 | Hans-Jürgen Schönig | 45m |
Loading heavy language extensions costs measurable time: PL/R first call ~220 ms, PostGIS ~10 ms, and preloading via session_preload_libraries turns that… | ||
| Trying to be Barbie in Ken's Mojo Dojo Casa House | Karen Jex, Lætitia Avrot | 43m |
Women occupy roughly 20% of tech roles in Europe and within PostgreSQL only 4 of 96 contributors and 2 of 41 major contributors are women while the core team… | ||
| How we execute PG major upgrades at GitLab, with zero downtime. | Alexander Sosna | 49m |
Zero downtime means no customer-facing outages while major Postgres upgrades still complete; GitLab moves a physical snapshot to a target cluster, runs… | ||
| Charting My Path: Journey of a GSoC 2023 Contributor to PostgreSQL with pg_statviz | Rajiv Harlalka | 30m |
pg_statviz is a minimalist Postgres extension plus Python CLI that snapshots Postgres internal views (24 cumulative views) into timestamped rows, generates PNG… | ||
| pg_failover_slots: The missing piece | Peter Eisentraut | 43m |
pg_failover_slots is an open source plugin released this year that synchronizes logical replication slots across physical failover by running as a background… | ||
| Tuning PostgreSQL to work even better | Karen Jex | 33m |
Covers the 13 practical Postgres knobs to change and how to inspect them with pg_settings and SHOW, including shared_buffers (suggest 25–40% of RAM), work_mem… | ||
| The path to using AIO in postgres | Andres Freund | 48m |
Work toward using asynchronous IO and direct IO in Postgres is already in code: 3x speedup for concurrent COPY in 16, a new streaming read interface for easy… | ||
| Getting the most out of pg_stat_io | Daniel Westermann | 30m |
PostgreSQL 16 adds pg_stat_io and it exposes concrete I/O counters: extends, evictions, hits, fsyncs, read/write counts and timings, but track_io_timing is off… | ||
| Add geocoordinates to your addresses in PostgreSQL | Andreas Scherbaum | 33m |
Builds Python functions inside PostgreSQL that call OpenStreetMap nominatim and Overpass to resolve addresses extracted from OSM and the German foreign office… | ||
| Tame the growth of your database | Adam Wolk | 50m |
Explains PostgreSQL’s MVCC copy‑on‑write, how HOT updates avoid index write amplification, and how easy app patterns undo that. Uses pageinspect and… | ||
| Multi-threaded PostgreSQL? | Heikki Linnakangas | 46m |
A pgsql-hackers thread launched in June proposing a full switch from a 1990s multiprocess model to threads; no production patch exists yet, only a preliminary… | ||
| Building for the Future and Betting Big on Postgres | Kevin Dallas | 15m |
Postgres claims concrete momentum: 46% say it is most popular, 70% most admired, 42% most desired, and EDB reports 1,500 customers plus seven committers and… | ||
| Linux IO internals for PostgreSQL administrators in 2023 | Ilya Kosmodemiansky | 41m |
Postgres moves pages from disk into the Linux page cache and then copies them into shared buffers, so writes mark whole pages dirty and checkpoint spikes are… | ||
| Making your patch more committable | Melanie Plageman | 49m |
Shows why a 260k one‑commit patch stalls and how to fix it: break the work into independently useful subprojects, split into small commits that make each… | ||
| Leveraging pgBadger for Effective PostgreSQL Troubleshooting | Alicja Kucharczyk | 49m |
pgBadger parses PostgreSQL text logs into a single HTML report that lists counts of ANALYZE/VACUUM, tables affected and rows/pages removed, distribution and… | ||
| PostgreSQL hacker tips | Michael Paquier | 50m |
Collection of shell-driven tricks and reproducible setups: a home dotfiles repo plus scripts like PG_compile to build many branches and PG_check to run full… | ||
| nothing matches | ||