Postgres Pro
Downloads
Home   >   mailing lists

Re: "Mysterious" issues with newly installed 8.3 - Mailing list pgsql-performance

From Greg Smith
Subject Re: "Mysterious" issues with newly installed 8.3
Date
Msg-id Pine.GSO.4.64.0810100341140.26609@westnet.com
Whole thread Raw
In response to Re: "Mysterious" issues with newly installed 8.3  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
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@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: "Mysterious" issues with newly installed 8.3
Next
From: Greg Smith
Date:
Subject: Re: "Mysterious" issues with newly installed 8.3