Re: bit map indexes in postgres - Mailing list pgsql-novice

From Tom Lane
Subject Re: bit map indexes in postgres
Date
Msg-id 9029.1130210722@sss.pgh.pa.us
Whole thread Raw
In response to Re: bit map indexes in postgres  (Chris Browne <cbbrowne@acm.org>)
List pgsql-novice
Chris Browne <cbbrowne@acm.org> writes:
> bnichols@ca.afilias.info (Brad Nicholson) writes:
>> Bitmap indexs are coming in 8.1 (which is currently in beta).

> It is worth noticing that these are not bitmaps on disk, but rather
> are handled in memory.

Yes.  An on-disk bitmap index is a totally different animal.

There was some work done towards on-disk bitmap indexes this past
summer, but AFAIR it crashed and burned --- no apparent performance
gain.

            regards, tom lane

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: grant select on all tables
Next
From: Tom Lane
Date:
Subject: Re: Installation problem