Oleg,
> I declared all the indexes that you suggested and ran vacuum full
> analyze. The query plan has not changed and it's still trying to use
> seqscan. I tried to disable seqscan, but the plan didn't change. Any
> other suggestions?
> I started explain analyze on the query, but I doubt it will finish any
> time soon.
Can I get a copy of the database so that I can tinker? I'm curious now, plus
I want our benchmarks to look good.
I have a private FTP if that helps.
--
Josh Berkus
Aglio Database Solutions
San Francisco