On: Using Schema-less in Django with Postgres

[fdr]

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.