PostgreSQL Conference Europe 2025
2025-10-21..2025-10-24
Riga, Latvia
[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 a day of community activities and events in Riga, Latvia.
| title | author | length |
|---|---|---|
| The Foundation of Open Source: Why Software Freedom? | Karen M. Sandler | 54m |
Medical implants and infrastructure run on proprietary code that users cannot audit, modify or repair, and one defibrillator repeatedly shocks a pregnant… | ||
| Don't do that! | Laurenz Albe | 46m |
Covers concrete Postgres mistakes and fixes: storing timestamps as strings instead of timestamp wastes space and breaks timezone math, using integer primary… | ||
| From Stars to Storage Engines: Migrating Big Science Workloads Beyond Greenplum | Joaquim Oliveira | 35m |
Archives hold about 1 PB of files and ~400 TB of databases and Gaia DR3 supplies ~2 billion rows used to test scale‑out options. Greenplum worked for MPP and… | ||
| From Transactions to Intelligence: Postgres for Open AI & Analyti | Torsten Steinbach | 50m |
Three concrete pathways: WarehousePG MPP forks Greenplum into a scale‑out Postgres that reaches petabyte class with built‑in ML and external table federation… | ||
| Behind Postgres 18: The People, the Code, & the Invisible Work | Claire Giordano | 51m |
Analysis uses Echoda plus commit logs, mailing lists, conference schedules and packaging metadata over a 15-month window to count contributions: ~3,043… | ||
| Anonymizing Data in Postgres Without Losing Your Mind (or Your | Ahmet Gedemenli, Esther Miñano Sanz | 32m |
Shows concrete options and tradeoffs: an in-DB extension that does dynamic masking and anonymized dumps but no replication, a CLI dumper that applies YAML… | ||
| Data modeling with PostgreSQL at the core of Software Development | Boriss Mejias | 25m |
Builds a working chess-tournament schema in PostgreSQL that enforces rules in the database so less app code is needed: a chess.players table with surrogate… | ||
| Boosting Typical Query Patterns: PostgreSQL 18's Performance Enhancements | Roberto Mello | 52m |
PostgreSQL 18 introduces concrete, measurable gains: async IO workers default 3 and allow batching multiple page reads so sequential scans improve ~15–25% and… | ||
| Vector data in Postgres: Size, TOAST, Filters and Performance | Gleb Otochkin | 51m |
Vectors store as arrays of single-precision floats (float4 storage) and common embeddings run 500–1,500 dimensions; anything over ~2 KB goes to Postgres TOAST… | ||
| Improved Freezing in Postgres Vacuum: From Idea to Commit | Melanie Plageman | 47m |
Postgres 18 adds eager scanning: instead of complex LSN histograms and interval models the implementation scans a bounded number of all-visible but not… | ||
| What we built with Open Source | Hans-Jürgen Schönig | 38m |
Shows concrete systems and numbers: a Postgres stack that encrypts data files, WAL and backups with key‑manager integration and a replication proxy for… | ||
| Practical Guide to Migrating +100 Large PostgreSQL to the Cloud | Nelson Calero | 49m |
Migrates more than 100 production PostgreSQL databases (≈250 including dev/prod copies) from VMs to Google Cloud SQL using pglogical and automated Bash+YAML… | ||
| Barman, past, present, and future of a pioneer community project | Giulio Calacoci, Martín Marqués | 50m |
Project history from a July 2012 release to 13 years of development shows concrete outcomes: quarterly releases early on, a team that grows from three to about… | ||
| Unlock PostgreSQL’s True Performance with Local SSDs | Burak Yucesoy | 46m |
Claims that local NVMe SSDs beat remote storage by large margins with concrete benchmarks: PGbench/TPCB shows ~6x faster throughput, TPCC reports 8.5x and… | ||
| What You Should Know About Constraints in PostgreSQL (and What’s New in 18 | Gülçin Yıldırım Jelínek | 43m |
PostgreSQL 18 makes NOT NULL a first‑class, named NOT NULL constraint stored in pg_constraint, adds NOT ENFORCED flags for CHECK and foreign keys so… | ||
| DataGrip: A Powerful IDE for PostgreSQL | Maxim Sobolevskiy | 49m |
DataGrip is a database IDE that is free for non-commercial use, connects to all major engines and uses a built-in syntax parser plus introspection levels 1–3… | ||
| Hacking pgvector for performance | Daniel Krefl | 47m |
Modified pgvector keeps the vector index in persistent external memory via a background worker and replaces Postgres page/tuple handling with plain arrays… | ||
| All in a context! | Rafia Sabih | 31m |
PostgreSQL routes every malloc into hierarchical memory contexts so code never calls free directly, using allocation sets of 8 KB that double on growth and a… | ||
| Exploring new enhancements and improvements Fujitsu has delivered to | Vincent O'Dea | 51m |
Fujitsu details concrete PostgreSQL contributions: new conflict logging and seven conflict types (plus a proposed update_deleted conflict with dead-tuple… | ||
| Have you ever wondered, how a cloud platform works? | Maximilian Stefanac, Philipp Thun | 49m |
Cloud Foundry runs production metadata on six PostgreSQL databases with the cloud controller DB dominating latency; a CI API performance suite plus production… | ||
| Unified Observability: Monitoring Postgres Anywhere with OpenTelemetry | Yogesh Jain | 49m |
Shows a working pipeline that collects Postgres metrics and logs from Kubernetes, bare metal and managed services using open telemetry collector with receivers… | ||
| DBtune: AI-driven performance tuning for all PostgreSQL flavors | Dr. Luigi Nardi | 48m |
DBtune v3 autotelic agent installs in ~10–15 minutes and requires pg_stat_statements required to collect queries and metrics; it edits only postgresql.conf… | ||
| EXPLAIN: make it make sense | Aivars Kalvāns | 32m |
Shows how EXPLAIN and ANALYZE with PostgreSQL reveal actual vs estimated rows, uses Python/Django and RDS, and proves random_page_cost=4 keeps the planner… | ||
| Kubernetes from the Database Out | Alastair Turner | 26m |
Practical checklist for running Postgres on Kubernetes: demos run on GKE and Picona Everest, networking exposes services as ClusterIP/NodePort/LoadBalancer… | ||
| Discover your contribution-magic | Cornelia Biacsics | 25m |
Shows practical, non‑technical paths into PostgreSQL with concrete community data—279 people contributed code to PostgreSQL 18, 2,300 in the social Telegram… | ||
| PostgreSQL Tips & Tricks For App Devs | Chris Ellis | 42m |
Practical recipes for making PostgreSQL replace extra services: TSVector + GIN index turns a prototype full‑text scan from ~25 ms into ~200 µs for ranked… | ||
| Flavors of PostgreSQL® and you: how to choose a Postgres | Celeste Horgan | 43m |
Compares concrete systems: Google AlloyDB Omni claims 100% Postgres SQL compatibility but adds a proprietary vector engine and a columnar store plus an AI/ML… | ||
| Implementing Slowly Changing Dimensions in Postgres | Marc Linster | 22m |
Reviews six SCD patterns and argues type six is the most practical, then shows a working Postgres design that stores validity as a daterange, uses the… | ||
| TDE as an Extension: A Different Path for PostgreSQL Encryption | Zsolt Parragi | 45m |
An extension-first implementation builds several prototypes: an initial access-method prototype that encrypts tuples per-connection works for simple queries… | ||
| Implementing strong cross-platform resiliency in agile environments with logical r | Andreas Geppert | 33m |
Requirement enforces RPO 15 minutes for ~60 critical apps so physical replication outside the cloud is impossible, backups and WAL access are blocked. Solution… | ||
| Beyond the How: Why Table Partitioning Truly Matters | Derk van Veen | 50m |
Range based partitioning is presented as the only reliable approach: start partitioning around a single leading figure (transaction, policy, car) and align… | ||
| They grow up so fast: donating your open source project to a found | Floor Drees, Gabriele Bartolini | 29m |
First commit Feb 2020, open sourced under Apache license in Apr 2022 and donated to CNCF to ensure vendor‑neutral stewardship; project becomes a CNCF Sandbox… | ||
| Migrating to PostgreSQL: Strategies, Sovereignty, and Success | Raphael Salguero | 48m |
Argues migrations to PostgreSQL are practical but require a disciplined assessment, change management and a phased plan: run a scoped DDL audit to score… | ||
| AIO in PG 18 and beyond | Andres Freund | 49m |
PostgreSQL 18 adds AIO for reads only via a readstreams layer that currently uses either worker mode (process-based workers) or Linux io_uring; buffered reads… | ||
| MultiXacts in PostgreSQL: usage, side effects, and monitoring | Divya Sharma | 45m |
PostgreSQL creates MultiXacts when multiple transactions lock the same row and stores them in pg_multixact (offsets + members) on disk and SLRU cache; they are… | ||
| Pushing Postgres Forward: From Open Source Contributions to Intelligent T | Adam Wolk | 42m |
Microsoft reports 540 commit attributions in PG18 out of 3,320 total, reviews by Microsoft account for 18% (~1,000 of 5,000) of reviews, and PG18 async IO cuts… | ||
| Diofanti.org: A Civic Tech Journey Powered by PostgreSQL | Florents Tselai | 19m |
Diofanti.org ingests government publication feeds into PostgreSQL, parsing PDFs into JSONB and full‑text columns, indexing millions of records (the government… | ||
| All about Common Vulnerabilities and exposures in PostgreSQL | Priyanka Chatterjee | 23m |
Explains how CVE records look (CVE ID, description with problem type/affected component/cause/impact, one public reference) and how Postgres CVEs are published… | ||
| Don't leak user data to AI - Strategies for protecting PII from LLMs and MCP | Jay Miller | 28m |
Live demo shows an LLM using MCP (Model Context Protocol) listing schema objects, pulling a customer row and leaking PII into Claude servers; removing table… | ||
| Postgres on AWS: Run 5X faster on metal, migrate anywhere | Ozgun Erdogan | 10m |
Claims open-source managed Postgres running on EC2 with local NVMe delivers 3–6x throughput vs Aurora/RDS in TPCC/TPCH benchmarks, cutting cost to about… | ||
| Why PostgreSQL took the crown from MySQL and what lies ahead | Peter Zaitsev | 16m |
Claims that PostgreSQL overtook MySQL by combining extensibility and permissive licensing, wide adoption by managed clouds (Heroku, Amazon RDS) and embedding… | ||
| Transform your development workflow with thin cloning | Nicholas Meyer | 46m |
Thin cloning reproduces production data and schema so developers get writable copies that behave like prod for debugging and performance work it uses… | ||
| PostgreSQL in ever more critical environments | Hans-Jürgen Schönig | 07m |
Postgres powers banks, insurers, crypto and government sites and a 2017 telecom deployment exposes scalability limits that trigger a decade of work. The… | ||
| PostgreSQL as a Graph Database: Who Grabbed a Beer Together? | Taras Kloba | 46m |
Shows how PostgreSQL plus the Apache AGE extension runs graph queries via openCypher, ingesting Untappd check‑ins and PGConf speaker accounts to build nodes… | ||
| Lessons from two decades of hacking the proprietary value into open so | Michal Nosek | 54m |
Twenty years of vendor work yields concrete moves: Percona ships Postgres distributions, PGMonitor, backups and PGTDE (Transparent Data Encryption) to meet… | ||
| An Introduction to B-trees and LSM-trees for DEVs and DevOps | Dave Pitts | 39m |
Benchmarks use PGbench comparisons between vanilla Postgres and Postgres-compatible LSM engines (PG Rocks, Cockroach, Yugabyte) at scale factors up to millions… | ||
| Fast-path locking improvements in PG18 | Tomáš Vondra | 32m |
PG18 expands fast-path locking capacity (default 16 → 64 entries, tunable via max_locks_per_transaction) and implements a small set-associative small buffers… | ||
| Waiting for Commit | Ants Aasma | 25m |
Explains why synchronus replication can turn millisecond tail latencies into system-wide pauses via head-of-line blocking, gives measured timings (bare-metal… | ||
| Patroni: what the blog posts don't tell you... | Cameron Murdoch | 49m |
Shows concrete hardening and operations details: how to enable TLS and RBAC on etcd and protect Patroni’s REST API, why etcd needs odd quorum sizes (3 or 5)… | ||
| The Good, The Bad, and The Bloated: An Autovacuum Story | Jérémie Grauer | 48m |
A production cluster becomes unusable when 3 autovacuum workers vs 1,500 tables lets large tables hog all workers, causing runaway bloat and a midnight… | ||
| Building Tetris in a SQL Query! | Nuno Faria | 27m |
A fully working Tetris is implemented as a single PostgreSQL query using recursive CTEs for the game loop, one-dimensional boolean arrays for the board, and… | ||
| Panel Discussion: How to Work with Other Po | Boriss Mejias, Floor Drees, Jimmy Angelakos, Karen Jex | 46m |
Panelists give concrete practices for neurodiversity in PostgreSQL communities: use sunflower lanyard badges at conferences, publish personal README pages… | ||
| Tracking plan shapes over time with Plan IDs and the new pg_stat_plans | Lukas Fittl | 29m |
pg_stat_plans extension builds low‑overhead plan tracking by assigning a 64‑bit plan ID via a planner tree walk and copied jumbling logic rather than hashing… | ||
| How to explain PostgreSQL to kids | Naisila Puka | 31m |
Explains PostgreSQL as a magical toy box that stores toys into tables (toys and play_sessions), uses JSON for a “tiny scratch” field, and shows a sample SELECT… | ||
| We have multiple concurrent versions of this title trying to understand MVCC | Boriss Mejias | 50m |
Explains that every PostgreSQL row carries version metadata so visibility depends on xmin/xmax visibility plus the transaction status, shows how updates create… | ||
| Can PostgreSQL Compete with Analytics Specialists? | Lætitia Avrot | 49m |
Argues PostgreSQL can handle most analytics if tuned, claiming 95% of cases PostgreSQL is good enough while admitting a real 5% need purpose-built engines… | ||
| CTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQL | Sakshi Nasha | 48m |
What if you could hit CTRL+Z when your production database crashes, someone drops a critical table, or a cloud region outage takes your system offline?… | ||
| Database in Distress: Testing and Repairing Different Types of Database Corruption | Josef Machytka | 51m |
Shows a Python corruption simulator that surgically creates damaged pages and prints diagnostics with pageinspect outputs, demonstrating when reads produce… | ||
| nothing matches | ||