PostgreSQL indexing explained — 5 index types and when to use each

Indexes are one of those things that everybody knows they should use, but few people actually...