Postgres Conference 2025 Program

presented by PostgresConf Organizers
Registration is available through part of this day to answer any questions you may have and get you checked in
09:00 - 15:00 Registration Conference Happenings
presented by Aaron Cutshall
Database queries, stored procedures, and poorly written functions are the main contributors to performance degradation in Postgres because it is optimized for set-based processing over procedural processing. The sad reality is that too much code is written from a procedural point of view because many database developers started as procedural programmers. Also, many applications use Postgres as ...
more 09:30 - 12:30 Seminole A Dev
Tuning PostgreSQL isn't as hard as you think
presented by Malcolm McLean
Out of the box PostgreSQL comes with very conservative performance settings. In this workshop, we'll look at many of the options that relate to performance and how to set them for your environment, as well as query optimization, statistics, operating system parameters and server resources.
There is no one-size-fits-all approach, but through this workshop, you'll get the fundamentals of perfo...
more 09:30 - 15:30 Seminole D Essentials
presented by PostgresConf Organizers
Tuesday Lunch - Held in the South Courtyard throughout the event
12:30 - 13:30 South Courtyard Conference Happenings
Learn predictive algorithms implementation using PostgreSQL & Apache MADlib
presented by Abbas Butt
In today’s data-driven world, Machine Learning (ML) is transforming industries from predictive analytics in finance to real-time recommendations in e-commerce.
Wouldn't it be great if the database i.e. PostgreSQL, you're already using for storing data could also be used to implement ML capabilities?
In this training participants will get familiarity with implementing popular machine l...
more 13:30 - 16:30 Seminole A Dev
presented by Yurii Rashkovskii
Join Yurii Rashkovskii for a run to kick off the day! Everyone welcome. Meet in front of the Hotel Lobby.
07:30 - 08:10 Registration Conference Happenings
presented by PostgresConf Organizers
Connect with companies working with Postgres, big and small, at Postgres Conference Orlando!
09:00 - 17:00 Exhibit Hall (Seminole Lobby) Conference Happenings
presented by PostgresConf Organizers
Registration Open throughout the event for questions and concerns
09:00 - 17:00 Registration Conference Happenings
presented by PostgresConf Organizers
Quiet space open to all who need it
09:00 - 17:00 Sun&Surf 1-2 Conference Happenings
presented by Joshua D. Drake
- Are you a Boss or a Leader?
- Are you a resource or an asset?
What do you give up by making profit the goal instead of the reward. In this keynote we will explore the very real world implications that come about from forgetting our primary needs are intentional connection, good ethics and community.
10:00 - 10:20 Seminole C (General Session Room) Professional Development
presented by Jim Mlodgenski
PostgreSQL has a rich history at Amazon from wide spread usage across the company to a number AWS offerings. In this session, we will discuss how Amazon started its journey into PostgreSQL including the mass migration off of Oracle and the origins of Amazon RDS for PostgreSQL. We will then talk about how PostgreSQL is used today throughout Amazon and the current AWS offerings including Amazon A...
more 10:30 - 10:50 Seminole C (General Session Room)
presented by Malika Boukhelifa
Reports have shown that burnout affects 48% of workers globally, and in the US alone, 52% of employees are experiencing burnout. Burnout is often considered a workplace issue; however, it also touches people outside work settings, such as caregivers and parents.
Why do we need to pay attention to burnout? Burnout has impacted employees in so many organizations that, in 2019, the World Health...
more 11:30 - 11:50 Seminole C (General Session Room) Professional Development
presented by PostgresConf Organizers
Wednesday Lunch - Held in the South Courtyard throughout the event
12:00 - 13:00 South Courtyard Conference Happenings
presented by Aaron Cutshall
Most people don’t like speaking in public, and technical folks are no exception. Yet, you’ve got some ideas for a great presentation but don’t know how to put it all together. On top of that, how do you give the presentation itself? This session will cover how to pull your material together in an organized fashion and present it such that your audience can follow along and get the message you w...
more 13:00 - 13:50 Seminole D Professional Development

