PgSaturday: Dallas 2025 Program

2025-04-05
09:10
PostgresConf Organizers PgSaturday Dallas Launch!

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
09:40
Luciano Moreira Azure PostgreSQL Flexible Server
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
10:40
Raj Jayakrishnan Exploring Multi-Tenant Architectures in PostgreSQL: Scalable Solutions for SaaS Applications
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
11:10
Merlin Moncure Just use postgres: why I built an enterprise scheduler in a stored procedure
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...

more

11:10 - 12:00 73 Dev
12:10
Veenadhari Popuri Revolutionizing Backups

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
14:00
Vivek Singh PostgreSQL 17 & 18: The Ground-Breaking Features You Can't Ignore
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
15:00
Chandra Pathivada Why PostgreSQL Isn't Utilizing Indexes: Diagnosing and Solving Performance Issues
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
16:00
 Shubham Gupta Pub/Sub for Tables: A New Approach to PostgreSQL Data Integration

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
16:30
Minesh Chande Seamless Transition: Migrating from Commercial to Open Source Databases

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