News for hackers. Stuff that matters.

A comment on Running 10M PostgreSQL Indexes in Production. Parent comment

Re:Running 10M PostgreSQL Indexes in Production by netcraft on Tuesday June 13, 2017 @10:03AM (#14544728)
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)
[ Parent | on HN ]
Re:Running 10M PostgreSQL Indexes in Production by malisper on Tuesday June 13, 2017 @02:45PM (#14547437)
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.
[ Parent | on HN ]
Re:Running 10M PostgreSQL Indexes in Production by netcraft on Tuesday June 13, 2017 @03:27PM (#14547822)
excellent - thanks for the information!
[ Parent | on HN ]