Conference Sessions - PGConf.EU 2024

The following list contains all the talks that have been approved so far for PGConf.EU 2024. Note that they may not yet have been scheduled! You can find the full conference information at the conference website.

Keynotes

• The PostgreSQL License Fee (Stacey Haysler)

PGConf.EU

• Lightning Talks (Andreas Scherbaum, Chris Ellis, Christoph Berg, Claire Giordano, Di Qi, Enes Cakir, Eren Başak, Floor Drees, Hannu Krosing, Jelte Fennema-Nio, Marat Bogatyrev, Mark Wong, Neeta Goel, Raoul De Guchteneere)
• PostgreSQL Europe Reception ()
• So long, and thanks for all the fish (Dave Page, Magnus Hagander)
• Welcome and Opening (Magnus Hagander)

Community

• connection_builder for PostgreSQL community (Valeria Kaplan)
• Discovering Postgres: A Journey into the #1 Open Source Relational Database (Emma Saroyan)
• Finding and fixing a data-corruption bug with the help of the community (Patrick Stählin)
• Fun with Postgres High Availability Poker (Dave Pitts, Derk van Veen)
• Growing the PostgreSQL Community: My experience organising local events in different geographies (Andrea Cucciniello)
• GSoC 2024: Enhancing Data Insights for Postgres with Remote Sinks (Akshat Jaimini, Pavlo Golub)
• Supporting a New PostgreSQL Version in Your Extension - A Citus Case Study (Naisila Puka)
• Supporting extensions, but really now (Floor Drees)
• What's in a Postgres major release? An analysis of contributions in the v17 timeframe (Claire Giordano)

DBA

• An ultimate guide to upgrading your PostgreSQL installation (Ilya Kosmodemiansky)
• Column encryption solutions and ideas (Peter Eisentraut)
• Comparing Connection Poolers for PostgreSQL (Julian Markwort)
• Demystifying Kubernetes for Postgres DBAs: A Guide to Operators (Adam Wright)
• From VMs to Cloud-Native PostgreSQL in Kubernetes: A Case Study of Migrating a Medium-Sized Application (David Pech)
• Hidden gems of WAL-G backup tool (Andrey Borodin)
• Identity at Scale - How Okta uses Postgres (Norberto Leite)
• Incremental Backup (Robert Haas)
• Introduction to Fair-Use TPC Benchmarking Kits (Mark Wong)
• Leveraging AI as a PostgreSQL DBA (Grant Fritchey)
• Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance (Ryan Booz)
• Patroni Deployment Patterns (Michael Banck)
• Postgres Platform "Best Practices" for the Modern DBA (Chelsea Dole)
• PostgreSQL for Oracle DBAs - A walk in the park? (Teresa Lopes)
• PostgreSQL Observed—and Explained (Karen Jex, Stacey Haysler)
• PostgreSQL Security: From Attack Simulation to Defense (Taras Kloba)
• Practical Memory Tuning for PostgreSQL (Grant McAlister)
• Smooth Sailing: How We Tackled PostgreSQL Migration Challenges from CentOS to Ubuntu (Sena Güngör Tavukçuoğlu)
• Speeding up logical replication setup (Euler Taveira)
• UNDELETE data FROM table; (Christoph Berg)
• Untangling the Web of PostgreSQL Permissions (Lætitia AVROT)
• Vacuuming Large Tables: How Recent Postgres Changes Further Enable Mission Critical Workloads (Robert Treat)

App Developer

• Actual trees, not b-trees – or how I found PostgreSQL through PostGIS (Johannes Paul)
• Creating a Board Game Chatbot with Postgres, AI, and RAG (Matt Cornillon)
• Exploring Postgres Databases with Graphs (Dian Fay)
• –Mom, can we have G**gle Maps? –We have G**gle Maps at home (Jimmy Angelakos)
• pg_ivm: Extensions for Rapid Materialized View Update (Yugo Nagata)
• Postgres schema migrations using the expand/contract pattern (Andrew Farries)
• Sparta’s Dual Kingship and PostgreSQL Active-Active (Boriss Mejias)
• Unearthing the Past with PostgreSQL: How Open Source is Revolutionizing Digital Archaeology (Ophir Lojkine, Thomas Guillemard)
• Using Postgres to locate the best coffee near you! (Varun Dhawan)

Internals

• A Deep Dive into Postgres Statistics (Louise Grandjonc)
• Debugging active queries with mid-flight instrumented explain plans (Rafael Thofehrn Castro)
• Dissimilarity search: implementing in-memory vector search algorithms to PostgreSQL (Jonathan S. Katz)
• Fearless Extension Development With Rust and PGRX (James Blackwood-Sewell)
• High-concurrency distributed snapshots (Ants Aasma)
• My Journey in PostgreSQL bug fixing (Bertrand Drouvot)
• NUMA vs PostgreSQL (Andres Freund)
• Performance Archaeology (Tomas Vondra)
• PostgreSQL Executor: Executing your execution plan (Rafia Sabih)
• Streaming I/O and vectored I/O (Nazir Bilal Yavuz, Thomas Munro)
• The Wire Protocol (Heikki Linnakangas)

Training

• A beginner's guide to performance (Hans-Jürgen Schönig)
• Are you collecting the right metrics? (Frederic Delacourt)
• Empowering AI Applications: Integrating Vector Databases with PostgreSQL (Bilge Ince, Boriss Mejias)
• Hands-on Introduction to PostgreSQL Operation (Ilya Kosmodemiansky)
• Logical replication - getting in and out of the cloud (Alexander Kukushkin, Silvano Coriani)
• Mastering PostgreSQL in Kubernetes with CloudNativePG (Gabriele Bartolini, Leonardo Cecchi)

Sponsors

• Advantages of globally distributed PostgreSQL in a managed cloud for ultra-high availability, disaster tolerance and greater security (David Mitchell)
• Automated Database Change Management with Flyway and CI/CD Pipelines (Ryan Booz)
• Crunchy Postgres for Kubernetes: Your Virtual DBA (Karen Jex)
• Get started with Tembo AI: build GenAI apps on Postgres (Adam Hendel)
• HELP!!1! The database is slow!! (András Váczi)
• Integrating AI with Postgres: Opportunities, Challenges, and Future Possibilities (Bilge Ince)
• Modern PostgreSQL for AI applications: with LLM integrations and powerful search (Di Qi, Umur Cubukcu)
• Porting on-prem performance troubleshooting skills to the cloud (Denzil Ribeiro)
• Postgres: From Cloud to Hybrid and On-Prem Again (Gabriele Bartolini)
• Security attacks on PostgreSQL (Laurenz Albe)
• The Elephant Has No Clothes (Jan Wieremjewicz)
• Time travel with Neon (Heikki Linnakangas)
• Transitioning to PostgreSQL: A Flexible Pathway for Compatibility (Cédric Villemain & Andrea Cucciniello)
• What does it take to onboard an extension? (Adam Wolk & Nacho Alonso Portillo)

Platinum Sponsor Keynotes

• Everything Postgres at Microsoft – 2024 in Review (Charles Feddersen)
• Making Postgres serverless (Heikki Linnakangas)
• Postgres Over the Horizon: Anchor Points for the Future We Should Be Building Now (Peter Eisentraut)
• Using PostgreSQL in real life (Hans-Jürgen Schönig)