Postgres Conference: 2026 Program

2026-04-21
08:30
PostgresConf Organizers Registration

presented by PostgresConf Organizers

Registration

08:30 - 15:30 Almaden Foyer Conference Happenings
09:00
Vivek Singh Shaily Porwal Autonomous PostgreSQL: When AI Agents Become Your DBA
Automating Health Checks, Parameter Tuning, and Index Management with MCP Servers and pgvector

presented by Vivek Singh and Shaily Porwal

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 in...

more

09:00 - 09:50 Santa Clara (Level C) Ops
Yogesh Jain Building Real-Time, Data-Aware Intelligence with Postgres & Model Context Protocol (MCP)
Eliminating Hallucinations with Postgres and the Model Context Protocol

presented by Yogesh Jain

Imagine asking an AI agent to analyze any data, only for it to hallucinate a schema that doesn't exist. This "context gap" is the primary barrier to reliable Data-Aware AI. While LLMs are brilliant reasoners, they are historically "blind" to the live, structured world of Postgres - until now!

In this talk, we will explore how the Model Context Protocol (MCP) bridges this gap, transforming Po...

more

09:00 - 09:50 San Pedro (Level C) Dev
Amit  Parikh Phil Rodas Running PostgreSQL in Hybrid Data Architectures
Operational Patterns for Zero-Downtime Modernization

presented by Amit Parikh and Phil Rodas

PostgreSQL rarely replaces legacy systems or modern lakehouse platforms overnight. Most teams spend months operating in hybrid environments where PostgreSQL must stay in sync with other data platforms such as Oracle or Snowflake; often under production load and with little room for error. In this session, we explore the operational realities of running PostgreSQL in these hybrid architectures, ...

more

09:00 - 09:20 Winchester 2 Ops
Jim Mlodgenski The power of mentorship

presented by Jim Mlodgenski

A challange for many managers is to remember that first and foremost their job is to ensure the success of their team. It is not uncommon for managers to get wrapped up in organizational structures of "tasks" versus the more powerful, effective and important mentorship. This is especially important for those members of our teams who have not yet developed their leadership skills, need proper mo...

more

09:00 - 09:50 Winchester Professional Development & Wellness
09:30
Yu Lung Law Christopher Hong Materialized Views: Performance Shortcut or Operational Trap?
Materialized Views: Performance Shortcut or Operational Trap?

presented by Yu Lung Law and Christopher Hong

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 whe...

more

09:30 - 09:50 Winchester 2 Ops
10:00
Karen Ng Anita Singh RDS Maintenance: Strategies for Patching and Version Upgrades
Postgresql Upgrade on AWS

presented by Karen Ng and Anita Singh

As PostgreSQL continues to evolve with annual major releases and regular security patches, database administrators face the critical challenge of maintaining up-to-date RDS PostgreSQL instances while minimizing operational disruption. This paper presents a comprehensive analysis of patching strategies and engine upgrade methodologies for Amazon RDS PostgreSQL, examining the trade-offs between d...

more

10:00 - 10:50 Winchester 2 Ops
Robert Bernier Implementing Transparent Data Encryption At Rest
HowTo Master pg_tde

presented by Robert Bernier

The very last line of defense against protecting your data from theft or exploitation is securing the appliance that holds it. In the past, protecting your data at rest in PostgreSQL relied upon the filesystem encryption used on the persistant storage. This session will introduce you to the freely available opensource extension pg_tde. W'ell review basic concepts, and how easy it is to install ...

more

10:00 - 10:50 Winchester Essentials
Mohamed Ali Elevate your DBA toolset with pg collector
a powerful open-source tool that help you gain deep insights into your PostgreSQL database

presented by Mohamed Ali

