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

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: When a bitmap indexscan is using a partial index, it is necessary
Date: 2006-05-18 18:57:31
Message-ID: [email protected]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Modified Files:
--------------
pgsql/src/backend/optimizer/plan:
createplan.c (r1.210 -> r1.211)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/createplan.c.diff?r1=1.210&r2=1.211)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-05-18 18:57:37 pgsql: When a bitmap indexscan is using a partial index, it is necessary
Previous Message Bruce Momjian 2006-05-18 18:51:50 pgsql: Allow sparcv8plus to use "cas".