Re: WIP: Pg_upgrade - page layout converter (PLC) hook - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: WIP: Pg_upgrade - page layout converter (PLC) hook
Date
Msg-id 482F39D5.6060901@sun.com
Whole thread Raw
In response to WIP: Pg_upgrade - page layout converter (PLC) hook  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: WIP: Pg_upgrade - page layout converter (PLC) hook  (Josh Berkus <josh@agliodbs.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: What in the world is happening on spoonbill?
Next
From: Peter Eisentraut
Date:
Subject: Re: What in the world is happening on spoonbill?