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

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

> 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.

Hmmm.  I thought we determined earlier that the use case for *offline* 
binary conversion was rather limited.  It would have to be 10x faster than 
dump/reload to be worthwhile.  Do you think this is possible?

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: What in the world is happening on spoonbill?
Следующее
От: "Marko Kreen"
Дата:
Сообщение: Re: [rfc,patch] PL/Proxy in core