Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Дата
Msg-id 20050613205045.GB1346@wolff.to
обсуждение исходный текст
Ответ на PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps  (Együd Csaba <csegyud@vnet.hu>)
Список pgsql-general
On Mon, Jun 13, 2005 at 22:27:31 +0200,
  Együd Csaba <csegyud@vnet.hu> wrote:
>
> The critical tables are vacuum analyzed in every hour. (Not vacuum full
> because of the several minutes long exclusive lock)
>
> Earlier the system had been running for 3 months without problems, but a few
> weeks ago suddenly it got slower and slower. By now I have to vacuum full
> analyze the whole database almost every day to achieve the requested
> performance.
>
> The operating system is a Win2k adv. server, on a HP NetServer LC2000
> (2xPIII1GHz + 2x36GB SCSI RAID1; 1GB RAM)
>
> I know that Windows is blame... etc., but what about that 3 months perfect
> runtime?
>
> What could cause this issue?

Is your FSM setting high enough?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Index problem