2.0 -//Pentabarf//Schedule//EN PUBLISH HCKQAD@@cfp.p2d2.cz -HCKQAD PostgreSQL Query Optimization: How to Write Efficient Queries en en 20260127T090000 20260127T123000 3.03000

PostgreSQL Query Optimization: How to Write Efficient Queries

Upon workshop completion, the participants will learn to: - Identify optimization goals in OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems - Read and understand PostgreSQL execution plans - Identify indexes that will improve query performance - Optimize full table scans - Distinguish between long queries and short queries - Choose the correct optimization technique for each query type - We will conclude the workshop by presenting the Ultimate Optimization Algorithm PUBLIC CONFIRMED Workshop (half-day) https://cfp.p2d2.cz/2026/talk/HCKQAD/ T9:301 Hettie Dombrovskaya PUBLISH 3TMCQN@@cfp.p2d2.cz -3TMCQN PgBouncer - Everything, Everywhere, All At Once about this tool en en 20260127T133000 20260127T170000 3.03000

PgBouncer - Everything, Everywhere, All At Once about this tool

PUBLIC CONFIRMED Workshop (half-day) https://cfp.p2d2.cz/2026/talk/3TMCQN/ T9:301 Josef Machytka PUBLISH AFFEUF@@cfp.p2d2.cz -AFFEUF Running PostgreSQL in Kubernetes with CloudNativePG en en 20260127T090000 20260127T123000 3.03000

Running PostgreSQL in Kubernetes with CloudNativePG

Following the instructions from the CNPG Playground project, anyone will create Kubernetes clusters on their own laptop using "kind". While the kind clusters will be created on each laptop, we will introduce the CNPG operator and basic concepts. We will walk the attendees to understand a bit of the Kubernetes world and the problems we are trying to solve with this PostgreSQL operator. The course will cover the following points: * Introduction to CloudNativePG (CNPG) * Installation of the kubectl plugin for CNPG * First deployment of a CNPG cluster * PostgreSQL configuration, databases, and roles management * Database import * Setup and execution of the first backup * PostgreSQL Extensions * Incident simulation (failover showcase) * Log reading * Upgrade of the Operator and the PostgreSQL version (minor, and major) * Restore from a backup. To speed up the process, we will provide a link to download all the commands to actually follow the workshop in real time, without wasting precious minutes writing them or looking for typos in case of issues. **Requirements** To run the playground environment on their own laptops, participants only need to have one of the following installed: * Docker Desktop * Rancher Desktop Either of these tools ensures that containers run consistently across all major operating systems—Windows, Linux, and macOS—without requiring any additional configuration. PUBLIC CONFIRMED Workshop (half-day) https://cfp.p2d2.cz/2026/talk/AFFEUF/ T9:302 Jonathan Danish PUBLISH MDZLK7@@cfp.p2d2.cz -MDZLK7 pgwatch: From Zero to Hero! en en 20260127T133000 20260127T170000 3.03000

pgwatch: From Zero to Hero!

In this hands-on workshop, attendees will learn how to set up and operate **pgwatch**, a powerful open-source monitoring system designed specifically for PostgreSQL. Starting from a clean environment, we will go step-by-step through deploying pgwatch, connecting monitored databases, and exploring built-in Grafana dashboards. Participants will also learn best practices for managing pgwatch efficiently in production environments—covering configuration, data retention, and performance considerations. **Key topics covered:** * Introduction to pgwatch architecture and components * Installing pgwatch from scratch (Docker or native setup) * Connecting PostgreSQL instances and collecting metrics * Understanding key metrics and visualizations in Grafana * Managing multiple clusters and optimizing data storage * Practical tips for troubleshooting and maintenance **Expected outcomes:** By the end of the session, participants will have a fully functional monitoring setup for PostgreSQL and the knowledge to adapt pgwatch to their own environments. **Prerequisites:** * Basic familiarity with PostgreSQL administration * Laptop with Docker or a PostgreSQL environment available (any OS is fine — pgwatch is cross-platform) PUBLIC CONFIRMED Workshop (half-day) https://cfp.p2d2.cz/2026/talk/MDZLK7/ T9:302 Pavlo Golub PUBLISH BRPVYB@@cfp.p2d2.cz -BRPVYB Introduction to Postgres hacking en en 20260127T090000 20260127T170000 8.00000

Introduction to Postgres hacking

