Underreported but very useful are the omnibus GIN/GiST indexes for hstores, which let you index all the fields at once, not unlike the Postgres Full Text Search

Underreported but very useful are the omnibus GIN/GiST indexes for hstores, which let you index all the fields at once, not unlike the Postgres Full Text Search feature: http://www.postgresql.org/docs/9.1/static/hstore.html#AEN133526 http://www.postgresql.org/docs/9.1/static/hstore.html#AEN133... It's more expensive to update than a more selective index, of course, but for the ultimate in "do what I mean" optimization, this is it. Unfortunately, I don't know if ORMs generate the right kind of SQL to use those indexes, yet, but I don't see why they couldn't.