Presented by:

2993894688456074b1946f39c32ac618

Alan Zakrzewski

ServiceNow

Database Engineer with 13 years of experience in databases and cloud technologies. GCP architecting, database design and implementation, query tuning, database performance, database administration and strong SQL skills. GCP, OCP, PTCE, OCE and AWS certified. Ex-Google, ex-Oracle.

No video of the event yet, sorry!
Download the Slides

There are many articles about indexing in PostgreSQL, but very few present a complete picture. This session aims to provide the audience 'everything you need to know about indexing in PostgreSQL' in less than 50min. The presentation provides an overview of different types of indexes available, differences between them and some comparison with other RDBMSs. It also includes PostgreSQL specific indexes: functional, partial, include. The key point of the session is 'Indexing for query tuning' - presenting an easy to understand & optimal way to utilize B*Tree indexing for query tuning, with examples for each part.

Date:
Duration:
50 min
Room:
Conference:
Postgres Conference 2025
Language:
Track:
Ops
Difficulty:
Medium