PG Collector is a powerful open-source tool (https://github.com/awslabs/pg-collector) that gathers valuable PostgreSQL performance details and presents it in a simple report and provide Automated Database Health check. If you are a DBA, come and learn how PG Collector can help reduce your mean Time to Know (MTTK) and help you gain deep insights into the health of your PostgreSQL database.

10:00 - 10:50 Santa Clara (Level C) Ops
Varun Dhawan Using Postgres to locate the best coffee near you! ☕

presented by Varun Dhawan

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 sem...

more

10:00 - 10:50 San Pedro (Level C) Dev
11:00
Luigi Nardi A benchmark study on the impact of PostgreSQL server parameter tuning

presented by Luigi Nardi

PostgreSQL, renowned for its extensibility and robust feature set, offers a wealth of server configuration parameters that can significantly influence its performance. Most PostgreSQL users operate with default parameters, which are often not optimized for commonly used server machine flavors. This talk is a comprehensive benchmark analysis exploring the potential performance benefits achievabl...

more

11:00 - 11:50 Santa Clara (Level C) Ops
Joshua D. Drake Defining success on your terms

presented by Joshua D. Drake

McMansions, Venture Captilalists and Ogligarchs be damned. Let's walk the walk and determine exactly what success is, why the lie of the market is your shackles and how to break free of the ties that bind. In this talk we are going to work through who we are at our core, defining success for who you are and not what the consumerist demands of you. There are no secrets here, only bold truths tha...

more

11:00 - 11:50 Winchester 2
Richard Crowley When a spreadsheet won't cut the mustard
Lessons learned reimagining a SaaS pricing spreadsheet as a Postgres database

presented by Richard Crowley

Spreadsheets are everywhere, from shoestring budgets and vacation itineraries to complex models driving global financial markets. Spreadsheets are there when your typical startup sets its prices, too. It starts out simple - a list of things you sell and how much you charge. Inevitably you'll add additional paid features, separate fixed and variable costs, expand to other countries or currencies...

more

11:00 - 11:20 Winchester Essentials
Ning Yu Yandong Yao YMatrix mxvector: How to implement high performance pluggable vectorized executor in PostgreSQL
YMatrix mxvector: How to implement high performance pluggable vectorized executor in PostgreSQL

presented by Ning Yu and Yandong Yao

PostgreSQL's performance in OLAP and HTAP scenarios can be significantly enhanced through a vectorized executor, an optimized execution model tailored for analytical workloads. By leveraging typed operations, batched processing, and SIMD instructions, vectorized execution minimizes overheads associated with traditional row-by-row processing, such as repeated function calls and data extraction f...

more

11:00 - 11:20 San Pedro (Level C) Dev
11:30
Robert Bernier Vector Database Performance Challenges, A CaseStudy
Working With The pg_vector And pg_vectorscale Indexes

presented by Robert Bernier

AI brings vector data types to our attention like lightening warns us of the impending thunderclap in a storm. And like thunder, we don't know what it means until its too late. Despite the rapid advances developing pg_vector, an improperly designed system is more than likely to occur resulting in slow performance.

This case-study is based upon the challenges developing a solution manipulatin...

more

11:30 - 11:50 Winchester Essentials
Velu Natarajan Debezium and PostgreSQL in Action
Capturing Database Changes in Real Time

presented by Velu Natarajan

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 D...

more

11:30 - 11:50 San Pedro (Level C) Ops
12:00
PostgresConf Organizers Lunch

presented by PostgresConf Organizers

Lunch

12:00 - 13:00 Almaden Ballroom Conference Happenings
13:00
Mike Josephson The Open Source Approach: Building Production-Ready AI Apps with Postgres

presented by Mike Josephson

It’s no secret that Postgres is uniquely positioned as being an ideal foundation for agentic AI applications. However, there are many different components you need to consider to ensure your application runs as expected in an enterprise environment: in a security hardened manner, grounded in verifiable information, with efficient token usage.

In this talk, we will show you how to leverage...

more

13:00 - 13:50 San Pedro (Level C) Dev
Richard Crowley We are all the 99th percentile
How 99th percentile latency can add up to a bad experience for everyone

presented by Richard Crowley

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 a...

more

13:00 - 13:20 Santa Clara (Level C) Ops
Dave Stokes What Can An AI Assistant Do For You?
AI Can Make Your SQL Better!

presented by Dave Stokes

Artificial Intelligence has been over hyped. But it is great at pattern matching and the SQL Syntax is a well known pattern. So if you have an unknown {database | table | query), AI can examine and report on functionality. AI can do the work when your boss wants you to update a working query to add 'quarterly rollups for EMEA'. Syntax errors can easily be spotted AND fixed by your assistant. An...

more

13:00 - 13:50 Winchester Professional Development & Wellness
13:30
Yandong Yao Hao Wang YMatrix Domino: Design Considerations, Trade-offs, and Implementation of In-Database Stream Processing
YMatrix Domino: Design Considerations, Trade-offs, and Implementation of In-Database Stream Processing

presented by Yandong Yao and Hao Wang

YMatrix is a distributed, multi-model database built on PostgreSQL. Domino is its native in-database stream processing engine, enabling true unified batch and stream processing. This talk explores the design concepts, technology selection, and implementation of in-database stream processing in YMatrix, aiming to address the complexity, resource overhead, and consistency challenges of traditiona...

more

13:30 - 13:50 Santa Clara (Level C) Dev
14:00
AMEY BANARSE From Transactions to Agents: PostgreSQL in Modern AI Applications

presented by AMEY BANARSE

Modern AI applications are no longer just chatbots—they are agentic systems that reason, retrieve context, call tools, and maintain state across many user interactions. For application developers, the hardest part isn’t model selection—it’s building an architecture that scales without sacrificing latency, correctness, or developer velocity. In this session, we’ll walk through a PostgreSQL-cent...

more

14:00 - 14:20 San Pedro (Level C) Dev
Shaily Porwal Vivek Singh The Elephant in the Room: Tackling PostgreSQL Major Version Upgrades Head-On
A Complete Guide to Planning, Testing, and Executing PostgreSQL Upgrades

presented by Shaily Porwal and Vivek Singh

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-o...

more

14:00 - 14:50 Santa Clara (Level C) Ops
Saiprasad  Chakkera PostgreSQL 18: The Evolution Continues — What’s New This Year
What’s New, What’s Improved, and What It Means for Your Applications

presented by Saiprasad Chakkera

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 product...

more

14:00 - 14:50 Winchester Essentials
14:30
Peter Kraft Building Durable Programs with Postgres

presented by Peter Kraft

Everyone knows you can use Postgres to make data durable. In this talk, we’ll explore how to use Postgres to make your programs durable, so they can survive crashes, restarts and updates without restarting from scratch.

In particular, we’ll explore an emerging technology called durable execution. The idea behind durable execution is to checkpoint a program’s state in a durable store so t...

more

14:30 - 14:50 San Pedro (Level C) Dev
15:00
Shayon Sanyal Building Agentic AI Applications with PostgreSQL as the Backbone
Memory systems, tool registries, MCP integration, and guardrails for production agents

presented by Shayon Sanyal

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 e...

more

15:00 - 15:50 San Pedro (Level C) Dev
Premnath Jangam abhinav sagar Enhancing PostgreSQL Sharding Through Agentic AI: Scalability, Optimization, and Autonomous Management
Sharding with Agentic AI

presented by Premnath Jangam and abhinav sagar

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 ...

more

15:00 - 15:50 Santa Clara (Level C) Ops
Ryan Booz Mastering PostgreSQL Partitioning: Advanced Questions and Demos

presented by Ryan Booz

PostgreSQL partitioning continues to gain popularity and adoption. While many users understand the basics of creating partitions, they often seek practical guidance about their pros and cons, ideal use cases, and potential pitfalls.

In this follow-up session to "Mastering PostgreSQL Partitioning: Supercharge Performance and Simplify Maintenance," we'll explore partitioning strategies for dif...

more

15:00 - 15:50 Winchester Essentials
16:00
Sri Ram Phani Kiran Kadambari Vivek Singh Migrating Oracle RAC to PostgreSQL Using Ora2Pg
Strategies, Challenges, and Best Practices

presented by Sri Ram Phani Kiran Kadambari and Vivek Singh

Migrating enterprise workloads from Oracle to PostgreSQL is becoming increasingly strategic as organizations pursue open-source innovation, cost optimization, and cloud modernization. This session delivers a practical, end-to-end view of the Oracle-to-PostgreSQL migration journey—from initial assessment and phased migration planning to tool selection and hands-on execution. Attendees will explo...

more

16:00 - 16:50 Santa Clara (Level C) Ops
Eshe Pickett Kelly McKeighan Intel® AVX-512 Accelerates PostgreSQL 18 CRC32C Checksums
Real-World Performance Gains and Cost Savings from Hardware-Accelerated Checksums

presented by Eshe Pickett and Kelly McKeighan

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 ...

more

16:00 - 16:50 Winchester Essentials
Nasiullha Chaudhari Beyond Text: Building Multimodal Search with pgvector in PostgreSQL
Using pgvector to Model, Query, and Combine Text and Image Embeddings in SQL

presented by Nasiullha Chaudhari

Large language models are no longer limited to text. They can also understand images and other modalities and represent them as embeddings that can be stored and queried directly in PostgreSQL. In this talk, we explore how pgvector can be used to build multimodal search features where users search using text, images, or a combination of both, all within a familiar SQL-based workflow.

We ...

more

16:00 - 16:50 San Pedro (Level C) Dev
2026-04-22
08:30
PostgresConf Organizers Registration

presented by PostgresConf Organizers

Registration

08:30 - 15:30 Almaden Foyer Conference Happenings
09:40
Ryan Booz Serious Beesness: Life Lessons from the Hive

presented by Ryan Booz

After getting into beekeeping a few years ago, I expected to get stung a lot and eat some natural, raw honey. What I didn’t expect was how much the structure of a healthy hive mirrors the challenges we face in our work and personal lives.

In this talk, I’ll briefly explain how a hive actually works, the different roles bees play, and why those roles matter. From there, we’ll connect what hap...

more

09:40 - 10:00 Almaden Ballroom Life and Fun
10:00
Dan Lynch When Trust Becomes Infrastructure: Secure-by-Default Postgres for the AI Era

presented by Dan Lynch

As AI and automation accelerate software development, trust shifts from who wrote the code to what guarantees the system provides, making the backend the final line of defense. When software is generated, orchestrated, and executed at machine speed, security can no longer live in conventions, reviews, or application glue—it must be structural. This is where Constructive’s architectural approach...

more

10:00 - 10:20 Almaden Ballroom Dev
10:20
Robert Treat Postgres @ Amazon

presented by Robert Treat

Amazon has a long history with PostgreSQL, whether it be internal company adoption or the many AWS services built around it. In this session, Robert Treat looks back across Amazon's journey with PostgreSQL, from its large-scale migration from Oracle to the creation of Amazon RDS for PostgreSQL. He also takes a look at how Amazon is making use of PostgreSQL today through current offerings such a...

more

10:20 - 10:40 Almaden Ballroom
11:20
Michael Meskes How I took my open source business to a Fortune 500 company

presented by Michael Meskes

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 present...

more

11:20 - 11:40 Almaden Ballroom Professional Development & Wellness
11:40
Megan Darnell The Power of the Pause
A Strategic Reset for High-Performance Systems

presented by Megan Darnell

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...

more

11:40 - 12:00 Almaden Ballroom Professional Development & Wellness
12:00
PostgresConf Organizers Lunch

presented by PostgresConf Organizers

Lunch

12:00 - 13:00 Almaden Ballroom Conference Happenings
13:00
Danish Khan Neel Patel Running PostgreSQL in Kubernetes with CloudNativePG

presented by Danish Khan and Neel Patel

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 ...

more

13:00 - 16:00 Almaden Ballroom Ops
Gwen Shapira Beyond vectors: Postgres for Production AI Agents

presented by Gwen Shapira

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 sh...

more

13:00 - 13:50 San Pedro (Level C) Dev
Anita Singh Stop Guessing: How to Actually Fix PostgreSQL Performance

presented by Anita Singh

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 s...

more

13:00 - 13:50 Winchester Essentials
Ryan Booz Logging with Purpose: A Framework for Finding and Fixing Slow Queries in Postgres

presented by Ryan Booz

Postgres offers many tools for query observability, but many teams struggle to use them effectively. Some collect too little data and miss important performance problems, while others log everything—creating noise, overhead, and confusion without clear next steps.

In this talk, we’ll present a practical framework for configuring Postgres logging and query analysis with a single goal: identif...

more

13:00 - 13:50 Santa Clara (Level C) Ops
14:00
Clay  Jackson Model Your Data Before You Move it

presented by Clay Jackson

Model Your Data Before You Move It Data movement is a transformative force in today's digital landscape, enabling organizations to unlock the true value of data. Successful data movement requires a comprehensive data governance strategy that encompasses data selection, understanding, quality, mapping, schema development, and serialization.

Effective data selection prioritizes valuable dat...

more

14:00 - 14:50 Winchester Essentials
Sameer Malik Replacing Oracle’s Advanced Features in PostgreSQL: High Availability, Advanced Functions, and Extensibility

presented by Sameer Malik

Migrating from Oracle to PostgreSQL often raises questions about replacing powerful Oracle features like Materialized Views, Flashback Queries, Virtual Columns, Oracle RAC, and PL/SQL Packages. While PostgreSQL doesn’t replicate these features identically, it offers robust alternatives that meet—and often exceed—Oracle’s capabilities. This session will guide you through: - Replacing Oracle’s M...

more

14:00 - 14:50 San Pedro (Level C) Dev
Megan Darnell Rewiring for Resilience
How to Hack Your Neural Pathways for Peak Performance

presented by Megan Darnell

Your brain is constantly adapting, shaping your habits, focus, and resilience. In this session, we’ll take a deep dive into the neuroscience of habit formation, stress response, and sleep—uncovering how to rewire your neural pathways for better health and cognitive performance. You’ll also learn how movement plays a key role in brain function, emotional regulation, and long-term well-being. Wal...

more

14:00 - 14:50 Santa Clara (Level C) Professional Development & Wellness
15:00
Shayon Sanyal Hybrid Search in PostgreSQL: Combining Vector and Full-Text for Real-World Applications
Reciprocal Rank Fusion, schema design, and query patterns for multi-modal search

presented by Shayon Sanyal

PostgreSQL has evolved into a multi-model database capable of handling diverse search requirements. While many developers know about pgvector for semantic search or tsvector for full-text search, few have explored combining these capabilities into unified hybrid search systems. This session takes a practitioner's approach to building hybrid search in PostgreSQL. We'll start with the "why": sema...

more

15:00 - 15:50 San Pedro (Level C) Dev
Dr. Ibrar Ahmed Building Multi Master Workflows on PostgreSQL Logical Replication

presented by Dr. Ibrar Ahmed

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 a...

more

15:00 - 15:50 Santa Clara (Level C) Ops
Scott Mead Parallel query is silently stealing your CPU

presented by Scott Mead

Postgres Parallel Query offers an improvement in performance for certain query times when used intentionally. When Postgres decides to go parallel query on its own, things go very wrong, quickly. We'll take a look at examples of where parallel query helps, how it doesn't, and how to protect your customers from willy-nilly parallel-plan flips.

15:00 - 15:50 Winchester Essentials
16:00
Hunter OBrien PostgreSQL I/O Mechanisms Performance Comparison
A comparative analysis of PostgreSQL 18 I/O Mechanisms and Evaluating their Efficiency

presented by Hunter OBrien

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 chara...

more

16:00 - 16:50 Santa Clara (Level C) Ops
Sukhpreet Bedi PostgreSQL Housekeeping: The Complete VACUUM Handbook

presented by Sukhpreet Bedi

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 worki...

more

16:00 - 16:50 Winchester Essentials
Clay  Jackson Solar Power in the Pacific NW

presented by Clay Jackson

This talk will detail how we installed 3 6KW solar electric arrays AND solar hot for our home in eastern Washington State; including the use of Home Assistant to monitor and record solar output.

Attendees will learn how the power of the sun can be used to help reduce carbon footprints, with practical suggestions on vendor selection and ongoing maintenance.

16:00 - 16:20 San Pedro (Level C) Life and Fun
16:30
Greg Potter Schema-First PostgreSQL Migrations Without a DSL
Putting pg_catalog to Work

presented by Greg Potter

If you’ve ever stared at a 200-file migrations directory wondering what your schema actually looks like, or fought with a migration DSL that couldn’t express a partial index, you’ve hit the limits of traditional migration tooling.

This talk explores a different approach: keeping your schema in plain SQL and letting PostgreSQL itself compute migrations. Instead of parsing SQL or re-implementi...

more

16:30 - 16:50 San Pedro (Level C) Dev
17:00
PostgresConf Organizers Welcome Reception

presented by PostgresConf Organizers

Join us for the 2026 Welcome Reception - Outside on the Patio!

17:00 - 19:00 Patio (Outside Restaurant) Conference Happenings
2026-04-23
08:40
PostgresConf Organizers Registration

presented by PostgresConf Organizers

Registration

08:40 - 15:40 Almaden Foyer Conference Happenings
09:00
Sweta Vooda Postgres as a Control Plane: Design Patterns for Real-Time Compute Offload

presented by Sweta Vooda

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 ta...

more

09:00 - 09:50 Winchester Postgres Extensions Day
Arpitha Vasudeva Demystifying PostgreSQL High Availability in the Cloud

presented by Arpitha Vasudeva

High availability for PostgreSQL takes on new dimensions in cloud environments. This session breaks down the key architectural decisions teams face when designing for PostgreSQL high availability in the cloud. We'll explore read replicas, failover mechanisms, and backup strategies, comparing native PostgreSQL capabilities with cloud-native features. Using practical examples, we'll examine how t...

more

09:00 - 09:50 Santa Clara (Level C) Ops
Monica Rivera Technical Credibility Isn’t Enough: Communication Skills Every Senior Engineer Needs to Scale Impact

presented by Monica Rivera

Engineers are trusted for their technical expertise, but many still find their ideas overlooked, misunderstood, or slow to gain traction, even when the work itself is strong.

This session explores why technical credibility alone isn’t enough as engineers take on greater responsibility. **As scope and visibility increase, impact depends not only on what you know, but on how effectively you co...

more

09:00 - 09:50 San Pedro (Level C) Professional Development & Wellness
10:00
Dan Lynch Modular Databases: We Put Postgres in package.json

presented by Dan Lynch

Modern software is built from composable, versioned modules with clear dependencies, reproducible builds, and continuous verification. Databases, despite being the most critical layer in the stack, are still developed without these guarantees—relying on fragile migration chains, manual conventions, and security rules that are difficult to test or audit.

This talk introduces a package-first a...

more

10:00 - 10:50 Winchester Postgres Extensions Day
Mohamed Ali BAJI SHAIK “Autovacuum Blocked, Backlogged, or Slow?! Understanding Why It Can’t Keep Up”
Essential Techniques for Database Administrators to Identify and Resolve Vacuum Challenges

presented by Mohamed Ali and BAJI SHAIK

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.

10:00 - 10:50 San Pedro (Level C) Essentials
Amanda Nystrom The Wellness OS

presented by Amanda Nystrom

Maintaining a career in tech often feels like running a marathon at a sprinter’s pace. Too often we don’t take the time to properly manage and maintain our internal systems until we are faced with a significant health issue - an outage, if you will. To prevent burnout and sustain high performance, wellness shouldn’t be an afterthought. It needs to be integrated into our system infrastructure. ...

more

10:00 - 11:30 Santa Clara (Level C) Professional Development & Wellness
11:00
Greg Dostatni Measuring shared_buffers Behavior on Large-Memory PostgreSQL Systems
Evidence from 128 GB Synthetic Benchmarks

presented by Greg Dostatni

PostgreSQL’s long-standing recommendation to allocate 25% of system memory to shared_buffers dates back to version 8.3 (released in 2008) when typical system memory was measured in a handful of GB. Modern servers can provision hundreds of GB, and it is not unheard of to come across databases that approach 0.5 TB of RAM or more. The relationship between memory size, workload characteristics and ...

more

11:00 - 11:50 San Pedro (Level C) Essentials
Kevin Shen Building an Efficient HTAP Architecture with PostgreSQL and Apache Doris with Native Doris Postgres CDC

presented by Kevin Shen

Most HTAP strategies add complexity rather than removing it. Relying on external pipelines like Flink CDC introduces a heavy middleware layer; you aren't just moving data, you are managing separate clusters, debugging checkpoint failures, and requiring dedicated engineering expertise just to keep the pipeline alive. Conversely, many distributed HTAP databases fail to provide full analytical cov...

more

11:00 - 11:50 Winchester Postgres Extensions Day
11:40
Jonah Harris Don’t Standby, Stand-Up!
Comedy for the On-Call

presented by Jonah Harris

An elephant, a dolphin, and a sea lion walk into a bar... In this workshop, we'll EXPLAIN ANALYZE the mechanics of stand-up comedy, breaking down setup, timing, and punchlines like a query plan, and even what to do if you deadlock! No stage experience required, no pressure to perform, just a room full of Postgres professionals learning how to turn production pain into polished performances.

11:40 - 12:00 Santa Clara (Level C) Life and Fun
12:00
PostgresConf Organizers Lunch

presented by PostgresConf Organizers

Lunch

12:00 - 13:00 Almaden Ballroom Conference Happenings
13:00
Shaun Thomas Let’s Build a Postgres Extension!
Deriving RAM Usage from Query Plans

presented by Shaun Thomas

Have you ever executed a query and wondered: how much RAM will that use? The documentation explains that each query node can allocate a copy of work_mem, but there’s no way to know how much that will be before or even after a query runs aside from literally counting the nodes by hand following an EXPLAIN.

What if there was an extension that supplied a function to parse a query and report...

more

13:00 - 13:50 Winchester Postgres Extensions Day
Sameer Malik Narrating the Distributed Database on PostgreSQL journey

presented by Sameer Malik

Like all RDMS PostgreSQL was originally designed as a database system for single-server deployments, PostgreSQL rich ecosystem includes several extensions and features/functionality that enable PostgreSQL to run in a distributed configuration. In this session we will dive deep into the PostgreSQL database implementation in a distributed configuration and we will explore and discuss major cloud ...

more

13:00 - 13:50 San Pedro (Level C) Essentials
Luigi Nardi Autotuning PostgreSQL: A deep dive into server parameter tuning with agentic AI

presented by Luigi Nardi

PostgreSQL reveals a multitude of configurable server parameters that govern its runtime behavior. As the system evolves, the high number, the non-linear relationship and the complexity of these parameters highlight the importance of their correct configuration in optimizing application performance and server resource utilization. This talk discusses various tuning approaches, starting with the...

more

13:00 - 13:50 Santa Clara (Level C) Ops
14:00
Anita Singh Angel Duenas Neyra PostgreSQL Statistics Unleashed: Mastering Query Optimization Through Data-Driven Insights
Database Statistics in PostgreSQL: What the Query Planner Knows and How It Decides

presented by Anita Singh and Angel Duenas Neyra

Understanding Database Statistics in PostgreSQL

Database statistics are the secret weapon behind PostgreSQL's query optimizer, directly impacting query performance and overall database health. This session takes you beyond the basics to explore how PostgreSQL collects, maintains, and leverages statistics to make intelligent decisions about query execution.

Whether you're managing a handfu...

more

14:00 - 14:20 San Pedro (Level C) Essentials
Matt Welch Accelerating PostgreSQL Backups with Intel® QuickAssist Technology
Hardware-Accelerated Compression for 29x Faster pg_dump Performance

presented by Matt Welch

Problem

PostgreSQL backup operations frequently become critical performance bottlenecks as database compression during pg_dump consumes substantial CPU resources, extending backup windows and impacting concurrent workloads. For organizations managing large PostgreSQL deployments, these bottlenecks directly affect recovery time objectives, operational costs, and system availability.

So...

more

14:00 - 14:20 Santa Clara (Level C) Ops
Mason Sharp Trust, But Verify: Operationalizing Data Consistency Checks for Postgres Logical Replication

presented by Mason Sharp

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...

more

14:00 - 14:20 Winchester Postgres Extensions Day
14:30
Tim Steward Leveraging Open-Source Data Platforms to Build Cost-Effective and Reliable Supply Chain Systems

presented by Tim Steward

The evolution of supply chain management systems (SCM) increasingly requires cost effectiveness, reliability and scalability, while operating in dynamic data environments. In this session we will outline how PostgreSQL can deliver a foundation for creating reliable SCM systems with all the advantages of an open-source database from improved innovation to reduced costs.

14:30 - 15:20 San Pedro (Level C) Ops
Deepthi Sigireddi Sugu Sougoumarane Multigres: One stop PostgreSQL Management and Scaling

presented by Sugu Sougoumarane and Deepthi Sigireddi

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 intr...

more

14:30 - 15:20 Santa Clara (Level C) Ops
Hari Krishna Sunder DocumentDB on Postgres: Native BSON, Vectors, and Mongo Compatibility
This session is designed for developers and architects interested in the internal mechanics of DocumentDB extension and those looking to maximize their development workflow without leaving the PostgreSQL ecosystem

presented by Hari Krishna Sunder

DocumentDB ** DocumentDB **

Developers are increasingly tasked with building cloud ready applications that require both flexible data schemas and advanced AI capabilities. Traditionally, this meant managing a complex stack of document stores, vector databases, and relation...

more

14:30 - 15:20 Winchester Postgres Extensions Day
15:30
Jonah Harris Rewriting the Postgres Engine
Lessons Learned at the Edge of Postgres Extensibility

presented by Jonah Harris

Postgres is the most extensible production-grade database. But extensibility has limits. Some changes require rewriting the core.

In this session, I will share lessons from 26+ years of extending and rewriting Postgres at scale. This work spans compatibility aspects, including behavioral semantics, wire protocols and modern APIs, SQL dialects and procedural languages, and direct access to Or...

more

15:30 - 16:20 Winchester Postgres Extensions Day
Dr. Ibrar Ahmed Eight Steps to Bullet-Proof Database Disaster Recovery

presented by Dr. Ibrar Ahmed

Disks fail, RAM runs short, software breaks, and human error introduces faults that spread through a PostgreSQL cluster without warning. When these events occur, data integrity depends on a disciplined recovery process rather than ad hoc fixes. This talk provides a structured approach to handling corruption and service failures in production environments. The session begins with early-detection...

more

15:30 - 16:20 Santa Clara (Level C) Ops
Clay  Jackson Manage Databases, Lead People

presented by Clay Jackson

Rear Admiral Grace Murray Hopper, "The mother of computer science" said repeatedly, "You lead people, you manage things". In this presentation, we'll review principles of leadership, including: - Building trust - Identifying what matters - Walking other's shoes - Communication - People Development

We'll review how you can apply each of these principles to your career, if you're an ind...

more

15:30 - 16:20 San Pedro (Level C) Professional Development & Wellness
16:30
Arun Samayam Running Distributed PostgreSQL with Citus
Scaling PostgreSQL Beyond a Single Node

presented by Arun Samayam

Citus extends PostgreSQL to handle large-scale, distributed workloads by enabling horizontal scaling through sharding and parallel query execution. While the concept is powerful, many teams struggle to understand how Citus behaves in real production environments and how to design it correctly for performance, availability, and growth.

In this session, we’ll explore the core architecture of C...

more

16:30 - 17:20 Winchester Postgres Extensions Day
Ishan Jain Safe PostgreSQL Migrations at Billion-Scale with Flyway
Standardizing PostgreSQL Schema Changes Across Services Without Slowing Releases

presented by Ishan Jain

In this talk, we share how we use Flyway in a monorepo architecture to standardize and operate PostgreSQL schema migrations at scale. We’ll walk through the design decisions behind our migration workflow, how we structure and version migrations across multiple services, and the guardrails we’ve put in place to prevent unsafe changes from reaching production.

You’ll see how we handle common f...

more

16:30 - 17:20 San Pedro (Level C) Ops
Hari Kiran Past, Present, and Future: Logical Decoding and Replication in PostgreSQL

presented by Hari Kiran

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 PG94 has now matured into a powerful feature, allowing for fine-grained control over what gets replicated and where.

In this talk, we’ll trace the journey of logical decoding and replication i...

more

16:30 - 17:20 Santa Clara (Level C) Ops
Unscheduled events
Michael Meskes How life changes after an exit

presented by Michael Meskes

Any exit has a lot of unknowns coming with it and it certainly feels very different from what you anticipated. When one door closes, another opens, but where is that newly opened door and what does it mean for me personally? In this short talk the presenter will share the experience from his own journey.

Professional Development & Wellness
Robert Treat Amazon 50 Minute (Placeholder)

presented by Robert Treat

Amazon Placeholder

Dave Stokes Rescued Draft Horses

presented by Dave Stokes

My wife recently discovered a draft horse rescue not too far from our house that was in need of volunteers. Patch's Place takes animals that are too old, too infirm, or have other issues that prevent them from being rehomed elsewhere. Some have terrible scars, physical and emotional. So imagine you are scooping up what you have to scoop up that comes from horses, and a one-ton 6'4" beheamout...

more

Life and Fun