Re: [PATCHES] WIP: bitmap indexes

From: "Jie Zhang" <jzhang(at)greenplum(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Gavin Sherry" <swm(at)linuxworld(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] WIP: bitmap indexes
Date: 2006-08-17 19:13:17
Message-ID: C10A0DDD.A600%jzhang@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


On 8/17/06 5:54 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Jie Zhang" <jzhang(at)greenplum(dot)com> writes:
>> This sounds great. One thing I am concern about is that this will add the
>> dependency of node types into the access methods. If we still keep
>> nodeBitmapIndexscan and let it do the bitmap construction for tids returned
>> by amgetmulti.
>
> No, I'm assuming the other proposal that was on the table, namely to get
> rid of amgetmulti in its current form and instead have an AM call that
> delivers a bitmap in one step. (Probably should rename the pg_am column
> to something like amgetbitmap.) nodeBitmapIndexscan would become pretty
> trivial. For the existing AMs this just means that they call
> tbm_add_tuple(s) for themselves, which is no big problem, especially
> considering that they probably get to save some code by not having to
> stop the indexscan when the buffer array gets full.

This sounds good. Another problem is about ScalarArrayOpExpr support in
current nodeBitmapIndexscan. This will not work for stream bitmaps. We have
to disable it in the optimizer.

Thanks,
Jie

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-08-17 19:15:04 Re: BugTracker (Was: Re: 8.2 features status)
Previous Message Alvaro Herrera 2006-08-17 19:09:30 Re: Going for "all green" buildfarm results

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-08-17 19:29:23 Re: [PATCHES] WIP: bitmap indexes
Previous Message Alvaro Herrera 2006-08-17 19:09:30 Re: Going for "all green" buildfarm results