Conference Sessions - PGConf.EU 2022

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

General

• Building a Cross-Entreprise Workgroup to promote PostgreSQL (Anthony Nowocien, Damien Clochard, Flavio Henrique Araque Gurgel)
• Documentation : Let’s make it better, now, together! (Sarah Haïm-Lubczanski)
• Efficient Graph Analysis with SQL/PGQ (Peter Boncz)
• GSoC 2022 - Overview (Ilaria Battiston, Stephen Frost)
• How to make your Postgres blog posts reach a ton more people (Claire Giordano)
• Postgres community panel: Upgradability (Andreas Scherbaum, Jimmy Angelakos, Karen Jex, Nikolay Samokhvalov)
• PostgreSQL 15 and beyond (Amit Kapila)
• PostgreSQL Native Packaging (Christoph Berg, Devrim Gündüz)
• Practical transactions theory for PostgreSQL users (Ilya Kosmodemiansky)
• The pg_catalog was always there, use it! (Boriss Mejias)
• Unlocking Open Data using an Open Source Database (Karen Jex)

PGConf.EU

• Lightning Talks (Harald Armin Massa)
• So long, and thanks for all the fish (Dave Page, Magnus Hagander)
• Welcome and Opening (Magnus Hagander, Vik Fearing)

DBA

• A comparison of PostgreSQL backup tools (Matt Pearson)
• Adaptive PgBouncer autoscaling with Karpenter (Jonathan S. Katz)
• Administering large scale PostgreSQL installations (Jan Birk)
• Building a perf-like tool for PostgreSQL (Ronan Dunklau)
• Database branching to scale and speed up application development and performance optimization (Nikolay Samokhvalov)
• Exploring Linux Memory Usage and IO Performance for PostgreSQL (Frits Hoogland)
• Full Page Writes in PostgreSQL - Critical, Evil or Both - Why you should care and how to optimize (Grant McAlister)
• Hero + Hero = Superhero? (Julia Gugel)
• How do you put an elephant in a container in 3 steps? (Lætitia AVROT)
• How to handle 1000 application users (Laurenz Albe)
• Implementing failover of logical replication slots in Patroni (Alexander Kukushkin)
• MVCC Unmasked (Bruce Momjian)
• Party tricks for PostgreSQL: perf, ftrace and bpftrace (Dmitry Dolgov)
• Performance tips you have never seen before (Hans-Jürgen Schönig)
• PostgreSQL at GitLab.com (Alexander Sosna, Jose Finotto)
• Table Partitioning - Transparent but No Magic (Boriss Mejias)
• Understanding Postgres HOT Updates plus using Prometheus and Grafana to track and tune issues (Dave Pitts, Derk van Veen)

Developer

• Breaking the sound barrier - Applications at light speed (Henrietta Dombrovskaya, Jan Karremans)
• BRIN improvements and new opclasses (Tomas Vondra)
• Changelog vs Two-dimensional time - what works better? (Henrietta Dombrovskaya)
• Collations in PostgreSQL: The good, the bad and the ugly. (Tobias Bussmann)
• Everything You Wanted to Know About Databases as a Developer but Were Too Afraid to Ask Your DBA (Karen Jex)
• Google AlloyDB vs. Amazon Aurora vs. Azure Hyperscale: comparison of databases build for clouds (Taras Kloba)
• Inside the machine room of a world map: PostgreSQL and OpenStreetMap (Sarah Hoffmann)
• Migration validation made easy with Ora2Pg (Gilles Darold)
• No Array of Sunshine: an Introduction to Data Types from a Data Quality Perspective (Renee Phillips)
• reasonable availability (Harald Armin Massa)
• The curious case of the point of sales, and why we still need pglogical (Jaime Casanova)
• TOAST, for breakfast and compression (Daniel Westermann)
• Understanding the impact of Materialized CTEs (Divya Sharma)
• What happens when stack overflow doesn’t have an answer? comparing ST_within & H3 for spatial queries (Kshitij Purwar)

Internals

• Cloud friendly COPY (Hannu Krosing)
• Directing PostgreSQL to Performance: PostgreSQL Index improvements over time (Matthias van de Meent)
• How PostgreSQL Resists Automated Management (And How To Fix This) (Robert Haas)
• Moving pg_basebackup Forward (Robert Haas)
• Neon, cloud-native storage backend for PostgreSQL (Heikki Linnakangas)
• On the Road to TDE (Stephen Frost)
• Solving PostgreSQL wicked problems (Mehboob Alam)
• Takeaways from the First 6 Months of Hacking on Postgres (Melih Mutlu)
• The Future of Observability in Postgres (Gregory Stark)
• Trigger: How it Works in PostgreSQL Internals (Yugo Nagata)

Training

• Hands-on Benchmarking (Julien Tachoires, Mark Wong)
• Introducing Advanced SQL (Hans-Jürgen Schönig)
• PostgreSQL DBA Essentials (Daniel Westermann)
• PostgreSQL on Linux, up and running (Ilya Kosmodemiansky)
• Troubleshooting Postgres (Lætitia AVROT)

Sponsors

• CYPEX: Building applications for PostgreSQL quickly (Hans-Jürgen Schönig)
• DataGrip: PostgreSQL IDE from JetBrains (Maxim Sobolevsky)
• Distributed Postgres: How to build a multi-tenant SaaS app with Citus (Charles Feddersen)
• EDB Postgres Distributed - Evolution of Replication and High Availability (Stacy Scoggins)
• Enterprise backups of PostgreSQL with pgBackRest (Stephen Frost)
• plProfiler: where is my PL/pgSQL code spending time? (Jan Wieck)
• PostgreSQL migration made easy (Patrick Thomschitz)
• Pragmatic (non)native partitioning for developers on Postgres (Antoine Daignan)
• Privacy By Design with PostgreSQL Anonymizer (Damien Clochard)
• Put PostgreSQL at the center of your (meta)data universe! (Francesco Tisiot)
• Streamlining Database Provisioning with DevOps (Doug Ortiz)
• Timescale Cloud: Scale further, build faster, and stay under budget (Kirk Roybal)
• Time-series, PostgreSQL, and You (Chris Engelbert)
• Why we built Neon (Nikita Shamgunov)
• YaK - The Next-Gen Multi-Platform PostgreSQL Database Managed Services (Hervé Schweitzer)

Platinum Sponsor Keynotes

• Accelerating Postgres’ success in the modern enterprise (Marc Linster)
• Making full use of the PostgreSQL ecosystem (Hans-Jürgen Schönig)
• Postgres Trivia with Crunchy Data (Stephen Frost)
• Top Takeaways from the 2022 State of PostgreSQL Survey (Chris Engelbert)