Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group