| From: | Alexander Loginov <sas(at)mplik(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Perfomance decreasing |
| Date: | 2001-08-14 08:06:40 |
| Message-ID: | 762179884.20010814140640@mplik.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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(at)mplik(dot)ru
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SMJ | 2001-08-14 08:15:50 | Printable report generation |
| Previous Message | Fariba Noorbakhsh | 2001-08-14 07:49:51 | Re: delete columns from table! |