Re: Incorrect result of bitmap heap scan. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Incorrect result of bitmap heap scan.
Date
Msg-id 1646644.1733158959@sss.pgh.pa.us
Whole thread Raw
In response to Re: Incorrect result of bitmap heap scan.  (Andres Freund <andres@anarazel.de>)
Responses Re: Incorrect result of bitmap heap scan.
Re: Incorrect result of bitmap heap scan.
Re: Incorrect result of bitmap heap scan.
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> I think the problematic scenario involves tuples that *nobody* can see. During
> the bitmap index scan we don't know that though. Thus the tid gets inserted
> into the bitmap. Then, before we visit the heap, a concurrent vacuum removes
> the tuple from the indexes and then the heap and marks the page as
> all-visible, as the deleted row version has been removed.

Yup.  I am saying that that qualifies as too-aggressive setting of the
all-visible bit.  I'm not sure what rule we should adopt instead of
the current one, but I'd much rather slow down page freezing than
institute new page locking rules.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Incorrect result of bitmap heap scan.
Next
From: Peter Geoghegan
Date:
Subject: Re: Incorrect result of bitmap heap scan.