Re: Perfomance decreasing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Perfomance decreasing
Date: 2001-08-14 14:43:15
Message-ID: 17530.997800195@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> 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.

It sounds to me like you may be running into index growth problems.
VACUUM is presently not good about shrinking indexes. If you drop
and recreate the indexes used by your most important queries, does
the performance go back to where it was?

>> Why this situation occures? May be I must use "VACUUM ANALYSE"
>> instead of VACUUM?

Occasional VACUUM ANALYZEs are a good idea.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-08-14 14:49:36 OT: Warning about errors in ZDNET article
Previous Message Craig Longman 2001-08-14 14:42:53 cmd-line interface