I already posted the schema earlier. It's a handful of integer fields
with one hstore field.
one hstore field can easily be equivalent to 50 text fields with an index on each one.
I'm pretty sure that that is your bottleneck.
what does \di+ show?
Cheers,
Jeff
