In PostgreSQL, indexing is a large field and covers many aspects of database work. As I have outlined in this book already, indexing is the key to performance. There is no good performance without proper indexing. Therefore, it is worth inspecting the indexing-related features that we will cover in the following subtopics in detail.
Understanding additional B-tree features
Combined indexes
In my job, as a professional PostgreSQL support vendor, I am often asked about the difference between combined and individual indexes. In this section, I will try to shed some light on this question.
The general rule is that if a single index can answer your question, it is usually the best choice. However, you cannot index all possible...
