From: | smiley2211 <smiley2211(at)yahoo(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Database Statistics??? |
Date: | 2007-07-13 16:53:29 |
Message-ID: | 11583450.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2007-07-13 17:12:47 | Re: TRUNCATE TABLE |
Previous Message | Tom Lane | 2007-07-13 16:30:46 | Re: TRUNCATE TABLE |