An overview of the types of indexes available in PostgreSQL, and the different ways of using and maintaining the most common index type: B-Trees.