Re: Single table vacuum full different when vacuum full the whole database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Single table vacuum full different when vacuum full the whole database
Дата
Msg-id 15105.1098059951@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Single table vacuum full different when vacuum full the whole database  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: Single table vacuum full different when vacuum full the whole  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-admin
Дерево обсуждения 
Gaetano Mendola <mendola@bigfoot.com> writes:
> it seems that a vacuum full on the whole DB is more aggressive.

It is not.

A much more plausible theory is that this is the result of concurrent
changes to the table.  It is clear from the "dead row versions" stats
that there were concurrent transactions ...

            regards, tom lane

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

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Single table vacuum full different when vacuum full the whole database
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: Single table vacuum full different when vacuum full the whole