Schedule - PGConf.EU 2017
PostgreSQL indexing
Date: 2017-10-24
Time: 09:00–17:00
Room: Sawa
Level: Intermediate
Indexing is the key topic when it comes to performance and tuning in general. A missing indexes can easily and single handedly destroy performance. Therefore keeping an eye on indexing is essential. PostgreSQL supports various kinds of indexes, which can help to speed up various operations. During this training you will learn, how to use indexes properly. Here is the content:
- Spotting missing indexes
- Understanding how indexes work
- How the optimizer treats indexes
- Understanding various index types
- Detecting unnecessary indexes
- Writing your own operator classes
- Fuzzy searching and full text search
