3 ms·

Does the predicate in your queries have to match the index exactly or can you add more conditions and have it still use the index? (assuming AND not OR)

• malisper 9y ago
  You can add more conditions and Postgres will use the index to first find the rows that match the partial index condition and then use the additional condition to postfilter the rows.
  • netcraft 9y ago
    excellent - thanks for the information!