Re: plans for bitmap indexes? - Mailing list pgsql-hackers

From Oleg Bartunov
Subject Re: plans for bitmap indexes?
Date
Msg-id Pine.GSO.4.61.0410081408550.23275@ra.sai.msu.su
Whole thread Raw
In response to Re: plans for bitmap indexes?  (Yann Michel <yann-postgresql@spline.de>)
List pgsql-hackers
On Fri, 8 Oct 2004, Yann Michel wrote:

> Hi,
>
> On Fri, Oct 08, 2004 at 10:09:18AM +0100, Dave Page wrote:
>> I think what Reini was asking was why do you think you need bitmap
>> indexes as opposed to any existing type?
>
> due to I'm developing a datawarehousing application we have lots of
> fact-data in our central fact-table. As I know how to improve
> performance on Oracle based datawarehouses, I'm used to add bitmap
> indexes for atributes having only a few distinct values.
> So I was looking for any comparable indexing technology but didn't find
> any so far.

Yann, you may try our contrib/intarray module

>
> Regards,
> Yann
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: plans for bitmap indexes?
Next
From: "Zeugswetter Andreas DAZ SD"
Date:
Subject: Re: Security implications of config-file-location patch