Perfomance decreasing

Alexander Loginov <sas@mplik.ru>

From: Alexander Loginov <sas@mplik.ru>
To: pgsql-general@postgresql.org
Date: 2001-08-14T08:06:40Z
Lists: 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