Re: Free Space Map thoughts

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Free Space Map thoughts
Date: 2007-11-09 12:50:02
Message-ID: 20071109125001.GB2768@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas wrote:

> - We need a solution for the indexes as well. A separate file would fit
> nicely for them, though the contents would be different because for indexes
> we only care if a page is unused or not.

FWIW I think it's worth considering that we may be interested in keeping
closer track of free space in index pages, so that we can eventually
implement some heuristic for when to merge partially-empty pages.

--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-11-09 13:06:12 Re: Free Space Map thoughts
Previous Message Jan Urbański 2007-11-09 12:28:38 Re: a tsearch2 (8.2.4) dictionary that only filters out stopwords