Re: Dealing with dangling index pointers - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Dealing with dangling index pointers
Date
Msg-id 469B830B.2010003@enterprisedb.com
Whole thread Raw
In response to Re: Dealing with dangling index pointers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dealing with dangling index pointers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Heikki Linnakangas <heikki@enterprisedb.com> writes:
>> While looking at the HOT patch, I noticed that if there's an index tuple
>> pointing to a non-existing heap tuple, we just silently ignore it.
> 
> This is intentional --- consider case where VACUUM has removed both
> index and heap entries while some other (amazingly slow...) process is
> in flight from the index to the heap.

Hmm. In b-tree we keep the index page pinned while we do the heap fetch
to avoid that, but apparently we don't have that interlock in other
indexams.

Ok, never mind.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Dealing with dangling index pointers
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Straightforward changes for increased SMP scalability