[Bizgres-general] Re: Bitmap Indexes : Block packing calculation error

Mark Kirkwood markir at paradise.net.nz
Thu Jan 26 23:01:22 GMT 2006


Simon Riggs wrote:
> On Wed, 2006-01-25 at 23:32 -0800, Jie Zhang wrote: 
>>Yeah, I have actually noticed this bug, but thank you for pointing that out.
>>Ayush posted a patch of this fix and also some test results on TPCH queries
>>in Jan 16. I am wondering if you have seen this patch.
> 
> Jie, I think you should have posted something on *this* list publicly if
> you want community support. A lot of people have been wondering whether
> the bit maps were any good at all. This patch seems to change things
> significantly.
>


While it would have been good to know this was fixed earlier (BTW even
updating the source code on Pgfoundry might have given me a clue), in
this case I'm quite pleased I *didn't* know - I probably would not have
put in the time to understand how the indexes worked and why they took
up so much space if I had!

Cheers

Mark



More information about the Bizgres-general mailing list