Conference Schedule - PGConf.DE 2015

Back

Indexes of PostgreSQL

Date: Nov. 27, 2015
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

Privacy Policy | About the website
Copyright © 2008-2017 PostgreSQL Europe