On Fri, May 14, 2010 at 1:28 PM, <keaton_ad...@mcafee.com> wrote: > I did run an ANALYZE, then vacuum full, then another ANALYZE on all tables > involved in the query. That didn't change things. I compared QUERY TUNING > settings in both postgresql.conf files and they are identical. There is a > difference in row counts in each table between the databases, but not by much. >
What's your default_statistics_target value? ie, run "select default_statistics_target;" Try setting it to 100 if it is not already, re-run analyze, then try the queries. The statistics may just be different. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
