PostgreSQL index with a WHERE predicate that restricts which rows are indexed, making the index smaller and faster. If the query's WHERE mirrors the index's predicate, the planner can prefer the partial index over a full one.