Re: Incorrect result of bitmap heap scan.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Incorrect result of bitmap heap scan.
Дата
Msg-id 1646644.1733158959@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Incorrect result of bitmap heap scan.  (Andres Freund <andres@anarazel.de>)
Ответы Re: Incorrect result of bitmap heap scan.
Re: Incorrect result of bitmap heap scan.
Re: Incorrect result of bitmap heap scan.
Список 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 по дате отправления: