Re:Speeding Up PostgreSQL with Partial Indexes
by jasonl99 on Wednesday December 10, 2014 @02:56PM
(#8731298)
How about a multiple column AND partial index? (that may have been what you are suggesting). Best of both worlds? I just tried it, and it does work (at least on 9.4). Here's an extremely contrived example with a rails 'users' table
create index test_index on users (name, email) where name > 'A' and email > 'B'
create index test_index on users (name, email) where name > 'A' and email > 'B'