On Fri, May 14, 2010 at 1:28 PM, <Keaton_Adams@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
