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

Re: Database Statistics???

From: smiley2211 <smiley2211(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Database Statistics???
Date: 2007-07-13 18:27:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Thanks Tom and Scott...that worked for a NEW database but not on the original
SLOW database...meaning - I backed up the SLOW database and restored it to a
NEW database and the query ran EXTREMELY FAST :clap:

Scott - (your question - What was the size of the slow databases data store
compared to the
fast database? --- I am new, how do I know the size of the database (OS file
size ??)) there an sp_helpdb equivalent command??

My EXPLAINS are under a previous thread:

Query is taking 5 HOURS to Complete on 8.1 version


Tom Arthurs wrote:
> 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 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.
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?

View this message in context:
Sent from the PostgreSQL - performance mailing list archive at

In response to


pgsql-performance by date

Next:From: Pavel StehuleDate: 2007-07-13 19:12:34
Previous:From: Mario WeilguniDate: 2007-07-13 18:19:51
Subject: Re: Database Statistics???

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