[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