Re: Perfomance decreasing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Perfomance decreasing
Дата
Msg-id 17530.997800195@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Perfomance decreasing  (Erwin Lansing <pgsql@droso.net>)
Ответы Re[2]: Perfomance decreasing  (Alexander Loginov <sas@mplik.ru>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: Is the bug system active?
Следующее
От: "Richard Huxton"
Дата:
Сообщение: OT: Warning about errors in ZDNET article