Re: New VACUUM FULL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: New VACUUM FULL
Дата
Msg-id 21962.1262655316@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: New VACUUM FULL  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: New VACUUM FULL  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Jan 4, 2010 at 3:51 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> Changes required to remove it are at least these places
>> 
>> * most of vacuum.c
>> * visibility checks
>> * heap tuple flags and xvac
>> * nontransactional validation
>> * minor points and follow up in >7 files, >12 places

> Doesn't sound trivial.

The above is a vast overstatement of the problem.  Simon is not only
talking about removing VACUUM FULL, he's talking about removing every
trace that it ever existed, eg deleting support for MOVED_OFF/MOVED_IN
tuple status flags.  We are *not* doing that, not now nor in the
foreseeable future.  As long as we have any ambition of having in-place
upgrade from pre-8.5 we have to handle the MOVED status bits the same as
we do now.

AFAICS, ripping out most of the guts of vacuum.c is about all that's
likely to happen for 8.5.
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Red-black tree for GIN
Следующее
От: Robert Haas
Дата:
Сообщение: Re: ECPG DESCRIBE [OUTPUT] support