The planned agenda is roughly this: * Brief introduction into the development process and how it’s organized (mailing lists, commit fests, patch submissions, buildfarm, tools used to organize all this). We might also discuss how this might evolve in the future. * Walk through the source code, to explain how it’s organized, what are the basic modules, where to look for stuff, what tools are available, etc. * Basic work with the code (cloning, using configure, running various types of tests). * Advanced stuff (using github CI, ...) * Postgres-specific infrastructure and coding idioms (Datum, SQL vs. C functions, memory contexts and palloc, error logging, ...). We plan to do small exercises to get some practical experience with these topics, so bring your Linux laptop with a recent distribution (Fedora, Ubuntu, Debian, ...). You won’t need anything very special, just console, git, gcc, and your favorite editor to write C code (we’ll setup the environment in the first section). We expect basic knowledge of C, but we don’t expect you to know the strange/unique C stuff in Postgres. That’s what the workshop is meant to address. Prior experience with autotools is an advantage, not a requirement. After the workshop you should be familiar with how the Postgres project is organized, and with the fundamental tools and infrastructure used by Postgres. You may not be able to understand every patch right away, but you should have the foundations to quickly learn. PUBLIC CONFIRMED Workshop (full-day) https://cfp.p2d2.cz/2026/talk/BRPVYB/ T9:347 Tomas Vondra Nazir Bilal Yavuz PUBLISH WQX3FA@@cfp.p2d2.cz -WQX3FA The Art of Keeping PostgreSQL Clean: Internals, Autovacuum, and Controlled Deletion en en 20260128T092000 20260128T101000 0.05000

The Art of Keeping PostgreSQL Clean: Internals, Autovacuum, and Controlled Deletion

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/WQX3FA/ 105 Cagri Biroglu PUBLISH HGLVLL@@cfp.p2d2.cz -HGLVLL SQL Injection Is Boring - Advanced Threats You’re Not Watching en en 20260128T101500 20260128T110500 0.05000

SQL Injection Is Boring - Advanced Threats You’re Not Watching

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/HGLVLL/ 105 Kranthi Kiran Burada Narendra Tawar PUBLISH GDJ7SE@@cfp.p2d2.cz -GDJ7SE Why your PostgreSQL tuning guide might be wrong (and what to do about it) en en 20260128T111000 20260128T120000 0.05000

Why your PostgreSQL tuning guide might be wrong (and what to do about it)

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/GDJ7SE/ 105 Mohsin Ejaz PUBLISH RHHJDT@@cfp.p2d2.cz -RHHJDT lightning talks cs cs 20260128T131000 20260128T141000 1.00000