presented by Billy VanCannon and Min-Hank Ho
Pgvector extends PostgreSQL capabilities to be a vector database as well as an enterprise-class relational database. But, with vector embeddings identified as a potential source of information leakage, the challenge is ensure that companies can take advantage of Postgres and pgvector while remaining compliant with increasingly stringent data security and privacy requirements, especially for Gen...
more 13:00 - 13:50 Seminole C (General Session Room) Variants and Cloud
Speedbumps when moving between platforms
presented by Rick Lowe
Recently there has been an almost exponential uptick in the number of MSSQL DBA's who are starting to operate in the Postgres world. One area of friction can be high availability and disaster recovery approaches, if for no other reason the fact that these tend to be extremely edition ($$$) dependent on the SQL Server side. Please join us for a brief review of current Postgres high availability ...
more 13:00 - 13:50 Seminole B Ops
Configuration Basics for All
presented by Greg Dostatni
Getting core parameters right is essential for ensuring good performance and stability from your PostgreSQL database. As PostgreSQL is now approaching 400 parameters that can be set in addition to OS, kernel and disk options, configuring a PostgreSQL database can be a daunting task. In this beginner friendly session, we will focus on some key parameters and discuss the trade-offs between them. ...
more 13:00 - 13:50 Seminole E Essentials
GitHub URL in, package out!
presented by Yurii Rashkovskii
Tired of waiting for extension updates to appear in your favorite package repository? Postgres.pm (pgpm) automates the entire dependencies, building, and packaging process, ensuring you can quickly get the latest releases for any environment. In this talk, we’ll explore how pgpm picks up new extension versions automatically and produces ready-to-install packages—no more manual builds, no more d...
more 13:00 - 13:50 Seminole A Dev
presented by Lloyd Albin
I have been asked many times by other PostgreSQL DBA's about what could be causing queries to run progressively slower while their application is running but then runs fast again after the application is stopped and restarted a short time later or the database is reloaded from backup and now runs fast again. These can all be symptoms of AutoVacuum/AutoAnalyze/Index issues.
Some of the slow ...
more 14:00 - 14:50 Seminole E Essentials
presented by Jose pereira
Postgres Conference 2025 Leading a High-Performing Postgres Team: Cultivating a Culture of Excellence and Growth
Abstract: As a former hostage and resilience specialist, I can attest to the value of overcoming hardship and discovering one's inner power. I will discuss how these ideas can be used in the context of Postgres and related technologies in this talk series. We will look at h...
more 14:00 - 14:50 Seminole D Professional Development

