Skip to content

Instantly share code, notes, and snippets.

@yuzefovich

yuzefovich/reduce agg size benchmarks

Created January 5, 2022 01:49
Show Gist options
  • Save yuzefovich/d30cd1a0662733855ae8c9d8217ae603 to your computer and use it in GitHub Desktop.
Save yuzefovich/d30cd1a0662733855ae8c9d8217ae603 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
reduce agg size benchmarks
name old time/op new time/op delta
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1-24 23.9µs ± 3% 22.8µs ± 4% -4.64% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32-24 31.9µs ± 4% 30.3µs ± 3% -5.25% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32-24 30.1µs ± 3% 29.2µs ± 6% -3.24% (p=0.003 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32-24 26.5µs ± 4% 25.0µs ± 2% -5.58% (p=0.000 n=10+9)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1024-24 321µs ± 2% 312µs ± 2% -2.77% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1024-24 275µs ± 1% 270µs ± 3% ~ (p=0.053 n=9+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1024-24 111µs ± 2% 107µs ± 4% -3.99% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1024-24 94.3µs ± 3% 89.9µs ± 1% -4.62% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1024-24 86.9µs ± 3% 84.1µs ± 2% -3.23% (p=0.001 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32768-24 12.7ms ± 2% 12.3ms ± 4% -3.82% (p=0.001 n=9+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32768-24 11.2ms ± 5% 11.3ms ± 9% ~ (p=0.796 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32768-24 2.51ms ± 1% 2.52ms ± 2% ~ (p=0.089 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=32768-24 1.40ms ± 1% 1.42ms ± 1% +1.19% (p=0.000 n=10+8)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=32768-24 1.06ms ± 2% 1.05ms ± 2% ~ (p=0.579 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1048576-24 521ms ± 4% 492ms ± 3% -5.61% (p=0.000 n=10+9)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1048576-24 573ms ± 1% 557ms ± 3% -2.65% (p=0.008 n=9+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1048576-24 343ms ±11% 337ms ±14% ~ (p=0.853 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1048576-24 138ms ±16% 136ms ± 1% ~ (p=0.515 n=10+8)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1048576-24 50.4ms ± 1% 50.9ms ± 1% +0.81% (p=0.001 n=10+10)
name old speed new speed delta
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1-24 335kB/s ± 4% 352kB/s ± 5% +5.07% (p=0.001 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32-24 8.02MB/s ± 4% 8.46MB/s ± 3% +5.53% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32-24 8.50MB/s ± 3% 8.79MB/s ± 6% +3.41% (p=0.003 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32-24 9.68MB/s ± 4% 10.20MB/s ± 4% +5.47% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1024-24 25.5MB/s ± 2% 26.2MB/s ± 2% +2.85% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1024-24 29.7MB/s ± 1% 30.3MB/s ± 3% ~ (p=0.053 n=9+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1024-24 73.6MB/s ± 2% 76.6MB/s ± 4% +4.18% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1024-24 86.9MB/s ± 3% 91.1MB/s ± 1% +4.81% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1024-24 94.3MB/s ± 3% 97.4MB/s ± 2% +3.32% (p=0.001 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32768-24 20.6MB/s ± 2% 21.4MB/s ± 4% +4.01% (p=0.001 n=9+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32768-24 23.3MB/s ± 5% 23.2MB/s ± 8% ~ (p=0.796 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32768-24 104MB/s ± 1% 104MB/s ± 2% ~ (p=0.085 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=32768-24 187MB/s ± 1% 185MB/s ± 1% -1.18% (p=0.000 n=10+8)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=32768-24 248MB/s ± 2% 249MB/s ± 2% ~ (p=0.579 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1048576-24 16.1MB/s ± 5% 17.1MB/s ± 3% +5.93% (p=0.000 n=10+9)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1048576-24 14.7MB/s ± 2% 15.1MB/s ± 3% +2.75% (p=0.008 n=9+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1048576-24 24.6MB/s ±10% 25.1MB/s ±15% ~ (p=0.853 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1048576-24 60.9MB/s ±14% 61.5MB/s ± 5% ~ (p=0.447 n=10+9)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1048576-24 166MB/s ± 1% 165MB/s ± 1% -0.80% (p=0.001 n=10+10)
name old alloc/op new alloc/op delta
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1-24 51.4kB ± 0% 48.0kB ± 0% -6.48% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32-24 56.6kB ± 0% 53.2kB ± 0% -5.97% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32-24 55.9kB ± 0% 52.6kB ± 0% -5.92% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32-24 55.2kB ± 0% 51.8kB ± 0% -6.03% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1024-24 443kB ± 0% 423kB ± 0% -4.51% (p=0.000 n=9+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1024-24 388kB ± 0% 377kB ± 0% -2.96% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1024-24 194kB ± 0% 191kB ± 0% -1.45% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1024-24 189kB ± 0% 181kB ± 0% -3.93% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1024-24 178kB ± 0% 175kB ± 0% -1.87% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32768-24 13.2MB ± 0% 12.6MB ± 0% -3.99% (p=0.000 n=8+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32768-24 11.4MB ± 0% 11.1MB ± 0% -2.87% (p=0.000 n=9+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32768-24 1.24MB ± 0% 1.21MB ± 0% -2.28% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=32768-24 874kB ± 0% 868kB ± 0% -0.73% (p=0.000 n=9+9)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=32768-24 790kB ± 0% 784kB ± 0% -0.68% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1048576-24 445MB ± 0% 428MB ± 0% -3.86% (p=0.000 n=10+8)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1048576-24 389MB ± 0% 378MB ± 0% -3.02% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1048576-24 26.0MB ± 0% 25.1MB ± 0% -3.29% (p=0.000 n=10+9)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1048576-24 7.23MB ± 0% 7.02MB ± 0% -2.90% (p=0.000 n=10+8)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1048576-24 2.12MB ± 0% 2.09MB ± 0% -1.35% (p=0.000 n=10+9)
name old allocs/op new allocs/op delta
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1-24 79.0 ± 0% 79.0 ± 0% ~ (all equal)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32-24 120 ± 0% 120 ± 0% ~ (all equal)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32-24 117 ± 0% 116 ± 0% -0.85% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32-24 84.0 ± 0% 84.0 ± 0% ~ (all equal)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1024-24 1.12k ± 0% 1.12k ± 0% -0.36% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1024-24 1.04k ± 0% 1.05k ± 0% +0.87% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1024-24 294 ± 0% 295 ± 0% +0.34% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1024-24 153 ± 0% 151 ± 0% -1.31% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1024-24 89.0 ± 0% 89.0 ± 0% ~ (all equal)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=32768-24 6.44k ± 0% 6.39k ± 0% -0.71% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=32768-24 6.89k ± 0% 6.90k ± 0% +0.20% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=32768-24 4.56k ± 0% 4.54k ± 0% -0.50% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=32768-24 2.01k ± 0% 2.01k ± 0% +0.05% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=32768-24 760 ± 0% 759 ± 0% -0.13% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1/numInputRows=1048576-24 33.8k ± 0% 33.9k ± 0% +0.15% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=2/numInputRows=1048576-24 29.8k ± 0% 29.7k ± 0% -0.09% (p=0.000 n=10+9)
Aggregator/MIN/hash/int/groupSize=32/numInputRows=1048576-24 22.4k ± 0% 22.4k ± 0% -0.13% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=128/numInputRows=1048576-24 22.2k ± 0% 22.3k ± 0% +0.29% (p=0.000 n=10+10)
Aggregator/MIN/hash/int/groupSize=1024/numInputRows=1048576-24 17.3k ± 0% 17.3k ± 0% -0.09% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=32768-24 11.0ms ± 3% 10.5ms ± 4% -4.01% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1024/numInputRows=32768-24 975µs ± 1% 969µs ± 2% ~ (p=0.280 n=10+10)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1/numInputRows=32768-24 138ms ± 1% 138ms ± 2% ~ (p=0.393 n=10+10)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1024/numInputRows=32768-24 3.77ms ± 1% 3.73ms ± 1% -1.11% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1/numInputRows=32768-24 12.4ms ± 5% 12.1ms ± 5% ~ (p=0.143 n=10+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1024/numInputRows=32768-24 1.00ms ± 2% 0.98ms ± 1% -2.48% (p=0.000 n=10+8)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1/numInputRows=32768-24 12.9ms ± 4% 12.3ms ± 4% -4.27% (p=0.002 n=10+10)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1024/numInputRows=32768-24 971µs ± 1% 968µs ± 1% ~ (p=0.278 n=9+10)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1/numInputRows=32768-24 16.3ms ± 3% 15.9ms ± 3% -2.42% (p=0.023 n=10+10)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1024/numInputRows=32768-24 2.18ms ± 2% 2.13ms ± 3% -2.51% (p=0.003 n=10+10)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1/numInputRows=32768-24 12.2ms ± 5% 11.8ms ± 5% ~ (p=0.052 n=10+10)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1024/numInputRows=32768-24 972µs ± 1% 979µs ± 2% ~ (p=0.143 n=10+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1/numInputRows=32768-24 12.3ms ± 3% 12.4ms ± 4% ~ (p=0.739 n=10+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1024/numInputRows=32768-24 1.06ms ± 2% 1.05ms ± 1% ~ (p=0.579 n=10+10)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1/numInputRows=32768-24 12.7ms ± 6% 12.4ms ± 5% ~ (p=0.190 n=10+10)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1024/numInputRows=32768-24 1.08ms ± 2% 1.06ms ± 2% -1.14% (p=0.015 n=10+10)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1/numInputRows=32768-24 20.8ms ± 3% 21.3ms ± 5% +2.42% (p=0.017 n=9+10)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1024/numInputRows=32768-24 3.53ms ± 1% 3.63ms ± 0% +2.77% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1/numInputRows=32768-24 12.5ms ± 5% 12.1ms ± 5% -3.04% (p=0.043 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1024/numInputRows=32768-24 1.06ms ± 1% 1.04ms ± 2% -1.47% (p=0.004 n=10+10)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1/numInputRows=32768-24 11.4ms ± 2% 11.4ms ± 5% ~ (p=1.000 n=10+10)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1024/numInputRows=32768-24 913µs ± 1% 897µs ± 1% -1.75% (p=0.000 n=10+10)
name old speed new speed delta
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=32768-24 23.9MB/s ± 3% 24.9MB/s ± 4% +4.20% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1024/numInputRows=32768-24 269MB/s ± 1% 271MB/s ± 2% ~ (p=0.280 n=10+10)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1/numInputRows=32768-24 1.90MB/s ± 1% 1.91MB/s ± 1% ~ (p=0.057 n=10+9)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1024/numInputRows=32768-24 69.6MB/s ± 1% 70.4MB/s ± 1% +1.12% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1/numInputRows=32768-24 2.65MB/s ± 5% 2.71MB/s ± 5% ~ (p=0.136 n=10+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1024/numInputRows=32768-24 32.7MB/s ± 2% 33.5MB/s ± 1% +2.54% (p=0.000 n=10+8)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1/numInputRows=32768-24 2.55MB/s ± 5% 2.66MB/s ± 4% +4.47% (p=0.001 n=10+10)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1024/numInputRows=32768-24 33.8MB/s ± 1% 33.8MB/s ± 1% ~ (p=0.323 n=9+10)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1/numInputRows=32768-24 16.1MB/s ± 3% 16.5MB/s ± 3% +2.44% (p=0.023 n=10+10)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1024/numInputRows=32768-24 120MB/s ± 2% 123MB/s ± 3% +2.58% (p=0.003 n=10+10)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1/numInputRows=32768-24 21.6MB/s ± 5% 22.3MB/s ± 5% ~ (p=0.050 n=10+10)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1024/numInputRows=32768-24 270MB/s ± 1% 268MB/s ± 2% ~ (p=0.143 n=10+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1/numInputRows=32768-24 21.3MB/s ± 3% 21.1MB/s ± 4% ~ (p=0.739 n=10+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1024/numInputRows=32768-24 248MB/s ± 2% 249MB/s ± 1% ~ (p=0.579 n=10+10)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1/numInputRows=32768-24 20.7MB/s ± 6% 21.1MB/s ± 5% ~ (p=0.190 n=10+10)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1024/numInputRows=32768-24 243MB/s ± 2% 246MB/s ± 2% +1.15% (p=0.015 n=10+10)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1/numInputRows=32768-24 12.6MB/s ± 3% 12.3MB/s ± 5% -2.34% (p=0.016 n=9+10)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1024/numInputRows=32768-24 74.2MB/s ± 1% 72.2MB/s ± 0% -2.70% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1/numInputRows=32768-24 20.9MB/s ± 5% 21.6MB/s ± 5% +3.17% (p=0.043 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1024/numInputRows=32768-24 248MB/s ± 1% 251MB/s ± 2% +1.51% (p=0.004 n=10+10)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1/numInputRows=32768-24 22.9MB/s ± 3% 23.0MB/s ± 5% ~ (p=0.986 n=10+10)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1024/numInputRows=32768-24 287MB/s ± 1% 292MB/s ± 1% +1.78% (p=0.000 n=10+10)
name old alloc/op new alloc/op delta
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=32768-24 13.3MB ± 0% 12.8MB ± 0% -4.05% (p=0.000 n=9+8)
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1024/numInputRows=32768-24 790kB ± 0% 784kB ± 0% -0.68% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1/numInputRows=32768-24 22.3MB ± 0% 22.2MB ± 0% -0.64% (p=0.000 n=9+10)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1024/numInputRows=32768-24 827kB ± 0% 827kB ± 0% -0.03% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1/numInputRows=32768-24 13.0MB ± 0% 12.4MB ± 0% -4.69% (p=0.000 n=9+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1024/numInputRows=32768-24 696kB ± 0% 691kB ± 0% -0.70% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1/numInputRows=32768-24 13.0MB ± 0% 12.6MB ± 0% -3.50% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1024/numInputRows=32768-24 696kB ± 0% 693kB ± 0% -0.40% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1/numInputRows=32768-24 13.7MB ± 0% 13.5MB ± 0% -1.50% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1024/numInputRows=32768-24 3.43MB ± 0% 3.42MB ± 0% -0.19% (p=0.000 n=10+7)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1/numInputRows=32768-24 13.0MB ± 0% 12.5MB ± 0% -3.42% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1024/numInputRows=32768-24 788kB ± 0% 784kB ± 0% -0.62% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1/numInputRows=32768-24 13.2MB ± 0% 12.8MB ± 0% -3.05% (p=0.000 n=9+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1024/numInputRows=32768-24 790kB ± 0% 786kB ± 0% -0.42% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1/numInputRows=32768-24 13.2MB ± 0% 12.6MB ± 0% -4.00% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1024/numInputRows=32768-24 790kB ± 0% 786kB ± 0% -0.42% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1/numInputRows=32768-24 17.7MB ± 0% 17.2MB ± 0% -2.81% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1024/numInputRows=32768-24 814kB ± 0% 816kB ± 0% +0.16% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1/numInputRows=32768-24 13.3MB ± 0% 12.6MB ± 0% -5.10% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1024/numInputRows=32768-24 790kB ± 0% 786kB ± 0% -0.42% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1/numInputRows=32768-24 12.8MB ± 0% 12.4MB ± 0% -3.46% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1024/numInputRows=32768-24 667kB ± 0% 666kB ± 0% -0.12% (p=0.000 n=9+10)
name old allocs/op new allocs/op delta
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1/numInputRows=32768-24 6.40k ± 0% 6.39k ± 0% -0.12% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/ANY_NOT_NULL/hash/int/groupSize=1024/numInputRows=32768-24 760 ± 0% 759 ± 0% -0.13% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1/numInputRows=32768-24 210k ± 0% 210k ± 0% +0.17% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/AVG/hash/int/groupSize=1024/numInputRows=32768-24 1.35k ± 0% 1.34k ± 0% -0.30% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1/numInputRows=32768-24 6.38k ± 0% 6.40k ± 0% +0.20% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_AND/hash/bool/groupSize=1024/numInputRows=32768-24 760 ± 0% 759 ± 0% -0.13% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1/numInputRows=32768-24 6.39k ± 0% 6.43k ± 0% +0.66% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/BOOL_OR/hash/bool/groupSize=1024/numInputRows=32768-24 760 ± 0% 760 ± 0% ~ (all equal)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1/numInputRows=32768-24 38.5k ± 0% 38.5k ± 0% +0.08% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/CONCAT_AGG/hash/bytes/groupSize=1024/numInputRows=32768-24 1.26k ± 0% 1.26k ± 0% ~ (all equal)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1/numInputRows=32768-24 6.38k ± 0% 6.36k ± 0% -0.30% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/COUNT/hash/int/groupSize=1024/numInputRows=32768-24 760 ± 0% 759 ± 0% -0.13% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1/numInputRows=32768-24 6.39k ± 0% 6.44k ± 0% +0.77% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/MAX/hash/int/groupSize=1024/numInputRows=32768-24 760 ± 0% 760 ± 0% ~ (all equal)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1/numInputRows=32768-24 6.44k ± 0% 6.39k ± 0% -0.87% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/MIN/hash/int/groupSize=1024/numInputRows=32768-24 760 ± 0% 760 ± 0% ~ (all equal)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1/numInputRows=32768-24 63.0k ± 0% 64.2k ± 0% +1.89% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM/hash/int/groupSize=1024/numInputRows=32768-24 1.08k ± 0% 1.11k ± 0% +3.15% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1/numInputRows=32768-24 6.35k ± 0% 6.38k ± 0% +0.38% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/SUM_INT/hash/int/groupSize=1024/numInputRows=32768-24 760 ± 0% 760 ± 0% ~ (all equal)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1/numInputRows=32768-24 6.20k ± 0% 6.17k ± 0% -0.42% (p=0.000 n=10+10)
AllOptimizedAggregateFunctions/COUNT_ROWS/hash/[]/groupSize=1024/numInputRows=32768-24 555 ± 0% 556 ± 0% +0.18% (p=0.000 n=10+10)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment