This site is about a previous instance of this event. For the current event, please see the updated site.

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


Hans-Jürgen Schönig