Database Statistics???
От | smiley2211 |
---|---|
Тема | Database Statistics??? |
Дата | |
Msg-id | 11583450.post@talk.nabble.com обсуждение исходный текст |
Ответы |
Re: Database Statistics???
Re: Database Statistics??? Re: Database Statistics??? |
Список | 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 по дате отправления: