Subscribe to the
Percona Newsletter

Subscribe Now!
  Wednesday, June 19, 2019    Ibrar Ahmed

A Deep Dive Into PostgreSQL Indexing

Please join Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his talk "A Deep Dive Into PostgreSQL Indexing" on Wednesday, June 19th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4).

Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To fully take advantage of these, users need to understand the basic concept of indexes, and to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index strategy and design.

One thing is for sure: not all indexes are appropriate for all circumstances, and using a “wrong” index can have the opposite effect to that you intend, and problems might only surface once in production. Armed with more advanced knowledge, you can avoid this worst case scenario!

We'll take a look at how to use pg_stat_statment to find opportunities for adding indexes to your database. We'll look at when to add an index, and when adding an index is unlikely to result in a good solution. So should you add an index to every column? Come and discover why this strategy is rarely recommended as we take a deep dive into PostgreSQL indexing.


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.