Skip site navigation (1) Skip section navigation (2)

Re: Dead Space Map

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dead Space Map
Date: 2006-02-28 18:01:48
Message-ID: 16717.1141149708@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Heikki Linnakangas wrote:
>> Index tuples have commit info hint bits in them, don't they? You would 
>> still have to update those.

> Right, but consider that we would have to use the index to find the
> matching reusable heap to begin with, so we could clear the hint bit.

Not that easy: there's a race condition, ie, someone who's just visited
the dead tuple might be on their way back to the index to set the hint
bit.

Have we killed this idea sufficiently dead yet?

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-02-28 18:06:56
Subject: Re: [PERFORM] temporary indexes
Previous:From: Tom LaneDate: 2006-02-28 18:00:11
Subject: Re: Dead Space Map

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group