Re: performance problems ... 100 cpu utilization

Поиск
Список
Период
Сортировка
От Dennis
Тема Re: performance problems ... 100 cpu utilization
Дата
Msg-id 42D7DE40.3070507@works4me.com
обсуждение исходный текст
Ответ на Re: performance problems ... 100 cpu utilization  (David Mitchell <david.mitchell@telogis.com>)
Список pgsql-performance
David Mitchell wrote:

> If your table has got into this state, then vacuum analyze won't fix
> it. You will have to do a vacuum full to get it back to normal, then
> regularly vacuum (not full) to keep it in good condition. We vacuum
> our critical tables every 10 minutes to keep them in good nick.


So should I have vacuum run during the load test? At what level of
updates should it run every ten minutes?

Dennis

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

Предыдущее
От: Dan Harris
Дата:
Сообщение: Re: slow joining very large table to smaller ones
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: slow joining very large table to smaller ones