Chris Browne <cbbrowne(at)acm(dot)org> writes:
> bnichols(at)ca(dot)afilias(dot)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