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.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general