Re: heap metapages

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: heap metapages
Date: 2012-05-21 18:22:12
Message-ID: CAHyXU0yE4cUHKekem7CwGs7go42Ym1DG6v_uB8v2f=uQ0UqmJw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, May 21, 2012 at 12:56 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> At dinner on Friday night at PGCon, the end of the table that included
> Tom Lane, Stephen Frost, and myself got to talking about the idea of
> including some kind of metapage in every relation, including heap
> relations.  At least some index relations already have something like
> this (cf _bt_initmetapage, _hash_metapinit).  I believe that adding
> this for all relations, including heaps, would allow us to make
> improvements in several areas.

The first thing that jumps to mind is: why can't the metapage be
extended to span multiple pages if necessary? I've often wondered why
the visibility map isn't stored within the heap itself...

merlin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-05-21 18:37:01 Re: heap metapages
Previous Message Tom Lane 2012-05-21 18:20:22 Re: read() returns ERANGE in Mac OS X