Emre Hasegeli
System Administrator at InnoGames

June 28, 2016

English Track - Day 1

Starts at 3:15 pm – INDEXES in PostgreSQL – Leonardo Room

  45 minutes
  intermediate

Emre Hasegeli will discuss the following topics:

  • 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

Here you will find the slides from the talk INDEXES in PostgreSQL.