[Bizgres-general] Bitmap Indexes : Block packing calculation error
Luke Lonergan
llonergan at greenplum.com
Thu Jan 26 22:23:48 GMT 2006
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.
- Luke
More information about the Bizgres-general
mailing list