Thanks for the advice. I will keep playing with it. Can someone here comment on EnterpriseDB or another companies paid support? I may consider this to quickly improve my performance. Scott Marlowe wrote:
Have you run analyze on the tables? bumped up default stats and re-run analyze? Best way to send query plans is as attachments btw.