Schedule - PGConf.DE 2015

Back

Indexes of PostgreSQL

Date: 2015-11-27
Time: 13:25–14:10
Room: Reeper
Level: Intermediate

I would like to talk about

  • index types, hash, btree, GiST, SP-GiST, GIN, BRIN
  • how they got used in the queries
  • CREATE INDEX, DROP INDEX, REINDEX statements
  • unique keys and exclusion constraints
  • multi-column indexes
  • indexing function outputs
  • indexing complicated datatypes like arrays, ranges, IP addresses, geometric types, hstore, ltree, JSONB
  • pg_trgm, unaccent extensions

Speaker

Emre Hasegeli