Partial Indexes in Postgres
Partial Index is one of the hidden and not very widely used feature of Postgres. It allows us to index a subset of data. That’s a sweet one line description of what it is. Let’s walk through an example to understand when we should use partial indexes.