PostgresWorld
Postgres Conference: 2026
San Jose / United States
April 21 - 23, 2026
Postgres Conference: 2026
Energizing People with Data and Creativity
With a track record of providing growth and opportunity, education and connections since 2007, Postgres Conference presents a truly positive experience for lovers of Postgres and related technologies. Postgres Conference events have provided education to hundreds of thousands of people, in person and online. We have connected countless professional relationships, helped build platform leaders, and strengthened the ecosystem. We believe community is integral to driving innovation, and intentionally keep our events focused and professional to nourish those relationships.
Sponsors
Conference
Postgres Extensions Sponsor
Partner
Wellness Sponsor
The registration period ends in
Conference Highlights
Running PostgreSQL in Kubernetes with CloudNativePG
In this hands-on, 3-hour workshop, participants will learn how to deploy and manage PostgreSQL in Kubernetes using CloudNativePG (CNPG), the open source operator in the CNCF sandbox. The workshop will walk through the main features to manage a PostgreSQL cluster, from deploying the first CNPG cluster to managing configuration, databases, and roles in a declarative way,Extensions Management, to enabling continuous backups for recovery from a disaster. Attendees will manage the PostgreSQL...
Building Agentic AI Applications with PostgreSQL as the Backbone
The AI landscape is shifting from chatbots to autonomous agents—systems that plan, use tools, maintain memory, and take actions. While attention focuses on language models, the real differentiator for production agents is the data layer. PostgreSQL, with its combination of relational integrity, vector search, and extensibility, is emerging as the ideal backbone for agentic AI. This session explores architectural patterns for building production-grade AI agents with PostgreSQL at the...
Trust, But Verify: Operationalizing Data Consistency Checks for Postgres Logical Replication
Logical replication in Postgres is powerful: enabling selective table replication, cross-version upgrades, and real-time data distribution. But unlike physical replication, there's no guarantee your subscriber actually matches your publisher. Constraint violations, permission failures, skipped transactions, and schema drift can all cause silent divergence. This session demonstrates a practical approach to validating data consistency across logical replication topologies. We'll walk through...
We are all the 99th percentile
When delivering software via the Web, we monitor 99th percentile latency, often without thinking about exactly what it means. Informally, it's almost the slowest experience anyone has using our product. It's (close to) the "worst-case scenario." Too often, we use these informal definitions to excuse our 99th percentile latency. We take comfort in our median latency, which is certainly lower and may even be very impressive! This is a disservice to our users. In this talk, we're going to...
The Power of the Pause
In fast-paced, high-performing environments, speed is often treated as a virtue. Momentum is rewarded, pausing is postponed, and as long as things are “still working,” there’s little reason to stop. The unspoken assumption is simple: why slow down if nothing is obviously broken? But anyone who has ever dealt with a frozen computer knows that clicking faster rarely fixes the problem. In this 20-minute keynote, Megan Darnell, nurse health coach, explores the power of the pause as a...
Enhancing PostgreSQL Sharding Through Agentic AI: Scalability, Optimization, and Autonomous Management
PostgreSQL, a robust open-source relational database management system, has increasingly adopted Sharding techniques to address the challenges of horizontal scaling in high-volume, distributed environments. Sharding involves partitioning data across multiple nodes based on criteria such as hash keys or ranges, enabling improved performance, fault tolerance, and resource utilization. Extensions like Citus and built-in features in PostgreSQL 15+ facilitate declarative partitioning and foreign...
Using Postgres to locate the best coffee near you! ☕
This talk demonstrates how PostgreSQL can be used to answer real-world questions like: “𝗪𝗵𝗲𝗿𝗲’𝘀 𝘁𝗵𝗲 𝗯𝗲𝘀𝘁 𝗰𝗼𝗳𝗳𝗲𝗲 𝘀𝗵𝗼𝗽 𝗻𝗲𝗮𝗿 𝗺𝗲?” by 𝗰𝗼𝗺𝗯𝗶𝗻𝗶𝗻𝗴 𝘀𝗽𝗮𝘁𝗶𝗮𝗹 𝗱𝗮𝘁𝗮 𝗮𝗻𝗱 𝘃𝗲𝗰𝘁𝗼𝗿 𝗲𝗺𝗯𝗲𝗱𝗱𝗶𝗻𝗴𝘀. The session introduces how PostGIS and pgvector work together to enable natural-language style queries over geographic data. Attendees will learn how vector data can enhance traditional geospatial queries by adding semantic context, not just distance or location. Through a hands-on demo, I’ll show how to: - Store...
Building Multi Master Workflows on PostgreSQL Logical Replication
PostgreSQL logical replication provides stable one-way change delivery, supports live upgrades, and keeps standby nodes ready, yet it remains tied to a single source of truth. Building a multi-master workflow demands explicit control over data flow, identity rules, and conflict resolution. This session presents a structured method for extending logical replication into a bidirectional or mesh arrangement. The discussion begins with publication and subscription design for each node, including...
The Elephant in the Room: Tackling PostgreSQL Major Version Upgrades Head-On
PostgreSQL major version upgrades remain a critical challenge many organizations postpone until deadlines force action. This session confronts upgrade anxiety head-on by examining proven strategies including in-place upgrades, Blue/Green deployments, and logical replication approaches. Drawing from my experience with hundreds of customers at AWS, we'll explore upgrade options with their trade-offs in downtime, complexity, and risk through real-world case studies. Learn essential best...
Multigres: One stop PostgreSQL Management and Scaling
PostgreSQL has become the database of choice for modern applications, but scaling beyond a single instance remains a significant challenge. While MySQL users have benefited from Vitess, the battle-tested horizontal sharding system born at YouTube that now powers some of the world's largest deployments, PostgreSQL users have lacked a comparable solution. Multigres changes that. This talk introduces Multigres, an open-source project that adapts Vitess's proven architecture for PostgreSQL....
Beyond vectors: Postgres for Production AI Agents
AI agents are all the hype now and the key to building a production-grade agent is to make sure the model is backed by production-grade data. Postgres, as a mature, secure and fully-ACID relational database with a large extension ecosystem, is a great fit as the backbone of production-grade agents. In this talk, we’ll walk together through building an issue triage agent on Postgres. We’ll share large number of patterns, from basic SQL to advanced SQL to various extensions in order to...
Postgres as a Control Plane: Design Patterns for Real-Time Compute Offload
As Postgres continues to evolve beyond a traditional database into a control plane for orchestrating external compute systems, developers building extensions face a new class of engineering challenges. From vector search engines like Pinecone to ML inference runtimes and streaming platforms, the need to offload compute while preserving SQL simplicity and ACID guarantees is growing. This talk presents practical patterns and architectural lessons from the development of pgvector-remote,...
Stop Guessing: How to Actually Fix PostgreSQL Performance
why PostgreSQL Is Slow (And What to Do About It) When PostgreSQL performs poorly, the root cause is rarely a single configuration setting. This talk breaks down the most common causes of performance issues — missing or ineffective indexes, partitioning, parallelism, poor statistics, suboptimal query patterns, and misinterpreted EXPLAIN plans. Attendees will learn how to diagnose problems systematically and apply fixes that deliver reliable improvements.
PostgreSQL I/O Mechanisms Performance Comparison
With PostgreSQL 18 officially released on September 25, 2025, the project introduced a major performance addition: a new asynchronous I/O (AIO) subsystem. This evidence based talk explores the three I/O approaches PostgreSQL can use to interact with the operating system, including how each works, when it is used, and how to configure it. We’ll walk through the configuration and operating characteristics of each I/O method, then evaluate performance using a neutral, repeatable test...
PostgreSQL 18: The Evolution Continues — What’s New This Year
PostgreSQL 18 represents one of the most developer‑centric releases in the database’s recent evolution, introducing enhancements that significantly simplify application design, improve performance, and expand SQL capabilities. This version pushes PostgreSQL further into the realm of modern, scalable, and developer‑friendly data platforms through a combination of architectural shifts and productivity‑boosting features. At the heart of PostgreSQL 18 is the long‑awaited Asynchronous I/O (AIO)...
Intel® AVX-512 Accelerates PostgreSQL 18 CRC32C Checksums
Abstract PostgreSQL backup operations are critical for database reliability, but CRC32C checksum calculations create performance bottlenecks that scale with database size. This talk demonstrates how Intel AVX-512 vectorization in PostgreSQL 18's CRC32C implementation delivers measurable real-world performance improvements, reducing backup times by 11-14% with significant cost savings for enterprise deployments. The Challenge: Traditional scalar CRC32C implementations process data...
Debezium and PostgreSQL in Action
Debezium enables real-time change data capture (CDC) by streaming database changes to downstream systems, making it a key building block for event-driven architectures. However, many teams use it without fully understanding how it behaves under the hood. In this talk, we’ll take a practical look at Debezium using PostgreSQL as an example. We’ll cover how logical replication powers CDC, how Debezium captures and streams changes, and what happens during restarts or failures. The session will...
Autonomous PostgreSQL: When AI Agents Become Your DBA
PostgreSQL operations are evolving from reactive monitoring to autonomous, AI-powered management. Drawing from my experience with dozens of customers at AWS, this session demonstrates how agentic AI leveraging MCP servers can automate routine DBA tasks: running comprehensive health checks, tuning database parameters based on workload patterns, and identifying and removing duplicate or unused indexes. We'll explore practical implementations using pgvector with HNSW indexing in agentic AI...
How I took my open source business to a Fortune 500 company
You’ve started your open source business or you plan to? And you think you know what to look for for a good exit? Selling to a very large company is more challenging than you probably expect and mostly for reasons you don't imagine yet. There are a lot of differences and traps that can significantly change the outcome. Based on the experience of several deals on the executive level this presentation walks you through the process and shares do's and don'ts. It will help you accomplishing a...
PostgreSQL Housekeeping: The Complete VACUUM Handbook
Every PostgreSQL database needs regular cleanup to stay healthy and fast - that's what VACUUM does. In this talk, we'll break down VACUUM in a way that's easy to understand. We'll look at how VACUUM has gotten better in recent versions, share tips to make it run smoothly, and show you how to fix common problems like slow-running queries and wasted storage space. Whether you're a developer working with databases, a database administrator, or someone who cares about database performance, this...
Materialized Views: Performance Shortcut or Operational Trap?
Materialized views are often the go-to solution for speeding up complex queries in PostgreSQL, especially for heavy joins and time-series aggregations. But while they can deliver impressive performance gains, they also introduce hidden operational costs—long refresh times, slower recovery, and increased fragility as data grows. In this talk, we’ll walk through several real-world examples where materialized views were the right choice, how they later became a bottleneck as data and usage...
“Autovacuum Blocked, Backlogged, or Slow?! Understanding Why It Can’t Keep Up”
Autovacuum keeps PostgreSQL healthy — but when it’s blocked , backlogged or slow your database performance suffers. This session explains why autovacuum falls behind, how to detect it early, and what tuning and operational fixes can restore balance. Ideal for DBAs and developers managing production databases.
Program
