Re: Proposal: In-Place upgrade concept

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal: In-Place upgrade concept
Дата
Msg-id 14443.1183502920@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposal: In-Place upgrade concept  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Proposal: In-Place upgrade concept
Список pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>> 2. Page format conversion is WAL-logged as a complete page replacement

> It seems we get that for free. By definition any modification to a page after
> conversion will be the first record for that page since a checkpoint.

No, I don't think so.  Consider a page that's been sucked in for just a
SELECT.  Or did you plan to pay the page conversion cost over and over
again until it's finally modified?  Anyway the whole idea fails if the
first mod that needs to be made is just a hint-bit update.

> Hm, perhaps we could do it by doing as much of the work up-front as possible.
> Requiring datatypes to define a function in pg_proc to do the conversion and
> require that it be a function which can stand on its own without catalog
> lookups or other facilities.

I don't think you quite got the point of "no catalog lookups".  That
includes not looking up pg_type or pg_proc entries.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Still recommending daily vacuum...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: In-Place upgrade concept