Event schedule
Day 01
WED 15th
–Venue
Palacio de Congresos de Ibiza
Registration
Opening
Keynote - Data Bene
Catherine Bouxin · Reduce energy usage: contributing towards a greener future while directly improving cost and performance
"Going green" as a company is commonly associated with unnecessary and high costs, causing many to overlook any accompanying benefits. In this talk, we'll cover steps you can take to both contribute towards a greener future, AND see an immediate return in cost savings & performance improvements.
Iceberg Ahead! PostgreSQL Sailing Confidently in Data Lakehouse Waters
Josef Machytka
Explore Apache Iceberg’s internals and its integration with PostgreSQL. Learn which extensions and tools enable PostgreSQL to thrive in Data Lakehouse architectures, with a brief glimpse into governance, security and privacy compliance, data quality, and AI use cases.
Vacuuming Large Tables: How Recent Postgres Changes Further Enable Mission Critical Workloads
Robert Treat
Turn disaster into opportunity! Learn from a real-world Postgres vacuum failure and discover how to prevent transaction wraparound catastrophes. Walk away with a deeper understanding of Postgres' inner workings and gain actionable insights to optimize your database and justify that next upgrade!
Break
PostgreSQL at the Square Kilometre Array Observatory
Mauricio Zambrano
Managing the SKAO's massive data stream is a cosmic challenge. We'll explore how we harness PostgreSQL on kubernetes, with its powerful extensions and robust scaling, to process, store, and analyze the next generation of astronomical data, from correlator dumps to archived observations.
Postgres à la carte: dynamic container images with your choice of extensions
Álvaro Hernández
You want to use Postgres on containers (you should anyway!). And you want some extensions. But you don't want 200 extensions on your container image, with potentially security vulnerabilities from code you won't use.
How to have custom container images without having to create and maintain them?
Beach Break
Lunch
Document Workloads: PostgreSQL with JSONB, and MongoDB
Franck Pachot
PostgreSQL’s JSONB and MongoDB’s BSON both store JSON, but with very different designs. We’ll compare their strengths for document workloads across key aspects, highlighting where one excels and what the other could learn and improve.
Streaming Outbox Events from Postgres to Kafka with Debezium
Andrei Sukharev
The Transactional Outbox pattern is the common way to ensure events stay consistent between PostgreSQL and Kafka. In this talk, I’ll show how we implemented it with Debezium, turning WAL changes into reliable, low-latency Kafka events without custom polling jobs.
Break
Beyond Storage: Postgres as a Control Plane
Sweta Vooda
Postgres can act as a control plane, offloading compute to engines like Elasticsearch (ZomboDB) and TorchServe (PGML) while preserving SQL and ACID. This talk shares patterns, pitfalls, and checklists from building extensions that let Postgres orchestrate external compute engines.
Day 02
THU 16th
–Venue
Palacio de Congresos de Ibiza
Registration
Keynote - AWS
Robert Treat - PostgreSQL at Amazon
Explore Amazon’s PostgreSQL journey from an early mass migration off Oracle to how PostgreSQL is used today including services like Aurora and DSQL. We’ll also touch on recent contributions and how AWS is supporting the community to address current industry challenges.
Keynote - OnGres
Álvaro Hernández - Which Postgres are you running?
You run Postgres in production. And one of the reasons is that it’s Open Source. So you can inspect the source code of what you are running, right? Actually most users don't know which Postgres they are running. Learn about reproducible builds, SBOMs and a new open source Postgres Community distribution.
Beyond Joins and Indexes
Bruce Momjian
While join and index use are interesting, there are many other things the Postgres optimizer can do, and this talk covers them all.
Universal Database Synchronization with Modern Multi-Connector Architecture
Grant Zhou
Database synchronization across heterogeneous systems is one of modern infrastructure's biggest challenges. This presentation introduces SynchDB, an open-source PostgreSQL extension enabling seamless CDC from MySQL, SQL Server, Oracle, and OpenLog Replicator to PostgreSQL.
Break
Stats roll, baby, stats roll.
Cédric Villemain
PostgreSQL 18’s new cumulative stats system lets extension developers create custom statistics. This talk shows how PACS makes observability seamless, providing counters, gauges, buckets, and histograms integrated, similar to pg_stat_* views.
To Update or Build New: A pgTAP Case Study
Evan Stanton
Moving to PostgreSQL? Testing matters. Motivated by customer needs, we sought a balance between updating existing tools or creating an extension. Join me as I share our pgTAP story, covering fundamentals, the wrapper we built, and why.
Beach Break
Lunch
AI-Powered PostgreSQL Productivity: Transform Your Workflow with SQL and DBA Copilots
Daniel Moya
Unlock PostgreSQL's potential with **SQL AI Developer Copilot** and **DBA Copilot**. Generate optimized SQL, DDL, and procedural code tailored to your schema. Analyze queries, tune databases, and boost performance—all with AI-powered tools designed to streamline your PostgreSQL workflows.
Explaining Transaction Isolation Levels
Frédéric Delacourt
The SQL standard defines 4 transaction isolation levels. What about PostgreSQL? Let's dig into each isolation level with practical examples and explain how each level is implemented under the hood. After this talk you should be able to choose confidently the right level for the right context.
Break
From Code to Commerce: Open Source Business Models
Michael Meskes
This presentation will walk the audience through different approaches of monetizing and developing Open Source that have been used over the years. It will examine the pros and cons and the consequences of the newer SaaS models for the Open Source ecosystem.
Postgres Ibiza Social Event
Don't miss the main social event of Postgres Ibiza! Enjoy the views, sunset and the food and drinks while you establish new Community and/or business connections in a relaxed atmosphere.
Aguas de Ibiza
Grand Luxe Hotel
Day 03
FRI 17th
–Venue