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

Josh Berkus napsal(a):
> 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?
>

It is difficult to say without prototype. However, binary conversion can be
performed without (or minimal) WAL logging and without sync. I think async write
is a big improvement. And there is not problem convert tables in parallel mode.
And of course you don't need bin<->text<->bin conversion. Unfortunately reindex
is necessary in both cases.

Zdenek