View Single Post

   
  #1 (permalink)  
Old 04-18-2008, 10:41 AM
Tom Lane
 
Posts: n/a
Default Re: Bitmapscan changes

Heikki Linnakangas <heikki@enterprisedb.com> writes:
> The patch also adds support for candidate matches. An index scan can
> indicate that the tuples it's returning are candidates, and the executor
> will recheck the original scan quals of any candidate matches when the
> tuple is fetched from heap.


This will not work, unless we change the planner --- the original quals
aren't necessarily there in some corner cases (partial indexes, if
memory serves).

> The motivation for adding the support for candidate matches is that GIT
> / clustered indexes need it.


You need more than a vague reference to an unapplied patch to convince
me we ought to do this.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote