Re: [PERFORM] autovacuum on a -mostly- r/o table

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: [PERFORM] autovacuum on a -mostly- r/o table
Дата
Msg-id 1159374712.46586.47.camel@home
обсуждение исходный текст
Ответ на autovacuum on a -mostly- r/o table  (Edoardo Ceccarelli <eddy@axa.it>)
Список pgsql-admin
On Wed, 2006-09-27 at 18:08 +0200, Edoardo Ceccarelli wrote:
>
> I have read that autovacuum cannot check to see pg load before
> launching
> vacuum but is there any patch about it? that would sort out the
> problem
> in a good and simple way.

In some cases the solution to high load is to vacuum the tables being
hit the heaviest -- meaning that simply checking machine load isn't
enough to make that decision.

In fact, that high load problem is exactly why autovacuum was created in
the first place.
--


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

Предыдущее
От: "Trefethen, Zachary J"
Дата:
Сообщение: having trouble restoring a database from files
Следующее
От: Andrea Gozzi
Дата:
Сообщение: Re: having trouble restoring a database from files