A partial index is an index built over a subset of a table; This is database technique possible in PostgreSQL