Register

presented by Debra Cerda, Greg Dostatni, and James Campbell

Looking for practical database support without the cost? Group Swim: PostgreSQL Edition is your chance to wade in with real-time feedback from Postgres experts. Whether you’re troubleshooting an issue, testing new ideas, or just want to hear how others are approaching PostgreSQL, this is your opportunity to check that you have the right life preservers and start building master-level strokes. September we will focus on backups!

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 have 15 minutes!"

We will go over high level things that you need to know to do a very large version jump, such as version 9.6 to 17, and the questions that must be asked to ensure the best path is taken. Have a small database with few users? Easy! A giant database with 99.99% up-time guarantee and millions of active users? Buckle up.

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 choose to ignore them. We will explore why partial indexes may be more efficient under some specific scenarios. We will also delve into more advanced techniques, like indexing on md5 value, sorting and the impact of choosing the correct data type.

Finally, no discussion of indexing would be complete without addressing the long-term health of your indexes. We’ll cover index bloat, routine maintenance, and how to check if your indexes are lean and efficient.

Whether you’re looking to optimize your existing indexes or explore cutting-edge strategies, this session will equip you with the knowledge and tools to take full advantage of PostgreSQL indexing capabilities.

presented by Debra Cerda, Greg Dostatni, and James Campbell

Looking for practical database support without the cost? Group Swim: PostgreSQL Edition is your chance to wade in with real-time feedback from Postgres experts. Whether you’re troubleshooting an issue, testing new ideas, or just want to hear how others are approaching PostgreSQL, this is your opportunity to check that you have the right life preservers and start building master-level strokes.

This month we focus on upgrade planning and end of year changes.

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 prepared to scale your database infrastructure intelligently

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 this session, learn what can improve or destroy team effectiveness and what you can do about it.