zhuqi-lucas commented on PR #16876:
URL: https://github.com/apache/datafusion/pull/16876#issuecomment-3113867749
> 🤖: Benchmark completed
>
> Details
>
> ```
> group
main
optimize_vectorized_append
> -----
----
--------------------------
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_1000/append_val
1.28 9.6±0.03µs ? ?/sec 1.00 7.5±0.06µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_1000/vectorized_append
6.12 5.7±0.04µs ? ?/sec 1.00 938.9±1.67ns ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_1000/vectorized_equal_to
1.00 9.3±0.02µs ? ?/sec 1.03 9.6±0.01µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_10000/append_val
1.23 91.0±0.25µs ? ?/sec 1.00 73.9±0.32µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_10000/vectorized_append
6.08 54.9±0.20µs ? ?/sec 1.00 9.0±0.02µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_10000/vectorized_equal_to
1.00 93.1±0.11µs ? ?/sec 1.03 95.8±0.09µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_100000/append_val
1.25 910.2±6.66µs ? ?/sec 1.00 730.0±1.80µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_100000/vectorized_append
4.74 547.3±2.01µs ? ?/sec 1.00 115.4±9.56µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.0_size_100000/vectorized_equal_to
1.00 937.1±1.21µs ? ?/sec 1.03 964.8±1.30µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_1000/append_val
1.40 13.3±0.04µs ? ?/sec 1.00 9.5±0.02µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_1000/vectorized_append
2.03 13.8±0.05µs ? ?/sec 1.00 6.8±0.02µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_1000/vectorized_equal_to
1.00 10.2±0.01µs ? ?/sec 1.02 10.4±0.01µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_10000/append_val
1.43 130.7±0.30µs ? ?/sec 1.00 91.6±0.21µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_10000/vectorized_append
1.89 134.5±0.28µs ? ?/sec 1.00 71.3±0.11µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_10000/vectorized_equal_to
1.00 101.3±0.17µs ? ?/sec 1.02 103.7±0.09µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_100000/append_val
1.41 1307.2±4.61µs ? ?/sec 1.00 925.6±3.28µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_100000/vectorized_append
1.80 1353.2±3.15µs ? ?/sec 1.00 753.2±8.15µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.1_size_100000/vectorized_equal_to
1.00 1024.3±7.26µs ? ?/sec 1.02 1046.4±2.16µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_1000/append_val
1.13 11.6±0.07µs ? ?/sec 1.00 10.3±0.10µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_1000/vectorized_append
1.54 12.2±0.07µs ? ?/sec 1.00 7.9±0.04µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_1000/vectorized_equal_to
1.00 7.3±0.02µs ? ?/sec 1.02 7.5±0.02µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_10000/append_val
1.07 139.3±0.87µs ? ?/sec 1.00 130.2±0.51µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_10000/vectorized_append
1.31 144.5±0.52µs ? ?/sec 1.00 110.1±0.33µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_10000/vectorized_equal_to
1.02 88.4±0.15µs ? ?/sec 1.00 86.3±0.56µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_100000/append_val
1.07 1419.0±6.24µs ? ?/sec 1.00 1331.6±3.18µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_100000/vectorized_append
1.26 1465.8±5.74µs ? ?/sec 1.00 1159.8±6.63µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/inlined_null_0.5_size_100000/vectorized_equal_to
1.03 915.4±2.71µs ? ?/sec 1.00 892.3±1.58µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_1000/append_val
1.10 18.1±0.04µs ? ?/sec 1.00 16.5±0.04µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_1000/vectorized_append
2.10 12.8±0.03µs ? ?/sec 1.00 6.1±0.06µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_1000/vectorized_equal_to
1.00 8.2±0.02µs ? ?/sec 1.02 8.4±0.01µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_10000/append_val
1.10 186.7±0.60µs ? ?/sec 1.00 169.6±0.82µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_10000/vectorized_append
2.09 146.7±0.61µs ? ?/sec 1.00 70.3±0.19µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_10000/vectorized_equal_to
1.00 91.4±0.23µs ? ?/sec 1.00 91.0±0.19µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_100000/append_val
1.07 4.0±0.05ms ? ?/sec 1.00 3.7±0.03ms
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_100000/vectorized_append
4.62 3.5±0.05ms ? ?/sec 1.00 766.6±4.97µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.0_size_100000/vectorized_equal_to
1.00 990.3±3.91µs ? ?/sec 1.01 999.0±3.13µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_1000/append_val
1.20 20.0±0.08µs ? ?/sec 1.00 16.7±0.05µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_1000/vectorized_append
2.20 20.2±0.11µs ? ?/sec 1.00 9.2±0.03µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_1000/vectorized_equal_to
1.00 9.1±0.03µs ? ?/sec 1.01 9.2±0.02µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_10000/append_val
1.13 220.1±0.61µs ? ?/sec 1.00 194.6±0.43µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_10000/vectorized_append
1.95 222.2±0.65µs ? ?/sec 1.00 113.8±0.35µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_10000/vectorized_equal_to
1.00 101.6±0.31µs ? ?/sec 1.02 104.0±0.25µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_100000/append_val
1.13 2.4±0.01ms ? ?/sec 1.00 2.1±0.01ms
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_100000/vectorized_append
2.07 2.4±0.01ms ? ?/sec 1.00 1166.5±2.92µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.1_size_100000/vectorized_equal_to
1.00 1110.7±3.94µs ? ?/sec 1.01 1123.7±2.81µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_1000/append_val
1.08 14.5±0.18µs ? ?/sec 1.00 13.4±0.11µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_1000/vectorized_append
2.25 15.0±0.10µs ? ?/sec 1.00 6.7±0.04µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_1000/vectorized_equal_to
1.00 6.4±0.01µs ? ?/sec 1.02 6.6±0.02µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_10000/append_val
1.05 188.2±0.48µs ? ?/sec 1.00 178.5±0.51µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_10000/vectorized_append
1.54 189.8±0.42µs ? ?/sec 1.00 123.0±0.35µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_10000/vectorized_equal_to
1.00 94.3±0.42µs ? ?/sec 1.00 94.7±0.35µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_100000/append_val
1.08 1996.7±10.57µs ? ?/sec 1.00 1853.9±4.97µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_100000/vectorized_append
1.52 2.0±0.01ms ? ?/sec 1.00 1329.0±3.75µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/mixed_null_0.5_size_100000/vectorized_equal_to
1.01 1064.2±2.62µs ? ?/sec 1.00 1056.0±5.27µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_1000/append_val
1.15 23.1±0.46µs ? ?/sec 1.00 20.2±0.12µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_1000/vectorized_append
1.25 19.2±0.46µs ? ?/sec 1.00 15.3±0.15µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_1000/vectorized_equal_to
1.00 12.2±0.07µs ? ?/sec 1.00 12.2±0.05µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_10000/append_val
1.00 249.3±1.71µs ? ?/sec 1.46 365.0±4.91µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_10000/vectorized_append
1.14 222.4±3.00µs ? ?/sec 1.00 194.9±4.60µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_10000/vectorized_equal_to
1.00 165.8±4.55µs ? ?/sec 1.02 168.6±7.02µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_100000/append_val
1.02 14.7±0.25ms ? ?/sec 1.00 14.4±0.26ms
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_100000/vectorized_append
1.12 14.2±0.24ms ? ?/sec 1.00 12.7±0.24ms ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.0_size_100000/vectorized_equal_to
1.03 3.7±0.06ms ? ?/sec 1.00 3.6±0.05ms ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_1000/append_val
1.05 21.7±0.29µs ? ?/sec 1.00 20.6±0.21µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_1000/vectorized_append
1.44 23.9±0.50µs ? ?/sec 1.00 16.6±0.17µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_1000/vectorized_equal_to
1.00 11.8±0.07µs ? ?/sec 1.02 12.0±0.11µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_10000/append_val
1.00 276.9±2.91µs ? ?/sec 1.38 382.7±1.72µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_10000/vectorized_append
1.32 277.5±1.55µs ? ?/sec 1.00 209.5±2.51µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_10000/vectorized_equal_to
1.00 172.7±4.76µs ? ?/sec 1.00 172.9±5.08µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_100000/append_val
1.04 13.9±0.22ms ? ?/sec 1.00 13.3±0.23ms
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_100000/vectorized_append
1.19 14.1±0.25ms ? ?/sec 1.00 11.8±0.21ms ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.1_size_100000/vectorized_equal_to
1.01 3.5±0.07ms ? ?/sec 1.00 3.5±0.06ms ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_1000/append_val
1.00 17.6±0.18µs ? ?/sec 1.02 17.9±0.16µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_1000/vectorized_append
1.51 17.6±0.23µs ? ?/sec 1.00 11.6±0.27µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_1000/vectorized_equal_to
1.00 7.9±0.04µs ? ?/sec 1.03 8.1±0.06µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_10000/append_val
1.01 246.3±1.85µs ? ?/sec 1.00 244.3±1.22µs
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_10000/vectorized_append
1.42 250.3±2.07µs ? ?/sec 1.00 176.3±0.47µs ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_10000/vectorized_equal_to
1.00 144.1±0.85µs ? ?/sec 1.00 144.3±0.82µs ? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_100000/append_val
1.05 8.7±0.19ms ? ?/sec 1.00 8.3±0.19ms
? ?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_100000/vectorized_append
1.28 8.7±0.17ms ? ?/sec 1.00 6.8±0.23ms ?
?/sec
>
ByteViewGroupValueBuilder_vectorized_append/random_null_0.5_size_100000/vectorized_equal_to
1.03 2.1±0.03ms ? ?/sec 1.00 2.1±0.03ms ? ?/sec
> ```
Thank you @alamb , it is almost the same result from my local. But the
clickbench/tpch seems no change.
--
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: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
