Presented by:

8e0aeb831f3ff746493d2265f1d72b2e

Greg Dostatni

Command Prompt

Greg is an experienced IT professional with over 20 years of experience in higher education. Starting as a developer, he worked on software to manage Search and Rescue incidents ans urban crowd movement simulations. He has a background as a DBA / System Administrator working with Oracle and PostgreSQL in Solaris and Linux. Greg has later transitioned into building and managing applications and services for a large university in Canada, including designing developing and managing large shared database environments. Greg is committed to using technology to solve problems both at home and in professional setting.

No video of the event yet, sorry!

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.

Date:
2025 March 21 09:30 EDT
Duration:
50 min
Room:
Space Coast 1&2
Conference:
Postgres Conference 2025
Language:
Track:
Ops
Difficulty:
Medium