PgSaturday: Dallas 2025 Program

presented by PostgresConf Organizers
Welcome to the first ever PgSaturday Dallas! We look forward to this event, engaging with everyone here and thank you for helping us continue to build this community. We are hoping to continue to build this event annually to become a regional conference. Please let us know if you have any questions or feedback. Let's enjoy the day and this wonderful venue.
09:10 - 09:30 73 Ops
Service overview and migration
presented by Luciano Moreira
In this session we will explore Azure PostgreSQL Flexible Server, covering key features that make this service a robust choice for modern applications, including its high availability, read-replicas, automated backups, security, autonomous and AI-enabled. Attendees will gain insights into the migration process from on-premises or other cloud databases to Azure PostgreSQL Flexible Server, leve...
more 09:40 - 10:30 73 Ops
Multi-tenancy with PostgreSQL databases
presented by Raj Jayakrishnan
Tenant isolation, resource sharing, security, and performance are critical in designing multi-tenant database architectures. SaaS providers leverage these architectures to consolidate databases, enhancing agility, scalability, operational efficiency, and cost optimization. In this session, we will explore the options of running multi-tenant application in Postgres and also the multiple ways in ...
more 10:40 - 11:00 73 Ops
Become a disciple for the radical simplicity movement
presented by Merlin Moncure
A summary of why modern development has become too complex, and why stored procedure development is the most efficient way to tackle data facing problems. This has led me to write an enterprise orchestrator in stored procedure that has exceeded all expectations.
You will be given an introduction into the Radical Simplicity movement, and an overview of the challenges that you might face depl...

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, significantly ...
more 12:10 - 12:30 73 Ops
Unleashing Next-Gen Database Innovation: A Deep Dive into PostgreSQL's Revolutionary 17 & 18 Releases
presented by Vivek Singh
PostgreSQL 17 and 18 represent significant milestones in the evolution of this robust open-source database system. PostgreSQL 17 introduces groundbreaking features including MERGE command enhancements, improved logical replication performance, and advanced row-level security capabilities. Notable additions include the implementation of SQL/JSON constructors, parallel query improvements, and enh...
more 14:00 - 14:50 73 Ops
Uncovering Hidden Bottlenecks: Optimize Queries and Boost Index Efficiency
presented by Chandra Pathivada
In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ulti...
more 15:00 - 15:50 73 Ops
presented by Shubham Gupta
PostgreSQL is a cornerstone of modern enterprise data architectures, but integrating its data with the broader organization remains a challenge. Traditional ETL and data pipeline solutions are expensive, complex, and introduce significant system overhead. In this session, we introduce Tabsdata, a novel approach that enables a Pub/Sub for Tables architecture, thus allowing PostgreSQL data to be ...
more 16:00 - 16:20 73 Ops
presented by Minesh Chande
Migrating from legacy SQL Server databases is time consuming and resource intensive. Babelfish extends your Amazon Aurora PostgreSQL-Compatible Edition database with the ability to accept database connections from SQL Server clients. Join this session to learn how SQL Server applications work directly with Aurora PostgreSQL with few to no code changes compared to traditional migration and witho...
more 16:30 - 17:20 73 Ops