News for hackers. Stuff that matters.
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.
Re:Running 10M PostgreSQL Indexes in Production by netcraft on Tuesday June 13, 2017 @03:27PM (#14547822)
excellent - thanks for the information!