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.
Can we see EXPLAIN ANALYZE instead of just EXPLAIN output for the queries on the two servers? Also, can you try CLUSTER on the tables involved instead of VACUUM FULL, to avoid introducing index bloat? Josh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
