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>
Re: [PERFORM] autovacuum on a -mostly- r/o table Csaba Nagy <nagy@ecircle-ag.com>
Re: [PERFORM] autovacuum on a -mostly- r/o table "Matthew T. O'Connor" <matthew@zeut.net>
Re: [PERFORM] autovacuum on a -mostly- r/o table Rod Taylor <pg@rbt.ca>
Re: [PERFORM] autovacuum on a -mostly- r/o table Bill Moran <wmoran@collaborativefusion.com>
Re: [PERFORM] autovacuum on a -mostly- r/o table Tobias Brox <tobias@nordicbet.com>
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
Дата:
От: Andrea Gozzi
Дата:
FAQ