Database Statistics??? - Mailing list pgsql-performance

From smiley2211
Subject Database Statistics???
Date
Msg-id 11583450.post@talk.nabble.com
Whole thread Raw
Responses Re: Database Statistics???
Re: Database Statistics???
Re: Database Statistics???
List pgsql-performance
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.
--
View this message in context: http://www.nabble.com/Database-Statistics----tf4075655.html#a11583450
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: TRUNCATE TABLE
Next
From: "Jim C. Nasby"
Date:
Subject: Re: TRUNCATE TABLE