Re: "Mysterious" issues with newly installed 8.3

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: Scott Carey <scott(at)richrelevance(dot)com>, Carlos Moreno <morenopg(at)mochima(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: "Mysterious" issues with newly installed 8.3
Date: 2008-10-10 07:44:36
Message-ID: Pine.GSO.4.64.0810100341140.26609@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-10-10 08:22:35 Re: "Mysterious" issues with newly installed 8.3
Previous Message Scott Marlowe 2008-10-10 03:17:00 Re: "Mysterious" issues with newly installed 8.3