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:37
Message-ID: 20060518185737.EDDE09FA2EB@postgresql.org
Views: Whole Thread | Raw Message | 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.

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)

Browse pgsql-committers by date

  From Date Subject
Next Message User Xzilla 2006-05-18 19:13:01 dbsamples - pagila: Imported Sources
Previous Message Tom Lane 2006-05-18 18:57:31 pgsql: When a bitmap indexscan is using a partial index, it is necessary