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

From Heikki Linnakangas
Subject Re: Dealing with dangling index pointers
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Dealing with dangling index pointers  (Tom Lane <[email protected]>)
Responses Re: Dealing with dangling index pointers
List pgsql-hackers
Tom Lane wrote:
> Heikki Linnakangas <[email protected]> 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