presented by Ranjan Burman and Jason Pedreza
The performance of your PostgreSQL database might be affected for multiple reasons, such as hardware (CPU, memory, disk) sources, application access pattern, suboptimal query plans, and etc. This session presents use cases of common PostgreSQL performance problems, discusses approaches and methodologies for “peeling the onion”, and identifies solutions. Use cases cover include impacts of no par...
more 14:00 - 14:50 Seminole C (General Session Room) Variants and Cloud
presented by Dr. Ibrar Ahmed
Scaling PostgreSQL is critical for handling larger workloads as your application grows. But what’s the best path: scale up or scale out? In this talk, we’ll explore both approaches, breaking down the tools, partitioning strategies, and performance considerations that make PostgreSQL shine in any scalability scenario. With insights tailored to PostgreSQL’s unique capabilities, you’ll walk away p...
more 14:00 - 14:50 Seminole B Ops
presented by Arnab Saha
Achieving high availability (HA) in database management systems is crucial for businesses to maintain continuous operation and data integrity. This blog post explores the implementation of high availability for self-managed PostgreSQL databases using Patroni, a popular open-source tool. Patroni extends PostgreSQL's capabilities by facilitating the creation and management of highly available clu...
more 15:00 - 15:50 Seminole B Opspresented by Janis Griffin
Performance tuning can be complex. It’s often hard to know which knob to turn or button to press to get the biggest performance boost. This presentation will detail five steps to identify performance issues and resolve them quickly. Attendees at this session will learn how to fine-tune a SQL statement quickly; identify performance inhibitors to help avoid future performance issues; recognize co...
more 15:00 - 15:20 Seminole E Essentials
presented by Xiaowei Jiang
Scaling PostgreSQL to meet the ever-growing demands of real-time analytics and AI workloads is a significant challenge. Traditional systems frequently hit performance bottlenecks when handling high-concurrency, low-latency queries, and writes, while also struggling with the need for seamless horizontal scalability.
Tacnode (https://tacnode.io) offers a breakthrough solution in this space by ...
more 15:00 - 15:50 Seminole C (General Session Room) Variants and Cloud
Learn the tools to help your systems run faster
presented by Grant Fritchey
You may know that your database is slow, or, you may be told that there are performance problems in the database. However, how do you know where the performance problems are? Which queries are running the slowest? Why are they running slow? This session will take you through the fundamental tools that are built right into PostgreSQL that can help you answer all these questions. We'll start with...
more 15:00 - 15:50 Seminole A Dev
presented by Michael Meskes
You’ve started your open source business or you plan to? And you don’t know what to look for for a good exit? In particular selling to a very large company is challenging. There are a lot of differences and traps you may never expect 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 shar...
more 15:00 - 15:20 Seminole D Professional Development

Evolution of parallel processing in PostgreSQL
presented by Raj Jayakrishnan and Rajeev Thottathil
In the era of big data and data-driven decision-making, the ability to process large volumes of data efficiently has become a critical requirement for modern applications. Parallel query processing in PostgreSQL allows queries to leverage multiple CPU cores concurrently, significantly enhancing query performance and reducing execution times. This parallel execution paradigm is particularly valu...
more 15:30 - 15:50 Seminole E Essentials
presented by Marguerite Clark
Create Work-Life Integration Who couldn’t use a few simple ways to become more effective while improving life balance? You will gain practical new tools and a strategy as you create a plan that moves you toward your ideal life balance. We will:
- Address your beliefs and automatic responses to life balance issues
- Uncover your ideal scenario–What works best for your life
- Ide...


Join us to learn about the strategies for building ultra-resilient distributed database architectures that seamlessly handle mission-critical business demands
presented by Amey Banarse and Alan Caldera
Cloud Service Providers have the largest infrastructure footprint in the world, spanning countries and continents. This makes it possible to build multi-Region applications that serve user requests with low latency from nearly anywhere, tolerate all sorts of possible outages including major Region-level incidents, and comply with data regulatory requirements. Join us to learn about how Yugabyte...
more 16:00 - 16:50 Seminole C (General Session Room) Variants and Cloud
Practical Tips for PostgreSQL DBAs
presented by Vibhor Kumar
While PostgreSQL 17 boasts significant advancements, some DBA-centric features remain on the horizon. This presentation delves into seven key areas where DBAs might encounter limitations and offers practical workarounds to navigate these challenges effectively. Discover how to optimize some administrative limitations and more, all while maximizing the potential of your PostgreSQL 17 environment.
16:00 - 16:50 Seminole E Essentials
Who needs Oracle when you have PostgreSQL?
presented by Shayon Sanyal
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’...
more 16:00 - 16:50 Seminole B Ops
n/a
presented by Peter Farkas
MongoDB has become a widely adopted database across industries due to its ease of use, but its shift away from open source and licensing challenges have raised concerns. Running MongoDB also demands additional resources and expertise. Is there a viable alternative? Can we seamlessly migrate MongoDB workloads to Postgres without making application-level changes? And how can MongoDB users continu...
more 16:00 - 16:20 Seminole A Dev
n/a
presented by Peter Zaitsev
In this presentation, we will explore the process of making distributed applications, such as database clusters in Kubernetes, observable. To illustrate this, we will intentionally introduce real failures into a Postgres High Availability (HA) cluster managed by the Postgres Operator for Kubernetes. We aim to understand how to detect different types of failures, evaluate whether the cluster com...
more 16:30 - 16:50 Seminole A Dev
presented by PostgresConf Organizers
Please join us for an evening of connection and community! For the first hour, we will have family friendly activities so please bring your loved ones!
17:00 - 19:40 South Courtyard Conference Happenings
presented by Yurii Rashkovskii
Join Yurii Rashkovskii for a run to kick off the day! Everyone welcome. Meet in front of the Hotel Lobby.
07:30 - 08:10 Registration Conference Happenings
presented by PostgresConf Organizers
Registration is open throughout the event for questions and concerns
09:00 - 17:00 Registration Conference Happenings
presented by PostgresConf Organizers
Connect with companies working with Postgres, big and small, at Postgres Conference Orlando!
09:00 - 17:00 South Courtyard Conference Happenings
presented by PostgresConf Organizers
09:00 - 17:00 Sun&Surf 1-2 Conference Happenings
presented by Janis Griffin
Achieving peak performance in PostgreSQL databases requires mastering the art of query tuning. Developers and DBAs often grapple with diagnosing and resolving performance bottlenecks, wasting valuable time on trial-and-error approaches. This session introduces a systematic methodology for tuning PostgreSQL queries, leveraging tools like Wait Time analysis, explain plans, and SQL diagramming. At...
more 09:30 - 10:20 Seminole A Dev

Learn about PostgreSQL end-of-life policies, and best operational practices to deal with it.
presented by Vivek Singh and Kiran Janarthan Singh
PostgreSQL End of Life (EOL) policy ensures database performance and feature improvements, but presents challenges for users navigating upgrades. Ignoring EOL deadlines can expose organizations to security vulnerabilities, performance degradation, and compliance risks. This session provides a comprehensive guide to navigating PostgreSQL upgrades with confidence. We will delve into the potential...
more 09:30 - 10:20 Seminole B Ops
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 09:30 - 10:20 Seminole D Professional Development

presented by Sameer Malik and Steve Abraham
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 clo...
more 09:30 - 10:20 Seminole E Essentials
Making postgres a OLAP system
presented by Zhou Sun
In this talk, we'll explore the various attempts to make Postgres more effective for analytics.
Early projects like Citus and Timescale added columnar storage, but lacked a strong vectorized execution engine to fully leverage it.More recent projects embed DuckDB as an execution engine within Postgres. pg_mooncake is one such attempt that intro...
more 09:30 - 09:50 Seminole C (General Session Room) Variants and Cloud
Managing 100s of PostgreSQL DBs from 100s of K8s Clusters
presented by Julian Fischer
In this talk you will learn about how to simplify PostgreSQL automation across diverse infrastructures and hundreds of Kubernetes clusters. You'll explore how Klutch provides developers with a seamless, Kubernetes-native self-service experience, while delivering centralized control and operational efficiency. Learn how Klutch addresses PostgreSQL operations from hundreds of Kubernetes clusters,...
more 10:00 - 10:20 Seminole C (General Session Room) Variants and Cloud
Your new choice for distributed analytic workloads with PG kernel
presented by Shine Zhang
If you are interested in using PostgreSQL kernel for analytics, come and join us! We are introducing Apache Cloudberry as a PostgreSQL variant to the community. It's designed based on PostgreSQL as kernel and aims to process distributed analytic workloads. Cloudberry adopts a MPP shared-nothing architecture fully integrated with PostgreSQL 14.4.
We added quite a few new features to make it ...
more 10:30 - 11:20 Seminole C (General Session Room) Variants and Cloud

Overcoming Migration Challenges: From Oracle to PostgreSQL
presented by BAJI SHAIK and Sameer Malik
Migrating from Oracle to PostgreSQL is a complex, multi-stage process that involves a variety of technologies and skills. This presentation will explore the key challenges faced during this migration, from the initial assessment to the final cutover. We will discuss critical issues such as converting SYSDATE and NUMBER datatypes, which, if not addressed correctly, can significantly impact datab...
more 10:30 - 11:20 Seminole A Dev
presented by Jonah Harris
In the world of tech, expertise is only half the battle. The real challenge lies in communicating effectively - whether it’s explaining complex systems to leadership, collaborating with cross-functional teams, or presenting insights to external stakeholders. Miscommunication can lead to missed opportunities, frustrated teams, and stalled projects. In this talk, we’ll explore the art of masterin...
more 10:30 - 10:50 Seminole D Professional DevelopmentLarge-scale synchronization that minimizes risk of data loss
presented by Rodi Reich Zilberman
Handling Change Data Capture (CDC) in PostgreSQL for large-scale synchronization presents unique challenges, particularly during the initial snapshot process. Traditional approaches can fail when the snapshot process exceeds the WAL retention period, leading to lost changes or costly resynchronizations. This issue becomes critical in high-transaction environments or with exceptionally large tab...
more 10:30 - 10:50 Seminole B Ops
Building Reliable & Scalable Data Replication Pipelines from Postgres on Kubernetes
presented by Sanketh Balakrishna
At Datadog, we built a platform for Data Replication from Postgres to various different targets over the last two years. In doing so, we enabled a lot of product teams to quickly, safely and reliably replicate data to secondary systems to solve business problems. This talk will focus on <br /> - Why we needed a platform solution for Data Replication from Postgres <br /> - Why not just 'native...
more 10:30 - 11:20 Seminole E Essentials
A practical tutorial on using Logical replication to minimize downtime while upgrading PostgreSQL
presented by Ildefonso Camargo
This live tutorial provides a practical, real-world approach to upgrading PostgreSQL using logical replication while minimizing downtime. The presenter will guide you through a step-by-step process, starting with an older PostgreSQL version (including pgBackRest backups) and culminating in a successful upgrade with minimal disruption to a sample application.
The setup will include the genera...
more 11:00 - 12:30 Seminole B Opspresented by Amanda Nystrom
This industry is no stranger to the development model. It is the lifeblood of what we do. Bug pops up, we identify it, we put together a plan to remedy the situation, we test said plan, we make adjustments, we test again, and we deploy the fix.
The insightful thing about the development model is that it can be applied to our life in many ways: from our work to our relationships to our healt...
more 11:00 - 12:30 Seminole D Professional Development
presented by Jim Mlodgenski
Want to build a generative AI application with PostgreSQL but unsure how to get started? In this talk, we will learn the essential tools for creating your own generative AI applications, including LangChain and pgvector. We will walk through some code so you can see firsthand what's required to connect these tools together. We'll do this by using a Retrieval Augmented Generation (RAG) applicati...
more 11:30 - 12:20 Seminole A Dev
presented by Tim Steward
In this presentation, we will explore the challenges that quantum computing poses to data protection. We will review the methodologies currently available in the open-source software (OSS) version and examine some of the latest techniques in the market. Our discussion will include a comparison of Disk, Filesystem, and Database encryption, highlighting the considerations for implementing each. F...
more 11:30 - 12:20 Seminole C (General Session Room) Essentials

A session to learn the fundamentals of pgvector
presented by Rajeev Thottathil and Raj Jayakrishnan
In recent years, vector search has emerged as a key tool for handling high-dimensional data, enabling applications like recommendation systems, semantic search, and AI-driven insights. pgvector is an extension for PostgreSQL that brings powerful vector search capabilities directly into the database, allowing you to store and query vector data alongside your traditional relational data.
This ...
more 11:30 - 12:20 Seminole E Essentials
presented by PostgresConf Organizers
Thursday Lunch - Held in the South Courtyard throughout the event
12:30 - 13:30 South Courtyard Conference Happenings
presented by Radhika Chakravarty
Welcome to this session on building smarter healthcare systems with Generative AI (GenAI) powered by Amazon Aurora PostgreSQL and pgvector. In this presentation, we will explore how GenAI is transforming the healthcare and life sciences (HCLS) industry by enabling advanced data analysis, personalized care, and streamlined operations. We’ll demonstrate how Aurora PostgreSQL, with its support for...
more 13:30 - 13:50 Seminole C (General Session Room) Variants and Cloud
presented by Ryan Booz
the most efficient way to process a file with 1 billion rows of data. Unsurprisingly, many database communities quickly took on the same challenge with varying results. Postgres, in many cases, performed the worst without close attention to settings and efficient resource utilization. But, with a little more effort, could it compete head-to-head?
In this session, we’ll look at the original c...
more 13:30 - 14:20 Seminole A Dev
Performing Zero Downtime Postgres Upgrades
presented by Shaun Thomas
Postgres major version upgrades are a lot of work! Before you start reaching for that handy pg_upgrade utility and accepting the inevitable downtime as part of the equation, let us describe a Better Way™. You didn’t set up an entire High Availability cluster just to shut it down for an upgrade, did you? Of course not!
Postgres 10 introduced native logical replication, and in doing so, secret...
more 13:30 - 14:20 Seminole B Ops
Crafting the Best Path to Modernize Your Database
presented by Brian Fehrle
Is your Postgres install looking more like a Woolly mammoth these days? Getting behind on version upgrades is tough, and the farther behind you get the more work may be needed to make it work, but there's many options to get it done.
This talk's goal is to help learn how to solve the "yeah but" when addressing an upgrade. "Just run pg_upgrade" - "yeah but that will take 12 hours, I only hav...
more 13:30 - 14:20 Seminole E Essentials
Why people are more important than things
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 i...
more 13:30 - 14:20 Seminole D Professional Development
presented by Savita Pandey
The proposal outlines the automation of backup management for Amazon Web Services (AWS) Relational Database Service (RDS) using Terraform, a popular Infrastructure as Code (IaC) tool. AWS RDS offers automated backup capabilities, but manual intervention, configuration, and monitoring are often required to ensure compliance with backup policies and optimize cost and performance. This project aim...
more CANCELED 14:00 - 14:20 Seminole C (General Session Room) Variants and Cloud
everything you need to know about indexes in PostgreSQL
presented by Alan Zakrzewski
There are many articles about indexing in PostgreSQL, but very few present a complete picture. This session aims to provide the audience 'everything you need to know about indexing in PostgreSQL' in less than 50min. The presentation provides an overview of different types of indexes available, differences between them and some comparison with other RDBMSs. It also includes PostgreSQL specific i...
more 14:30 - 15:20 Seminole B Ops
PostgreSQL for Data Collection and Analysis
presented by Charly Batista
Are you working with applications that generate massive data, such as IoT, Finance, or other systems that push the database to the limit? This talk aims to show you how PostgreSQL can handle your data effectively.
In such scenarios, we’ll discuss using PostgreSQL for data ingestion, storage, and processing. You’ll learn how to efficiently manage and process the large amounts of data that tho...
more 14:30 - 15:20 Seminole A Dev
With so many data types, which do you use and which should you avoid?
presented by Malcolm McLean
PostgreSQL has dozens of different data types. Some work better than others if different stations, but which do you choose for each situation? varchar or text? int or bigint? Do you ever use money?
This talk will run through each of the main data types to help understand when you should be using each of them
14:30 - 15:20 Seminole E Essentials
presented by Chirag Dave
This presentation explores the various options for running PostgreSQL on AWS, with a specific focus on open-source advanced driver technologies and their role in reducing downtime.
We will discuss the different deployment options available on AWS, including Amazon RDS for PostgreSQL, Amazon Aurora, and Aurora PostgreSQL Limitless. Additionally, we'll demonstrate how advanced drivers provide...
more 14:30 - 15:20 Seminole C (General Session Room) Variants and Cloud
Learning to present helps your career
presented by Grant Fritchey
You should know how to present a session. In fact, you should be standing up on the stage where I will be standing while presenting this session. It's not about becoming an industry expert, writing books or recording videos. No, it's about learning how to take an idea to your management team and convince them that you can help the business. It's about teaching new techniques to your peers. It's...
more 14:30 - 15:20 Seminole D Professional Development
presented by Malika Boukhelifa
It is well-documented that in the fast-paced tech industry, people often experience high stress and burnout. This results, among many other factors, from working long hours, tight deadlines, prolonged sitting, constant screen time, and a lack of clear separation between work and personal life. Burnout has been classified by the World Health Organization (WHO) as “an occupational phenomenon” res...
more 15:30 - 17:00 Seminole D Professional Development
presented by Akshat Jaimini
This talk focuses on methods and technology for using measurements acquired from various PostgreSQL monitoring tools. Succeeding pgwatch2, pgwatch3 is packed with a number of new and exciting features. One such feature is the implementation of Remote Sinks in GSoC '24, which allows users to use their database measurements across varying storage formats and processing units. Sinks can be underst...
more 15:30 - 16:20 Seminole B Ops
Using Row Level Security to move access control from the application to the database
presented by Bennie Swart
In this talk we examine the use cases of Row Level Security (RLS) and its practical application.
In traditional applications, it is very common to find a lot of access control code residing inside the application layer, where the application connects to the database with a single database user, but multiplexing multiple application users. The database user typically has more rights than the ...
more 15:30 - 16:20 Seminole A Dev
presented by Kaushik Iska
Did you know that Logical Replication has four protocol versions, each adding more features to the Postgres Logical Replication protocol, from drastically impacting performance to supporting more complex SQL commands?
In this talk, we will take a deep dive into each of these protocol versions and explore the use cases where they make sense, from the perspective of both Postgres and an extern...
more 15:30 - 16:20 Seminole E Essentials
A Practical Guide to AI-Driven Search Architectures for Postgres-Based Applications
presented by Noor Aftab
Postgres is widely used for structured data storage and querying, but with the rise of AI-driven applications, traditional search mechanisms often fall short. Vector search—critical for recommendation systems, chatbots, and AI-enhanced retrieval—has emerged as a game-changer. But when should developers extend Postgres with AI-powered search engines like FAISS and Pinecone, and when should they ...
more 15:30 - 15:50 Seminole C (General Session Room) Variants and Cloud
presented by Clay Jackson
Migrating your data architecture is more than just moving data—it's about ensuring it lands in a well-structured, optimized environment. With 90% of migrations failing due to poor planning, this session will outline a proven framework for success. Learn how proper data modeling, architecture design, and planning before migration can prevent costly failures and ensure performance, scalability, a...
more 16:00 - 16:50 Seminole C (General Session Room) Essentials
Mastering Incremental Backups in PostgreSQL 17
presented by Veenadhari Popuri
PostgreSQL 17 introduces a game-changing feature: incremental backups. This presentation provides a deep dive into this highly anticipated functionality, demonstrating how it revolutionizes database backup strategies. Topics: The Mechanics of Incremental Backups: We'll explore how pg_basebackup with the --incremental option captures only changed data blocks since the last backup, significantl...
more 16:30 - 16:50 Seminole E Essentials
presented by PostgresConf Organizers
07:00 - 15:00 Sun&Surf 1-2 Conference Happenings

presented by Yurii Rashkovskii
Join Yurii Rashkovskii for a run to kick off the day! Everyone welcome. Meet in front of the Hotel Lobby.
07:30 - 08:10 Registration Conference Happenings
presented by PostgresConf Organizers
Registration is open part of this day to answer any questions you may have and get you checked in
09:00 - 15:00 Registration Conference Happenings


Overcoming Common Pitfalls in Migrating PL/SQL Code to PostgreSQL PL/pgSQL
presented by Saiprasad Chakkera, abhinav sagar, and Premnath Jangam
In today’s rapidly evolving technology landscape, PostgreSQL has emerged as a popular choice for organizations seeking to leverage the power of open-source databases while maintaining scalability, performance, and flexibility. As enterprises migrate from proprietary database systems like Oracle to PostgreSQL, developers face the challenge of adapting existing PL/SQL codebases to PL/pgSQL. Despi...
more 09:10 - 10:00 Seminole A Dev
Unlocking the Full Potential of Your PostgreSQL Workloads on Azure
presented by Jean Joseph
In this technical presentation, we will explore the comprehensive process of migrating to Azure Database for PostgreSQL - Flexible Server. This session is designed for database administrators, cloud architects, and IT professionals who are looking to leverage the flexibility, scalability, and performance of Azure’s managed PostgreSQL service.
We will cover:
- Migration Strategies:...

Tips and Strategies
presented by Greg Dostatni
Indexes are the backbone of efficient data retrieval in PostgreSQL, but their effective use requires more than just knowing how to create them. Do you ever feel like your database is stubbornly refusing to use your carefully crafted index? Does size really matter? How much of an impact does over-indexing have?
We will kickstart by understanding how indexes work and why the database may choos...
more 09:10 - 10:00 Seminole B Ops

Deep Dive into PostgreSQL Vacuum Internals: Enhancements, Challenges, and Untold Stories
presented by Sukhpreet Bedi and Angel Duenas Neyra
Vacuum is the unsung hero of PostgreSQL, ensuring database health, reclaiming storage, and maintaining query performance. However, its internal mechanisms, recent improvements, and peculiar corner cases often remain a mystery to many users and developers. This presentation will explore the intricate workings of PostgreSQL's vacuum process, shedding light on:
- Key architectural updates in va...

presented by Debra Cerda
Remote work offers unparalleled flexibility and opportunities, but it can also present unique challenges, especially for neurodivergent individuals. From navigating sensory sensitivities and maintaining focus to managing unstructured time and avoiding burnout, working from home can feel both liberating and overwhelming.
This session is designed to empower neurodivergent professionals with pr...
more 09:10 - 10:00 Seminole D Professional Development
presented by Ryan Booz
As your database grows, the performance and maintenance of large tables can become challenging. Fear not! PostgreSQL has the right tool for the job: declarative table partitioning. This talk will discuss the benefits of partitioning in PostgreSQL, including improved performance and simplified maintenance.
After introducing the benefits of table partitioning, we’ll take a whirlwind tour throu...
more 10:10 - 11:40 Seminole E Essentials
What to Know Before Choosing Your Data Warehouse
presented by Andrew Miller
What exactly is a data warehouse, and how do you choose the right one? This session will break down the essentials, including the differences between columnar and row-based databases, and the roles of OLAP, OLTP, and HTAP. We’ll compare pricing and features for popular solutions like RedShift, Snowflake, and Postgres, while highlighting common pitfalls and key guardrails to ensure success. Whet...
more 10:10 - 11:00 Seminole A Dev
presented by Haripriya Naidu
Have you ever wondered how PostgreSQL handles concurrent reads and writes without blocking operations? Or how it minimizes deadlocks and ensures data consistency? In this session, we’ll explore Multi-Version Concurrency Control (MVCC) in PostgreSQL.
I'll explain how MVCC manages reads when there are concurrent writes to a table and how it cleans up after transactions commit. I'll also discus...
more 10:10 - 10:30 Seminole D Essentials
presented by David Mitchell
In today’s fast-paced, globally connected world, applications must be always on, always available and always highly responsive. pgEdge Distributed PostgreSQL delivers the high availability, low latency and disaster tolerance that makes this possible. This presentation will explore the core use cases that benefit from deploying distributed PostgreSQL with asynchronous logical replication in mult...
more 10:10 - 11:00 Seminole C (General Session Room) Variants and Cloud
You are only as good as your last restore
presented by Grant Fritchey
Over and over, you'll hear the need to have a plan in place for backing up your PostgreSQL databases. However, this truly has things completely backwards. The most important thing is not your ability to backup a database. Instead, your most important ability will be to restore a database. This session will explore the concepts that will enable you to create a viable restore plan for your Postgr...
more 10:10 - 11:00 Seminole B Ops
A Practical Talk About Indexing Strategies
presented by Shane Borden
In the world of relational databases, indexes are crucial for optimizing query performance. PostgreSQL, a powerful open-source database system, offers a variety of index types beyond the standard B-tree. This presentation delves into the different index types available in PostgreSQL, exploring their strengths, weaknesses, and ideal use cases.
Specifically, we will cover and show use cases fo...
more 11:10 - 12:00 Seminole B Ops
Crafting the Perfect Index for Every Query
presented by Charly Batista
Sometimes, PostgreSQL struggles with slow queries. Indexing might help, but it’s important to use the right strategies. In this talk, we’ll explore how advanced indexing can speed up your queries. We'll quickly review the B-Tree and Hash indexes, but the focus will be less common index strategies like the BRIN, GIN, and GiST indexes.
We’ll start by explaining what B-Tree, Hash, BRIN, GIN, an...
more 11:10 - 12:00 Seminole C (General Session Room) Ops
presented by PostgresConf Organizers
Friday Lunch - Held in the South Courtyard throughout the event
12:00 - 13:00 South Courtyard Conference Happenings
Creating Resilient Databases in 20 Minutes
presented by Rilwan Musa
Disasters happen, whether hacking, human mistakes, or technology failure. Maintaining business continuity as database administrators depends critically on how fast and effectively your PostgreSQL setup can recover. We'll cover the key disaster recovery techniques that every PostgreSQL professional should be aware of in this brief 20-minute talk.
Key topics include:
- Understanding Po...


presented by Billy VanCannon and Min-Hank Ho
The popularity of PostgreSQL makes it the prime candidate to be the database for a multi-tenant SaaS. But, with multi-tenancy, there are 2 fundamental issues:
- How do you make sure that the tenant’s data is isolated from each other so that a tenant’s data doesn’t get exposed to other tenants? Letting a tenant see another tenant’s data would be considered a data breach.
- How do you make ...


Exploring PostgreSQL Catalogs and Extensions
presented by Swanand kshirsagar and Viswanatha shastry Medipalli
PostgreSQL is renowned for its extensibility and robust database management capabilities, making it a preferred choice for modern applications. This session, "Beyond the Basics: Exploring PostgreSQL Catalogs and Extensions," dives deep into the advanced features that elevate PostgreSQL from a traditional relational database to a powerful platform for diverse workloads.
We will explore Po...
more 13:00 - 13:50 Seminole E Essentials

presented by Sukhpreet Bedi and Jason Pedreza
One of PostgreSQL’s most powerful functions is often unknown to many users - the Postgres implementation of “hooks” allows for safe access to core features of the database engine. While using hooks used to require a knowledge of the C programming language to leverage, Trusted Language Extensions for PostgreSQL allows for safe access to Postgres hooks via trusted Postgres languages we know and l...
more 13:00 - 13:50 Seminole A Dev

Learn about pgvector capabilities to enhance your semantic search
presented by Kiran Janarthan Singh and Vivek Singh
Dive into the cutting-edge world of semantic search with pgvector, the game-changing extension for PostgreSQL. This session explores how pgvector transforms traditional text-based queries into powerful, meaning-driven searches. Learn to harness vector embeddings to capture the essence of your data, enabling nuanced similarity comparisons and context-aware results. We'll demonstrate practical im...
more 13:30 - 14:20 Seminole D Ops

presented by Billy VanCannon and Min-Hank Ho
With the rapid adoption of cloud infrastructure and managed database services, PostgreSQL has seen a growth in popularity, in no small part, due to companies transitioning their IT systems to make use of cloud infrastructure. In the cloud is where Postgres’ enterprise-ready feature set and flexible open source licensing makes it an ideal choice as a cloud database platform or managed database ...
more 14:00 - 14:50 Seminole E Essentials
Managing metadata efficiently is critical for modern applications, and databases like PostgreSQL provide an excellent foundation. PostgreSQL is a robust, open-source database known for its powerful features, scalability, and reliability, making it ideal for metadata storage and management.
presented by Lisa Cao
Managing metadata efficiently is critical for modern applications, and databases like PostgreSQL provide an excellent foundation. PostgreSQL is a robust, open-source database known for its powerful features, scalability, and reliability, making it ideal for metadata storage and management.
Apache Gravitino complements PostgreSQL by offering advanced metadata management capabilities. Leveragi...
more 14:00 - 14:50 Seminole B Ops

presented by Ranjan Burman and Anita Singh
Discover how to enhance your PostgreSQL database with powerful catalogs and extensions. Explore their essential roles in database management, from data organization and querying to advanced features like full-text search and geospatial analysis. Uncover how these tools can supercharge your database performance and capabilities.
14:00 - 14:50 Seminole A Dev