Index best practice and hypothetical indexes in PostgreSQL

Covering indexes, partial indexes, access methods, operator classes, Index-only scans... Indexes in PostgreSQL are extensible and have a lot of features, so it's not always easy to know how to best use them or when not to use them.

In this talk we will cover multiple areas of indexing, giving example scenario example and best practice to highlight their use cases, and general improvements around indexes in the recent releases.

We will also cover some extensions around indexing, including hypopg that allows you to create hypothetical indexes to help you decide whether an index should be created or not, and other external tools to detect various problems around indexes.