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.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
