PostgreSQL provides a wide range of index types - from the traditional index types like btree or hash indexes, full-text gin indexes, to less known types like brin, gist etc. In this talk I'd like to present a brief overview of the index types, along with some unique and handy features and main improvements in recent PostgreSQL versions.
