Re: Autovacuum on by default?

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: Autovacuum on by default?
Дата
Msg-id 002301c6c782$1b92cfc0$0202fea9@aus.pervasive.com
обсуждение исходный текст
Ответ на Re: Autovacuum on by default?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: Autovacuum on by default?
Список pgsql-hackers
Jim C. Nasby wrote:
> On Tue, Aug 22, 2006 at 11:08:49AM -0400, Tom Lane wrote:
>> "Jim C. Nasby" <jim@nasby.net> writes:
>>> If there's a bunch of activity on a table but stats are reset
>>> before a vacuum is run on it and then a vacuum is run, the user
>>> will still be left thinking that the table needs to be vacuumed.
>> 
>> Except that autovac *won't* vacuum it if the stats have been reset.
>> So I'm not seeing that there's really a problem in practice.
> 
> IIRC the stats also include info about regular (manual) vacuums, so
> the above scenario still applies.

They do.  The stats patch as applied captures both autovacuum and manual
vacuum
as well as analyze (both from the Autovacuum daemon and manual).



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893



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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Tricky bugs in concurrent index build
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum on by default?