Re: bitmap indexes - performance - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: bitmap indexes - performance
Date
Msg-id 201007020131.o621VWK08371@momjian.us
Whole thread Raw
In response to Re: bitmap indexes - performance  (Leonardo F <m_lists@yahoo.it>)
Responses Re: bitmap indexes - performance
List pgsql-hackers
Leonardo F wrote:
> I'm trying to find more docs that explain the "improvements" of
> bitmap indexes in other products... but most of what I've found
> talks about bitmapAND/OR.... which is something that is very
> cool, but that postgres already does even with btree indexes...
> or index creation time/size, which are, for the moment, the only
> things that I'm pretty confident the patch would actually provide.

I think a real limitation of on-disk bitmap indexes is that they are
only feable for low cardinality columns, while btree handles all column
types.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + None of us is going to be here forever. +


pgsql-hackers by date:

Previous
From: uwcssa
Date:
Subject: hello
Next
From: Bruce Momjian
Date:
Subject: Re: 9.0beta2 - server crash when using HS + SR