Rules of indexing in PostgreSQL
Presented by:
Alan Zakrzewski
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.
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