On Thu, 9 Oct 2008, Craig James wrote:
Did you do an ANALYZE on the new database after you cloned it?
He ran "vacuumdb -f -z", the -z does an analyze. Also, he's getting nearly identical explain plans out of the two systems, which suggests the stats are similar enough in the two cases.
-- * Greg Smith [EMAIL PROTECTED] http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
