Comment Comment by giovannibonetti Partial indexes solve exactly this problem. You add a WHERE condition that restricts the index to a subset of the whole table. parent giovannibonetti 3 years ago