On Monday, January 21, 2013, Tim Uckun wrote: > 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 > >