Hi,

I'd like to know if there are any plans on introducing bitmap indexes
into postgresql. I think this could mean a big performance improvement
especially for datawarehousing applications. I know that there is an
index type hash but I don't know how both types are comparable due to
they are both best usable for equality expressions.

Thanks in advance!

Regards,
Yann

Thu, 7 Oct 2004 21:55:00 +0200
Yann Michel <yann-postgresql@spline.de>
plans for bitmap indexes?
Yann Michel schrieb:
> I'd like to know if there are any plans on introducing bitmap indexes
> into postgresql. I think this could mean a big performance improvement
> especially for datawarehousing applications. I know that there is an
> index type hash but I don't know how both types are comparable due to
> they are both best usable for equality expressions.

Sure, and the next will come with musicbrainz.
Why not :)
If you don't want to code that in the app, the database backend is the 
solution. The database is the golden hammer. 
http://c2.com/cgi/wiki?GoldenHammer
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

Thu, 07 Oct 2004 22:41:04 +0200
Reini Urban <rurban@x-ray.at>
Re: plans for bitmap indexes?
Yann Michel wrote:
> Hi,
> 
> I'd like to know if there are any plans on introducing bitmap indexes
> into postgresql. I think this could mean a big performance improvement
> especially for datawarehousing applications. I know that there is an
> index type hash but I don't know how both types are comparable due to
> they are both best usable for equality expressions.

Lots of people have talked about it but I don't know anyone coding it.
-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Thu, 7 Oct 2004 18:54:15 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: plans for bitmap indexes?
Hi,

On Thu, Oct 07, 2004 at 06:54:15PM -0400, Bruce Momjian wrote:
> > I'd like to know if there are any plans on introducing bitmap indexes
> > into postgresql. I think this could mean a big performance improvement
> > especially for datawarehousing applications. I know that there is an
> > index type hash but I don't know how both types are comparable due to
> > they are both best usable for equality expressions.
> 
> Lots of people have talked about it but I don't know anyone coding it.

have you ever discussed if bitmap indexes lead to better query
performance than hash indexes will do?

Regards,
Yann

Fri, 8 Oct 2004 09:26:19 +0200
Yann Michel <yann-postgresql@spline.de>
Re: plans for bitmap indexes?
Hi,

On Thu, Oct 07, 2004 at 10:41:04PM +0200, Reini Urban wrote:
> >I'd like to know if there are any plans on introducing bitmap indexes
> >into postgresql. I think this could mean a big performance improvement
> >especially for datawarehousing applications. I know that there is an
> >index type hash but I don't know how both types are comparable due to
> >they are both best usable for equality expressions.
> 
> Sure, and the next will come with musicbrainz.
> Why not :)

I don't know what this means to my questin, but anyway...

> If you don't want to code that in the app, the database backend is the 
> solution. The database is the golden hammer. 


Therefore I asked wheather there are any thoughts of implementing them.

Regards,
Yann

Fri, 8 Oct 2004 09:27:55 +0200
Yann Michel <yann-postgresql@spline.de>
Re: plans for bitmap indexes?