| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-02-28 18:06:56 | Re: [PERFORM] temporary indexes |
| Previous Message | Tom Lane | 2006-02-28 18:00:11 | Re: Dead Space Map |