lightning talks

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/RHHJDT/ 105 Pavlo Golub PUBLISH B8QJAL@@cfp.p2d2.cz -B8QJAL What you should know about constraints in PostgreSQL (and what's new in 18) en en 20260128T141500 20260128T150500 0.05000

What you should know about constraints in PostgreSQL (and what's new in 18)

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/B8QJAL/ 105 Gulcin Yildirim Jelinek PUBLISH GMZKNF@@cfp.p2d2.cz -GMZKNF Vacuuming Large Tables: How Recent Postgres Changes Further Enable Mission Critical Workloads en en 20260128T153500 20260128T162500 0.05000

Vacuuming Large Tables: How Recent Postgres Changes Further Enable Mission Critical Workloads

We have all heard about Postgres vacuum horror stories and tales of transaction wraparound disasters. Even if you've never been through one yourself, you may be concerned that you might someday experience it, or maybe you even know people who have avoided Postgres altogether due to fear of it happening to them. But it doesn't have to be this way. In this talk, we will explore this topic through a review of a real-world wraparound incident, walking through the challenges and hope offered by changes in the last several Postgres releases. We'll explore the inner workings of the Postgres vacuum process, its dual purpose of managing both disk bloat and transaction IDs (XIDs), and how recent innovations have improved this process, particularly for large tables with heavy transaction loads. We'll dive deep into key features like: - How index de-duplication minimizes vacuum workloads and improves efficiency. - How on/off index vacuuming gives you better control during maintenance windows. - Why one key autovacuum enhancement may be the key for eliminating XID wraparounds. Beyond theory, we'll revisit the real-world incident and see how each new Postgres feature could have helped mitigate the impact. While no single change is a silver bullet, the combined effect is significant. We'll also explore how the radix tree implementation in Postgres 17 might be the possible final piece of the puzzle for providing a manageable solution to XID wraparound risks. This talk equips DBAs with a deeper understanding of recent Postgres advancements and their practical application in managing high-transactional and/or mission-critical workloads. You'll leave with actionable insights to optimize your Postgres environment and concrete arguments to convince management that it is worth the upgrade for the potential to minimize the risk of XID wraparound incidents. PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/GMZKNF/ 105 Robert Treat PUBLISH KGNTVC@@cfp.p2d2.cz -KGNTVC PostgreSQL Query Performance Monitoring for the Absolute Beginner en en 20260128T163000 20260128T172000 0.05000

PostgreSQL Query Performance Monitoring for the Absolute Beginner

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/KGNTVC/ 105 Grant Fritchey PUBLISH ZFWHEY@@cfp.p2d2.cz -ZFWHEY B-Tree Index Access Paths: Tuning Today and Tomorrow” en en 20260128T092000 20260128T101000 0.05000

B-Tree Index Access Paths: Tuning Today and Tomorrow”

Whatever will fit in 45 minutes: -Index tuning introduction - fast, effective, impactful -Table without any index -B-Tree: the basic index -Why does the B-Tree index work -Index Seek -Index Scan -Index Skip Scan -Real-life issues with the Skip Scan in Oracle -How to avoid these issues in PotsgreSQL -Automated indexing - DB Booster -The future of the databases - self-tuning engines PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/ZFWHEY/ 155 Jakub Kuzela PUBLISH A3ZQRJ@@cfp.p2d2.cz -A3ZQRJ What's Missing in Postgres? en en 20260128T101500 20260128T110500 0.05000

What's Missing in Postgres?

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/A3ZQRJ/ 155 Bruce Momjian PUBLISH NFDMRG@@cfp.p2d2.cz -NFDMRG Do ORMs make you happy OR Mad? cs cs 20260128T111000 20260128T120000 0.05000

Do ORMs make you happy OR Mad?

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/NFDMRG/ 155 Petr Šmejkal PUBLISH JD8TSM@@cfp.p2d2.cz -JD8TSM Operational hazards of managing PostgreSQL DBs over 100TB en en 20260128T141500 20260128T150500 0.05000

Operational hazards of managing PostgreSQL DBs over 100TB

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/JD8TSM/ 155 Teresa Lopes PUBLISH YCZ9KL@@cfp.p2d2.cz -YCZ9KL A benchmark study on the impact of PostgreSQL server parameter tuning en en 20260128T153500 20260128T162500 0.05000

A benchmark study on the impact of PostgreSQL server parameter tuning

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/YCZ9KL/ 155 Luigi Nardi PUBLISH Z9FU8V@@cfp.p2d2.cz -Z9FU8V It works on my database - Regression testing of SQL queries en en 20260128T163000 20260128T172000 0.05000

It works on my database - Regression testing of SQL queries

Target Audience: - Application developers who work with PostgreSQL daily - Teams struggling with SQL-related production incidents - DBAs looking to improve query quality from development teams While the talk introduces RegreSQL as an open source project, it's meant to open discussion on the wider topics of improving developer experience and stability of production deployments in database applications backed by PostgreSQL. PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/Z9FU8V/ 155 Radim Marek PUBLISH 7GVFDS@@cfp.p2d2.cz -7GVFDS Rediscovering PgQ en en 20260128T092000 20260128T101000 0.05000

Rediscovering PgQ

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/7GVFDS/ 107 Alexander Kukushkin PUBLISH CKPR7B@@cfp.p2d2.cz -CKPR7B Switching Me Softly: Zero-downtime Major PostrgreSQL Upgrades at Fresha en en 20260128T101500 20260128T110500 0.05000

Switching Me Softly: Zero-downtime Major PostrgreSQL Upgrades at Fresha

This talk expands on Fresha’s Switching Me Softly framework: a production-tested zero-downtime upgrade path from PostgreSQL 12 → 17. It covers: * Logical replication with WAL origin alignment * Coordinating Debezium CDC and outbox connectors * PgBouncer two-phase switchover (read-only → write) * YAML-driven orchestration and dry-run safety modes We upgraded dozens of databases, including multi-terabyte clusters, without a second of downtime. The session focuses on real engineering trade-offs what worked, what didn’t, and how to make major PostgreSQL upgrades safe, reversible, and boring. PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/CKPR7B/ 107 Anton Borisov PUBLISH WSQKUL@@cfp.p2d2.cz -WSQKUL TimescaleDB - collecting and visualizing IOT data cs cs 20260128T111000 20260128T120000 0.05000

TimescaleDB - collecting and visualizing IOT data

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/WSQKUL/ 107 Michal Bartak PUBLISH UEBNWK@@cfp.p2d2.cz -UEBNWK Hey, I'm using that! Fixing lock contention in OLTP. en en 20260128T141500 20260128T150500 0.05000

Hey, I'm using that! Fixing lock contention in OLTP.

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/UEBNWK/ 107 Ants Aasma PUBLISH Q7EWET@@cfp.p2d2.cz -Q7EWET Cloud-native Postgres observability: from client apps to underlying cloud resources en en 20260128T153500 20260128T162500 0.05000

Cloud-native Postgres observability: from client apps to underlying cloud resources

PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/Q7EWET/ 107 Peter Zaitsev PUBLISH 9AHQ7F@@cfp.p2d2.cz -9AHQ7F Knocking at the Door: Fuzzing libpq and PgBouncer en en 20260128T163000 20260128T172000 0.05000

Knocking at the Door: Fuzzing libpq and PgBouncer

In this session you will learn: * what fuzzing is and why it finds bugs other techniques miss * which PostgreSQL surfaces make good fuzzing targets and why * how to apply fuzzing to Postgres networking components (libpq, PgBouncer) If you’re a PostgreSQL developer, this talk will add another tool for improving the stability and security of the projects you build. PUBLIC CONFIRMED Talk https://cfp.p2d2.cz/2026/talk/9AHQ7F/ 107 Adam Wolk