Perfomance decreasing

Поиск
Список
Период
Сортировка
От Alexander Loginov
Тема Perfomance decreasing
Дата
Msg-id 762179884.20010814140640@mplik.ru
обсуждение исходный текст
Ответы Re: Perfomance decreasing  (Erwin Lansing <erwin@lansing.dk>)
Список 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 по дате отправления:

Предыдущее
От: Fariba Noorbakhsh
Дата:
Сообщение: Re: delete columns from table!
Следующее
От: Jeff Davis
Дата:
Сообщение: PostgreSQL library functions