Re: Brain dump: btree collapsing - Mailing list pgsql-hackers

From Manfred Koizar
Subject Re: Brain dump: btree collapsing
Date
Msg-id uo3q4v0ujc0uf0kkp9jbefvh5bgpuluk6p@4ax.com
Whole thread Raw
In response to Brain dump: btree collapsing  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Brain dump: btree collapsing
List pgsql-hackers
On Wed, 12 Feb 2003 17:42:44 -0500, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>Instead of an actively maintained freelist on disk as per Alvaro Herrera's
>patch, I plan to use the FSM to remember where recyclable pages are, much
>as we do for tables.

Given that we have a mostly empty metapage per index, and the metapage
is in memory most of the time, using it for the freelist looks almost
like a free lunch.

I've picked up Alvaro's patch and played around a bit.  Reviewing my
changes it turns out that most of them deal with the freelist.  If you
are interested I can send my version of the patch to you or to the
list.

ServusManfred


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: location of the configuration files
Next
From: Robert Treat
Date:
Subject: Re: [pgsql-advocacy] Changing the default configuration