Re: bit map indexes in postgres

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: bit map indexes in postgres
Date: 2005-10-25 03:25:22
Message-ID: 9029.1130210722@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-10-25 03:26:22 Re: grant select on all tables
Previous Message Michael Fuhr 2005-10-25 01:26:48 Re: Displaying current query - eliminating <IDLE>