Re: plans for bitmap indexes?

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: plans for bitmap indexes?
Дата
Msg-id Pine.GSO.4.61.0410081408550.23275@ra.sai.msu.su
обсуждение исходный текст
Ответ на Re: plans for bitmap indexes?  (Yann Michel <yann-postgresql@spline.de>)
Список 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 по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: plans for bitmap indexes?
Следующее
От: "Zeugswetter Andreas DAZ SD"
Дата:
Сообщение: Re: Security implications of config-file-location patch