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

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

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

presented by PostgresConf Organizers

Tuesday Lunch - Held in the South Courtyard throughout the event

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

presented by Yurii Rashkovskii

Join Yurii Rashkovskii for a run to kick off the day! Everyone welcome. Meet in front of the Hotel Lobby.

presented by PostgresConf Organizers

Connect with companies working with Postgres, big and small, at Postgres Conference Orlando!

presented by PostgresConf Organizers

Registration Open throughout the event for questions and concerns

presented by PostgresConf Organizers

Quiet space open to all who need it

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.

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

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

presented by PostgresConf Organizers

Wednesday Lunch - Held in the South Courtyard throughout the event

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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!

presented by Yurii Rashkovskii

Join Yurii Rashkovskii for a run to kick off the day! Everyone welcome. Meet in front of the Hotel Lobby.

presented by PostgresConf Organizers

Registration is open throughout the event for questions and concerns

presented by PostgresConf Organizers

Connect with companies working with Postgres, big and small, at Postgres Conference Orlando!

presented by PostgresConf Organizers

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

presented by PostgresConf Organizers

Thursday Lunch - Held in the South Courtyard throughout the event

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

presented by PostgresConf Organizers

presented by Yurii Rashkovskii

Join Yurii Rashkovskii for a run to kick off the day! Everyone welcome. Meet in front of the Hotel Lobby.

presented by PostgresConf Organizers

Registration is open part of this day to answer any questions you may have and get you checked in

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

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

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

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

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

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

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

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

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

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

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

presented by PostgresConf Organizers

Friday Lunch - Held in the South Courtyard throughout the event

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:

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

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

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

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

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

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

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.