Time: 09:15 - 10:05
PostgreSQL has a huge range of possible index types above the traditional B-Tree: GiST, GIN, SP-GiST, BRIN, Hash… and some that aren't even part of the core.
When do you use them? What are they good for? How well do they perform? This talk goes over the collection of exotic animals that is PostgreSQL's indexes, along with how to use them properly.