Re: toast by chunk-end (was Re: PG_PAGE_LAYOUT_VERSION 5 - time for change)

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: toast by chunk-end (was Re: PG_PAGE_LAYOUT_VERSION 5 - time for change)
Date: 2008-11-18 13:22:16
Message-ID: 4922C188.7000708@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera napsal(a):
> Zdenek Kotala wrote:
>> Alvaro Herrera napsal(a):
>>> Heikki Linnakangas wrote:
>>>
>>>> Hmm, you're right. I think it can be made to work by storing the
>>>> *end* offset of each chunk. To find the chunk containing offset X,
>>>> search for the first chunk with end_offset > X.
>>> FWIW I'm trying to do this. So far I've managed to make the basic thing
>>> work, and I'm about to have a look at the slice interface.
>
> Okay, so this seems to work. It's missing writing the sanity checks on
> the returned data, and a look at the SGML docs to see if anything needs
> updating. I'm also going to recheck code comments that may need
> updates.
>
>

Hi Alvaro,

Just a very quick look on your patch. See my comments:

1) TOAST_MAX_CHUNK_SIZE should be removed from controldata structure.

2) PG_PAGE_LAYOUT_VERSION should be bump

3) the other main idea of toast redesign has been to add colnum information to
each chunk.

If I'm thinking more about it, it solves one problem but add another - index
update when page layout is converted during a read. And there are another issues
which we need to solve - I will send new mail.

Zdenek

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-11-18 13:22:43 Re: Updates of SE-PostgreSQL 8.4devel patches (r1197)
Previous Message Peter Eisentraut 2008-11-18 13:15:41 Re: Solaris ident authentication using unix domain sockets