Julien Rouhaud
Julien is a PostgreSQL Major Contributor. He has been working with PostgreSQL since verson 8.3, as a software engineer and a DBA. He's also the author of other open source projects such as PoWA (real-time tuning) and HypoPG (hypothetical indexes).
He’s also a former -treasurer of the PostgreSQL Europe association.
Session
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.