Re: Rewriting Free Space Map

From: Lars-Erik Bjørk <Lars-Erik(dot)Bjork(at)Sun(dot)COM>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hannu Krosing <hannu(at)krosing(dot)net>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Luke Lonergan <llonergan(at)greenplum(dot)com>
Subject: Re: Rewriting Free Space Map
Date: 2008-03-17 13:53:30
Message-ID: 1205762010.13711.0.camel@falcon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Mon, 2008-03-17 at 09:29 -0400, Tom Lane wrote:
> Hannu Krosing <hannu(at)krosing(dot)net> writes:
> > On Sun, 2008-03-16 at 21:33 -0300, Alvaro Herrera wrote:
> >> Tom Lane wrote:
> >>> The idea that's becoming attractive to me while contemplating the
> >>> multiple-maps problem is that we should adopt something similar to
> >>> the old Mac OS idea of multiple "forks" in a relation.
>
> > Are'nt we in a way doing this for indexes ?
>
> Not really --- indexes are closer to being independent entities, since
> they have their own relfilenode values, own pg_class entries, etc. What
> I'm imagining here is something that's so tightly tied to the core heap
> that there's no value in managing it as a distinct entity, thus the idea
> of same relfilenode with a different extension. The existence of
> multiple forks in a relation wouldn't be exposed at all at the SQL
> level.
>
> >> I think something similar could be used to store tuple visibility bits
> >> separately from heap tuple data itself, so +1 to this idea.
>
> > Not just "bits", but whole visibility info (xmin,xmax,tmin,tmax, plus
> > bits) should be stored separately.
>
> I'm entirely un-sold on this idea, but yeah it would be something that
> would be possible to experiment with once we have a multi-fork
> infrastructure.
>
> regards, tom lane
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message KaiGai Kohei 2008-03-17 13:56:09 Re: [0/4] Proposal of SE-PostgreSQL patches
Previous Message Heikki Linnakangas 2008-03-17 13:49:29 Re: Rewriting Free Space Map