Schedule & Sessions

What happens in the lead-up to a Postgres feature freeze, and why do some patches make the cut while others stall? Join four of the project’s open source contributors—Álvaro Herrera, Heikki Linnakangas, Melanie… Read more

When Postgres is bad at something, we can make it good at it through extensions. Postgres is not a good analytics database. Its analytical query performance is relatively, it has no facilities for interacting with… Read more

Migrating very large databases (VLDBs) to PostgreSQL becomes significantly more complex when the target is a managed cloud service. This session presents proven, field‑tested strategies for migrating multi‑terabyte… Read more

Running PostgreSQL today often means choosing between overspending on idle capacity or risking performance dips when traffic suddenly spikes. Teams face unpredictable workloads—burst‑heavy APIs, event‑driven… Read more

Hacking on PostgreSQL can feel overwhelming: a massive codebase, a rigorous review culture, and a patch queue that never seems to shrink. Many aspiring contributors ask the same questions: Where do I begin? What… Read more

PostgreSQL offers a surprisingly large number of authentication methods—but most users only encounter one or two of them, often without understanding why they exist. In this short talk, we take a fast, story driven… Read more

PostgreSQL 18 introduces temporal keys, NOT ENFORCED constraints and promotes NOT NULL to a first-class constraint. Constraint handling for partitioned tables has also improved. In this session, we’ll walk through… Read more

Modern applications often rely on message queues - for background jobs, data pipelines, notifications, and event-driven architectures. Using something external like Kafka, Redis, RabbitMQ, etc increases… Read more

Optimizing your database with AI is a tantalizing prospect, but how can we make sure to do this in a risk-free manner? In this talk, I will share my experience with building safeguards and guardrails for automated… Read more

My talk will examine the practical details of implementing a logical decoding consumer, drawing from my experience in building a client in Go using pglogrepl and from studying production CDC systems like PeerDB and… Read more

PostgreSQL generated columns are a powerful feature, and recent releases have significantly expanded what they can do. With PostgreSQL 18, generated columns are now virtual by default, while still allowing stored… Read more

Wrap-up to Livestream 2 for POSETTE: An Event for Postgres 2026. Includes impressions of the livestream from the virtual hallway track on Discord to the swag, and highlight reels of the other livestreams.

The Postgres write-ahead log, or WAL, is basically a change-log for the database. It enables several important Postgres features: crash recovery, point-in-time recovery, and binary and logical replication. This… Read more

PostgreSQL's logical replication captures database changes in real-time, but most developers still rely on external streaming platforms like Kafka for event processing. This session shows you how to build… Read more

We rely heavily on PostgreSQL functions, procedures, and SQL logic, yet we largely test them as black boxes. Tests may pass, but we rarely know what actually executed and what code paths remain… Read more

Most people don’t think of Postgres in the context of quorum or distributed systems theory but vanilla open source Postgres has supported quorum commits across multiple replicas for almost 10 years now.… Read more

As AI agents move from demos to production, the real challenge isn’t the model, it’s reliable, safe, and context‑aware data retrieval. In this talk, we explore how PostgreSQL is becoming the backbone for agent… Read more

Simply upgrading PostgreSQL can make many everyday queries run faster, without any schema changes or application rewrites. In this talk, I’ll do a side‑by‑side comparison of Postgres 17 and 18 using common query… Read more

One of PostgreSQL's greatest strengths is its ability to serve as more than just a traditional database—it can be the foundation for intelligent systems. With the rise of AI-powered applications, PostgreSQL has… Read more

PostgreSQL is no longer just a transactional workhorse—it’s rapidly becoming the “everything database” for modern developers. Backed by a vibrant open-source community, Postgres is blurring the lines between… Read more

A lot of Postgres “scaling problems” look the same: low CPU, high latency, falling insert rates, and unpredictable behavior once the dataset gets big, in the TBs. In most cases we’ve investigated, the bottleneck… Read more

Modern Postgres workloads keep running into the same questions: How do you get consistent performance when traffic suddenly spikes? How do you keep latency predictable? How do you scale reads without bolting on… Read more

This talk focuses on the real problems large tables create at scale: autovacuum falling behind, bloat accumulating silently, planner misestimation, WAL explosions, and maintenance operations colliding with… Read more

Wrap-up to Livestream 3 for POSETTE: An Event for Postgres 2026. Includes impressions of the livestream from the virtual hallway track on Discord to the swag, and highlight reels of the other livestreams.

Over the last three years, I have tried every single thing I could think of with Postgres partitions, and I made many mistakes. Most of them on my laptop; some lessons were a bit more painful. I've seen my fair… Read more

Using relational databases, how do you efficiently determine an optimal path covering all your tickets in the game of Ticket to Ride? Traditionally, solutions to graph-like problems in PostgreSQL—such as… Read more

In this talk, I will share the journey of identifying and optimizing a performance bottleneck in PostgreSQL. The session will walk through a systematic approach to diagnosing performance issues — distinguishing… Read more

If your analytics workflow starts with exporting data from Postgres, you’re not alone. Many teams build ETL pipelines just to answer questions about data that already lives in Postgres. But what if you didn’t have… Read more

Many developers run Postgres on "burstable" cloud instances (like Azure B-series or AWS T-series) to optimise costs. While cost-effective, these instances operate on a CPU credit model that introduces… Read more

Logical replication has evolved into a foundational capability for modern PostgreSQL deployments, enabling real-time data synchronization, partial replication. What began as a low-level decoding API in PostgreSQL… Read more

Is your Postgres database really secure, or just “working”? Why do security issues keep showing up after launch? Many teams rely on defaults until an incident proves otherwise. This session tackles common… Read more

PostgreSQL 18 delivers one of the most significant sets of VACUUM and ANALYZE improvements in years, making maintenance faster, more predictable, and easier to tune. This session highlights the key changes and… Read more

Scaling a distributed Postgres cluster often isn’t limited by “adding a VM”, it’s limited by how long it takes to rebalance data safely. In this talk, I’ll give a minimal mental model of how Citus distributes data… Read more

LISTEN/NOTIFY is a powerful and elegant PostgreSQL feature for asynchronous communication between backend components. It allows lightweight data transfer and instant notification updates without the need for a… Read more

What really happens to a single INSERT in PostgreSQL once it enters the system? In this talk, we trace the complete lifecycle of one tuple as it travels through PostgreSQL’s logical replication pipeline. Starting… Read more

Wrap-up to Livestream 4 for POSETTE: An Event for Postgres 2026. Includes impressions of the livestream from the virtual hallway track on Discord to the swag, and highlight reels of the other livestreams.