Обсуждение: pgsql: When a bitmap indexscan is using a partial index, it is necessary

Поиск
Список
Период
Сортировка

pgsql: When a bitmap indexscan is using a partial index, it is necessary

От
tgl@postgresql.org (Tom Lane)
Дата:
Log Message:
-----------
When a bitmap indexscan is using a partial index, it is necessary to include
the partial index predicate in the scan's "recheck condition".  Otherwise,
if the scan becomes lossy for lack of bitmap memory, we would fail to enforce
that returned rows satisfy the predicate.  Noted while studying bug #2441
from Arjen van der Meijden.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        createplan.c (r1.202.2.3 -> r1.202.2.4)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/createplan.c.diff?r1=1.202.2.3&r2=1.202.2.4)