From: Luke Lonergan <llonergan@greenplum.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Skype Technologies OY <hannu@skype.net>
Cc: mark@mark.mielke.cc, "Bruce Momjian" <bruce@momjian.us>
Cc: Jie Zhang <jzhang@greenplum.com>
Cc: Gavin Sherry <swm@linuxworld.com.au>
Cc: pgsql-hackers@postgresql.org
Subject: Re: On-disk bitmap index patch
Date: Tue, 25 Jul 2006 13:39:11 -0700
Message-ID: <C0EBCF7F.2AD78%llonergan@greenplum.com> (raw)
In-Reply-To: <24222.1153859513@sss.pgh.pa.us>
Tom,
On 7/25/06 1:31 PM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> Yeah, we finally gave up on rtree entirely. I don't want to see any
> other index AMs languishing in the closet like that. If bitmap can
> hold its own to the extent that people are interested in working on
> it/improving it, then great, but I'm worried that it's not going to
> have a wide enough use-case to attract maintainers.
How do we close the gap?
I think Jie is interested in maintaining it, and we're looking to extend the
range of applications for both the AM and extensions that use the raw bitmap
comparators made available to the executor. This should be just the start
of some really great work on speedy access using bitmaps.
Even as it sits, the on-disk bitmap is over 100x faster in cases where it's
suited and the other commercial DBMS have had this popular feature for
years.
- Luke
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: llonergan@greenplum.com, tgl@sss.pgh.pa.us, hannu@skype.net, bruce@momjian.us, jzhang@greenplum.com, swm@linuxworld.com.au
Subject: Re: On-disk bitmap index patch
In-Reply-To: <C0EBCF7F.2AD78%llonergan@greenplum.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox