Deep Dive into PostgreSQL Indexing

Indexes are a fundamental feature of relational databases and PostgreSQL offers developers and designers a rich collection of options. But not all indexes are appropriate for all circumstances. Using a ‘wrong’ index can have the opposite effect to what you intend, and problems might only surface once in production.

Armed with more advanced knowledge, you can avoid this worst-case scenario!

Join Ibrar Ahmed, Senior Software Architect at Percona for this technical session as he takes a deep dive into indexing to show you:

  • How to compare index types and apply them to different application scenarios
  • How to use pg_stat_statment to find opportunities for adding indexes to your database
  • Best practices for database index strategy and design

About the Author

Ibrar Ahmed

Ibrar Ahmed joined Percona LLC in the month of July 2018. Before joining Percona, Ibrar worked as a Senior Database Architect at EnterpriseDB for 10 Years. Ibrar has 18 years of software development experience. Ibrar authored multiple books on PostgreSQL.

Subscribe to the
Percona Newsletter

Subscribe Now!

From August 2, 2021, you will no longer be able to purchase Percona’s market-leading database Support as a per month/per server subscription through the online store. For guidance on Percona Support options, including how much you can save with an annual contract, please contact us directly.

Far
Enough.

Said no pioneer ever.
MySQL, PostgreSQL, InnoDB, MariaDB, MongoDB and Kubernetes are trademarks for their respective owners.
© 2026 Percona All Rights Reserved