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

There are no comments on this comment yet.