Message-ID: <4697B8C7.7030304@jobflash.com>
Date: Fri, 13 Jul 2007 10:39:19 -0700
From: Tom Arthurs <tarthurs@jobflash.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
To: smiley2211 <smiley2211@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Database Statistics???
References: <11583450.post@talk.nabble.com>
In-Reply-To: <11583450.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

smiley2211 wrote:
> Hello all,
>
> I am a bit confused...I have a database which was performing very POORLY
> selecting from a view (posted earlier) on one server but extremely fast on
> another server...
>
> I just backed up the database from the FAST server and loaded to the SLOW
> server and it ran just as fast as it originally did...my questions are:
>
> Are STATISTICS some how saved with the database??  if so, how do I UPDATE
> view or update them?
>
> Should I backup the data \ drop the database and reload it to make it get
> new stats?? (vacuum analyze does nothing for this poor performing database)
>
> Thanks-a-bunch.
>   
You can update statistics with the analyze or vacuum analyze command, 
but I'd bet what you are seeing here is the effect of recreating the 
indices that replaying a backup does.