Re: (auto)vacuum truncate exclusive lock

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: (auto)vacuum truncate exclusive lock
Дата
Msg-id 517014ED.2060502@Yahoo.com
обсуждение исходный текст
Ответ на Re: (auto)vacuum truncate exclusive lock  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On 4/12/2013 2:08 PM, Alvaro Herrera wrote:
> Tom Lane escribió:
>
>> Are you saying you intend to revert that whole concept?  That'd be
>> okay with me, I think.  Otherwise we need some thought about how to
>> inform the stats collector what's really happening.
>
> Maybe what we need is to consider table truncation as a separate
> activity from vacuuming.  Then autovacuum could invoke it without having
> to do a full-blown vacuum.  For this to work, I guess we would like to
> separately store the status of the back-scan in pgstat somehow (I think
> a boolean flag suffices: "were we able to truncate all pages that
> appeared to be empty?")

Should have read the entire thread before responding :)


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin



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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: (auto)vacuum truncate exclusive lock
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: (auto)vacuum truncate exclusive lock