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

[Jim C. Nasby]

On Thu, Jan 26, 2006 at 02:23:48PM -0800, Luke Lonergan wrote:
> Jim,
> 
> On 1/26/06 2:21 PM, "Jim C. Nasby" <jnasby at pervasive.com> wrote:
> 
> > Maybe I'm just being greedy at this point, but shouldn't there have been
> > a more noticable change in performance from dropping the index size by a
> > factor of 8? Or are bitmap indexes just that expensive?
> 
> We agree!  We think the bitmap scan logic is the bottleneck, so Jie's
> working on a direct AND and OR in the executor plan node.

Sweet! I'll shut up now. :)
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461