News for hackers. Stuff that matters.
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'

There are no comments on this comment yet.