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

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP: Pg_upgrade - page layout converter (PLC) hook
Date: 2008-05-17 20:02:29
Message-ID: 482F39D5.6060901@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-05-17 20:05:34 Re: What in the world is happening on spoonbill?
Previous Message Nicolas Barbier 2008-05-17 20:02:28 Re: Would like to sponsor implementation of MATERIALIZED VIEWS