Perfomance decreasing
От | Alexander Loginov |
---|---|
Тема | Perfomance decreasing |
Дата | |
Msg-id | 762179884.20010814140640@mplik.ru обсуждение исходный текст |
Ответы |
Re: Perfomance decreasing
|
Список | pgsql-general |
Hello. I have a question about perfomance. I'm running PostgreSQL 7.1.2 at FreeBSD 4.3. For the first 1-2 days of running perfomance is excellent. But after that, speed began to decrease. And after a week of operation, perfomance falls 8-10 times, than at first day of using. I'm doing vacuum periodically (once a hour), but perfomance still falls down. After that I dump database as text file, make dropdb & createdb and after that, restore database from dump -> Perfomance is excellent again (for 1-2 days). Why this situation occures? May be I must use "VACUUM ANALYSE" instead of VACUUM? Best regards, Alexander mailto:sas@mplik.ru
В списке pgsql-general по дате отправления: