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
Список 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 по дате отправления: