Schedule - PGConf.EU 2013

PostgreSQL indexing

Date: 2013-10-29
Time: 09:00–17:00
Room: Dodder
Level: Intermediate

Indexing is a core feature of every database system and it is essential to speed up queries. However, indexing is a lot more than just looking up a value in a binary tree. PostgreSQL provides various types of indexes offering you a variety of additional functionality such as full text indexing, fault tolerant text search or geometric search.

During this course you will learn how to make full use of PostgreSQL indexing and you will get to know indexing strategies tailored to your needs (via PostgreSQL operator classes, etc.) In addition to that you will find out, when the optimizer decides to use an index and in which cases it is wise, not to use an index.

Topics:

  • Types of indexes (btree, gist, gin, hash, sp-gist)
  • Binary search via btree
  • Bitmap scans
  • The PostgreSQL cost model and indexing
  • Functional indexes
  • Indexing LIKE and regular expressions
  • Using operator classes (btree_gist, pg_trgm, etc.)
  • Full text search
  • A hand-tailored indexing strategy

Speaker

Hans-Jürgen Schönig

Platinum Sponsors

2ndQuadrant
EnterpriseDB

Gold Sponsors

Cybertec
Heroku

Silver Sponsors

Dalibo
Gilt
VMware
Zalando
EngineYard
Servoy
Vertabelo