Register

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.