Re:Using Schema-less in Django with Postgres
by fdr on Thursday June 14, 2012 @04:24PM
(#4113344)
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#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.