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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com>
Subject: Re: WIP: Pg_upgrade - page layout converter (PLC) hook
Date: 2008-05-17 20:24:31
Message-ID: 200805171324.33410.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2008-05-17 20:26:18 Re: ecpg localization
Previous Message Peter Eisentraut 2008-05-17 20:24:18 Re: Problems with CVS HEAD compile