[Bizgres-general] FW: Latest bitmap performance results..

[Luke Lonergan]

Ayush,

On 3/22/06 6:17 PM, "Ayush Parashar" <aparashar at greenplum.com> wrote:

> The index creation time has greatly reduced:
> ----------------------------------------------------------
>                     After patch     Before      B-Tree
>                     (latest)
>                     (Bitmap)        (Bitmap)
> ----------------------------------------------------------
> l_linenumber        171.146         374.5       412.1
> l_quantity          249.018         547.2       937.8
> l_shipmode          262.282         454.8       2217.1
> o_orderstatus       70.5            83.54       241.3
> o_orderpriority     90.6            108.52      679.1
> c_mktsegment        7.3             10.9        51.3
> c_nationkey         3.4             8.3         9.3
> ----------------------------------------------------------

Beautiful!

Any result for the high cardinality case, say 10,000?
 
> Latest performance numbers:
> INDEX SIZE in MBytes:
> ----------------------------------------------------------
>                                 Bitmap        Btree
> ----------------------------------------------------------
> l_linenumber                    59            1285
> l_quantity                      117           1804
> l_shipmode                      58            1804
> o_orderstatus                   5             321
> o_orderpriority                 11            580
> c_mktsegment                    1             45
> c_nationkey                     2             32
> ----------------------------------------------------------

Outstanding!
 
> QUERY PERFORMANCE (time in seconds for query to finish):
> (in case of bitmap all columns have bitmap index while in case of btree all
> columns have btree index)
> ----------------------------------------------------------
>            Bitmap  Btree
> ----------------------------------------------------------
> Query 1    136.3   393.5
> Query 2    60.7    391.6
> Query 3    97.3    186.7
> Query 4    102.5   282.9
> Query 5    61.6    358.9
> ----------------------------------------------------------

Very nice!

Seems like something you'd really want in your warehousing application to
me...

- Luke