2010YOUY01 commented on PR #23816:
URL: https://github.com/apache/datafusion/pull/23816#issuecomment-5200111213

   > ```
   > group                                                          HEAD        
                           hll-precision-param
   > -----                                                          ----        
                           -------------------
   > approx_distinct decimal128                                     1.00     
14.5±0.02µs        ? ?/sec    1.12     16.3±0.01µs        ? ?/sec
   > approx_distinct decimal256                                     1.00     
18.1±0.03µs        ? ?/sec    1.23     22.3±0.02µs        ? ?/sec
   > approx_distinct decimal32                                      1.00     
12.9±0.01µs        ? ?/sec    1.08     14.0±0.01µs        ? ?/sec
   > approx_distinct decimal64                                      1.00     
12.9±0.01µs        ? ?/sec    1.09     14.1±0.02µs        ? ?/sec
   > approx_distinct i16 bitmap                                     1.23      
8.7±0.01µs        ? ?/sec    1.00      7.1±0.44µs        ? ?/sec
   > approx_distinct i64 80% distinct                               1.00     
12.8±0.01µs        ? ?/sec    1.10     14.0±0.02µs        ? ?/sec
   > approx_distinct i64 99% distinct                               1.00     
12.9±0.01µs        ? ?/sec    1.09     14.1±0.02µs        ? ?/sec
   > approx_distinct i8 bitmap                                      1.00      
4.3±0.04µs        ? ?/sec    1.01      4.4±0.01µs        ? ?/sec
   > approx_distinct interval day_time 80% distinct                 1.00     
13.0±0.03µs        ? ?/sec    1.08     14.1±0.03µs        ? ?/sec
   > approx_distinct interval day_time 99% distinct                 1.00     
12.9±0.03µs        ? ?/sec    1.09     14.1±0.01µs        ? ?/sec
   > approx_distinct interval month_day_nano 80% distinct           1.00     
13.9±0.01µs        ? ?/sec    1.20     16.6±0.01µs        ? ?/sec
   > approx_distinct interval month_day_nano 99% distinct           1.00     
13.9±0.01µs        ? ?/sec    1.20     16.7±0.03µs        ? ?/sec
   > approx_distinct interval year_month 80% distinct               1.00     
12.9±0.03µs        ? ?/sec    1.09     14.0±0.01µs        ? ?/sec
   > approx_distinct interval year_month 99% distinct               1.00     
12.8±0.01µs        ? ?/sec    1.09     14.0±0.03µs        ? ?/sec
   > approx_distinct u16 bitmap                                     1.00      
5.9±0.00µs        ? ?/sec    1.46      8.6±0.01µs        ? ?/sec
   > approx_distinct u8 bitmap                                      1.00      
4.4±0.01µs        ? ?/sec    1.01      4.4±0.01µs        ? ?/sec
   > approx_distinct utf8 long 80% distinct                         1.00     
33.7±0.02µs        ? ?/sec    1.00     33.7±0.07µs        ? ?/sec
   > approx_distinct utf8 long 99% distinct                         1.00     
33.7±0.02µs        ? ?/sec    1.00     33.5±0.04µs        ? ?/sec
   > approx_distinct utf8 short 80% distinct                        1.00     
24.0±0.01µs        ? ?/sec    1.02     24.4±0.02µs        ? ?/sec
   > approx_distinct utf8 short 99% distinct                        1.00     
23.9±0.13µs        ? ?/sec    1.02     24.3±0.01µs        ? ?/sec
   > approx_distinct utf8view long 80% distinct                     1.00     
40.5±0.02µs        ? ?/sec    1.00     40.7±0.03µs        ? ?/sec
   > approx_distinct utf8view long 99% distinct                     1.00     
40.6±0.02µs        ? ?/sec    1.00     40.6±0.03µs        ? ?/sec
   > approx_distinct utf8view short 80% distinct                    1.00     
16.2±0.03µs        ? ?/sec    1.02     16.6±0.03µs        ? ?/sec
   > approx_distinct utf8view short 99% distinct                    1.00     
16.6±0.01µs        ? ?/sec    1.00     16.6±0.04µs        ? ?/sec
   > approx_distinct_grouped/Decimal128(10, 2) 50000 groups         1.00     
30.3±0.41ms        ? ?/sec    1.00     30.4±0.38ms        ? ?/sec
   > approx_distinct_grouped/Decimal256(40, 2) 50000 groups         1.00     
30.6±0.53ms        ? ?/sec    1.03     31.5±0.43ms        ? ?/sec
   > approx_distinct_grouped/Decimal32(9, 2) 50000 groups           1.00     
28.9±0.34ms        ? ?/sec    1.05     30.3±0.34ms        ? ?/sec
   > approx_distinct_grouped/Decimal64(18, 2) 50000 groups          1.00     
29.3±0.25ms        ? ?/sec    1.03     30.2±0.34ms        ? ?/sec
   > approx_distinct_grouped/Int64 50000 groups                     1.00     
29.2±0.28ms        ? ?/sec    1.05     30.5±0.35ms        ? ?/sec
   > approx_distinct_grouped/Interval(DayTime) 50000 groups         1.00     
28.9±1.05ms        ? ?/sec    1.06     30.5±0.88ms        ? ?/sec
   > approx_distinct_grouped/Interval(MonthDayNano) 50000 groups    1.00     
29.8±0.36ms        ? ?/sec    1.04     31.0±0.39ms        ? ?/sec
   > approx_distinct_grouped/Interval(YearMonth) 50000 groups       1.00     
29.9±0.49ms        ? ?/sec    1.00     29.9±0.49ms        ? ?/sec
   > approx_distinct_grouped/Utf8 50000 groups                      1.00     
29.3±0.29ms        ? ?/sec    1.06     31.0±0.40ms        ? ?/sec
   > approx_distinct_grouped/Utf8View 50000 groups                  1.00     
29.4±0.40ms        ? ?/sec    1.05     30.8±0.40ms        ? ?/sec
   > ```
   
   Some workloads are getting slower 🤔 It would be great to figure out the 
reason, and see if we can avoid that.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to