PostgreSQL for MySQL DBAs Episode 11: A Survey of Indexes

First, a big thanks for the kind responses to this series, and, as requested, here is an overview of index types available in PostgreSQL. The supporting video with bonus material can be found...