Re: WIP: Pg_upgrade - page layout converter (PLC) hook

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема Re: WIP: Pg_upgrade - page layout converter (PLC) hook
Дата
Msg-id 482F39D5.6060901@sun.com
обсуждение исходный текст
Ответ на WIP: Pg_upgrade - page layout converter (PLC) hook  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Ответы Re: WIP: Pg_upgrade - page layout converter (PLC) hook  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Zdenek Kotala napsal(a):

<snip>

> How it works:
> 
> When PLC module is loaded, then for each page which does not have native 
> page version conversion routine is called. Buffer is mark as a dirty and 
> upgraded page is inserted into WAL.
> 

Unfortunately, this approach does not work between layout 3 and 4. It works only 
for heap on platfrom with maxallign=4.

The main problem is that PageHeader has been extended to 24 bytes and it 
requires reindexing, TOAST chunk resizing, converted tuples does not fit on page 
on platform where maxallign=8.

I'm now working on offline conversion method.
    Zdenek



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What in the world is happening on spoonbill?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: What in the world is happening on spoonbill?