2025 Postgres World Webinar Series Program

presented by Vivek Singh

As PostgreSQL major versions reach End of Life annually, database administrators face critical upgrade decisions. This session provides a comprehensive guide to navigating PostgreSQL end-of-life scenarios and executing seamless upgrades. We'll explore proven strategies, best practices, and techniques for minimizing downtime during transitions for community PostgreSQL as well as Amazon Aurora an...

presented by Greg Dostatni and Kevin Jernigan

When choosing between Open Source Software (OSS) and Closed Source Software (CSS), organizations must consider factors like support, customization, security, compliance and long term cost. OSS provides flexibility and cost advantages, but may require internal expertise for maintenance and development or creative problem solving when navigating non-traditional support structures. CSS offers trad...

presented by Chandra Pathivada

This workshop is designed for SQL Server developers looking to expand their expertise to PostgreSQL. Discover the key differences and similarities between the two platforms, including query syntax, data types, indexing, partitioning, and performance tuning. Learn how to map SQL Server concepts like filegroups, stored procedures, and functions to PostgreSQL equivalents, and gain hands-on experie...

presented by Susan Fung

Join us for an engaging and humorous journey into the world of mob programming. In this talk, we'll explore how a seemingly simple task turned into a four-month odyssey for Homero, a software developer looking for a simple ticket. Discover how his solo struggle with a two-line code change blossomed into a team-wide learning experience.

Through the power of mob programming, our team transform...

presented by Aaron Cutshall

Most people don’t like to speak in public and technical folks are certainly no exception. Yet, you’ve got some ideas for a great presentation but just don’t know how to go about putting it all together. On top of that, how do you go about giving the presentation itself? This session will cover how to pull your material together in an organized fashion and present it such that your audience (bot...

presented by Chandra Pathivada

Discover the truth about PostgreSQL by questioning everything you thought you knew! In this interactive session, we use the Socratic method to explore the internals of PostgreSQL, encouraging critical thinking and helping you uncover underlying assumptions and knowledge gaps. Through thought-provoking questions and dynamic discussions, we will challenge common myths and misconceptions about Pos...

presented by Aaron Cutshall

Determining how to efficient design database structures for a given application has always relied on the same old answer: “It depends!” So, how do you determine what level of normalization your data requires? This session will review the principles of data normalization, show the impact that normalization can have on performance and data integrity, and just as importantly, show you when it’s OK...

presented by Aaron Cutshall

Teamwork is important in all areas, including development, QA or other teams that we interact with daily. Lessons learned from highly effective teams show that there are six major impacts to team effectiveness: chain of command, team cohesion, standard operating procedures, training, mission objectives and after action analysis. A failure in any of these areas can impact team effectiveness. In ...