Deep Dive into PostgreSQL Indexing

Logo
Presented by

Ibrar Ahmed, Senior Software Architect at Percona

About this talk

ndexes 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
Related topics:

More from this channel

Upcoming talks (0)
On-demand talks (60)
Subscribers (6410)
Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona provides single-source expertise in multi-vendor environments that eliminates lock-in, increases agility and enables business growth.