Skip to content

Instantly share code, notes, and snippets.

@yuzefovich

yuzefovich/unordered distinct benchmarks

Created December 4, 2020 18:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yuzefovich/95183bbf460d053f0743e2f2641057bc to your computer and use it in GitHub Desktop.
Save yuzefovich/95183bbf460d053f0743e2f2641057bc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
unordered distinct benchmarks
name old time/op new time/op delta
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 12.7µs ± 1% 13.2µs ± 1% +3.82% (p=0.000 n=10+8)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 20.1µs ± 2% 21.8µs ± 5% +8.01% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 15.2µs ± 2% 16.0µs ± 2% +5.67% (p=0.000 n=10+8)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 23.6µs ± 3% 24.7µs ± 1% +4.32% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 116µs ± 1% 122µs ± 1% +4.39% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 176µs ± 1% 181µs ± 0% +2.77% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 8.18ms ± 0% 14.18ms ± 1% +73.31% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 12.9ms ± 0% 11.2ms ± 0% -12.85% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 12.8µs ± 2% 13.3µs ± 2% +3.47% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 20.0µs ± 1% 21.1µs ± 3% +5.07% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 16.2µs ± 2% 16.5µs ± 2% +1.57% (p=0.035 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 26.0µs ± 5% 25.7µs ± 4% ~ (p=0.247 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 264µs ± 0% 304µs ± 0% +15.16% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 484µs ± 0% 513µs ± 0% +5.97% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 11.1ms ± 1% 11.4ms ± 1% +2.64% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 17.1ms ± 1% 17.6ms ± 1% +3.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 13.0µs ± 4% 13.3µs ± 2% +2.89% (p=0.019 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 20.5µs ± 2% 21.3µs ± 2% +4.05% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 16.9µs ± 2% 17.6µs ± 2% +4.12% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 26.6µs ± 1% 27.5µs ± 1% +3.22% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 190µs ± 0% 192µs ± 0% +1.26% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 319µs ± 0% 326µs ± 1% +2.22% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 21.6ms ± 0% 13.9ms ± 0% -35.62% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 46.0ms ± 1% 25.9ms ± 0% -43.79% (p=0.000 n=10+9)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 13.2µs ± 2% 13.6µs ± 2% +2.88% (p=0.000 n=10+9)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 20.6µs ± 1% 22.4µs ± 4% +8.55% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 18.0µs ± 2% 18.4µs ± 2% +2.21% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 28.0µs ± 1% 28.6µs ± 1% +2.40% (p=0.000 n=10+9)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 583µs ± 0% 675µs ± 0% +15.75% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 1.15ms ± 0% 0.96ms ± 2% -16.57% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 17.3ms ± 1% 17.9ms ± 1% +3.00% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 30.2ms ± 1% 31.1ms ± 0% +2.99% (p=0.000 n=10+10)
name old speed new speed delta
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 1.25MB/s ± 1% 1.21MB/s ± 0% -3.46% (p=0.000 n=9+6)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 1.59MB/s ± 2% 1.47MB/s ± 5% -7.48% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 67.5MB/s ± 2% 63.9MB/s ± 2% -5.37% (p=0.000 n=10+8)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 86.7MB/s ± 3% 83.1MB/s ± 1% -4.16% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 563MB/s ± 1% 539MB/s ± 1% -4.20% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 746MB/s ± 1% 726MB/s ± 0% -2.70% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 513MB/s ± 0% 296MB/s ± 1% -42.30% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 650MB/s ± 0% 746MB/s ± 0% +14.75% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 1.25MB/s ± 2% 1.21MB/s ± 2% -3.52% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 1.60MB/s ± 1% 1.52MB/s ± 3% -4.70% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 63.2MB/s ± 2% 62.3MB/s ± 2% -1.55% (p=0.035 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 78.9MB/s ± 5% 79.6MB/s ± 4% ~ (p=0.247 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 248MB/s ± 0% 216MB/s ± 0% -13.17% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 271MB/s ± 0% 255MB/s ± 0% -5.63% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 378MB/s ± 1% 368MB/s ± 1% -2.58% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 491MB/s ± 1% 477MB/s ± 1% -2.94% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 1.23MB/s ± 4% 1.19MB/s ± 1% -3.18% (p=0.014 n=10+8)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 1.56MB/s ± 2% 1.50MB/s ± 2% -4.12% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 60.6MB/s ± 2% 58.2MB/s ± 2% -3.95% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 76.9MB/s ± 1% 74.5MB/s ± 1% -3.12% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 345MB/s ± 0% 341MB/s ± 0% -1.25% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 411MB/s ± 0% 402MB/s ± 1% -2.17% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 194MB/s ± 0% 301MB/s ± 0% +55.33% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 182MB/s ± 1% 324MB/s ± 0% +77.90% (p=0.000 n=10+9)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 1.22MB/s ± 1% 1.17MB/s ± 3% -3.42% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 1.55MB/s ± 2% 1.43MB/s ± 4% -7.56% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 57.0MB/s ± 2% 55.7MB/s ± 2% -2.16% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 73.2MB/s ± 1% 71.5MB/s ± 1% -2.34% (p=0.000 n=10+9)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 112MB/s ± 0% 97MB/s ± 0% -13.60% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 114MB/s ± 0% 136MB/s ± 2% +19.87% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 242MB/s ± 1% 235MB/s ± 1% -2.91% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 278MB/s ± 1% 270MB/s ± 0% -2.90% (p=0.000 n=10+10)
name old alloc/op new alloc/op delta
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 29.9kB ± 0% 29.9kB ± 0% -0.05% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 47.7kB ± 0% 47.6kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 32.6kB ± 0% 32.6kB ± 0% -0.05% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 50.4kB ± 0% 50.4kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 77.3kB ± 0% 78.2kB ± 0% +1.22% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 98.1kB ± 0% 98.6kB ± 0% +0.49% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 317kB ± 0% 363kB ± 0% +14.56% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 564kB ± 0% 613kB ± 0% +8.76% (p=0.000 n=9+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 29.9kB ± 0% 29.9kB ± 0% -0.05% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 47.7kB ± 0% 47.6kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 33.0kB ± 0% 33.1kB ± 0% +0.10% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 51.1kB ± 0% 51.1kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 114kB ± 0% 152kB ± 0% +33.40% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 160kB ± 0% 222kB ± 0% +38.71% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 4.14MB ± 0% 4.18MB ± 0% +0.98% (p=0.000 n=9+9)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 6.62MB ± 0% 6.68MB ± 0% +0.91% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 29.9kB ± 0% 29.9kB ± 0% -0.05% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 47.7kB ± 0% 47.6kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 32.7kB ± 0% 32.7kB ± 0% -0.05% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 50.5kB ± 0% 50.5kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 78.0kB ± 0% 77.8kB ± 0% -0.18% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 97.8kB ± 0% 99.3kB ± 0% +1.53% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 300kB ± 0% 375kB ± 0% +25.25% (p=0.000 n=9+8)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 537kB ± 0% 635kB ± 0% +18.24% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 29.9kB ± 0% 29.9kB ± 0% -0.05% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 47.7kB ± 0% 47.6kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 33.5kB ± 0% 33.4kB ± 0% -0.24% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 51.2kB ± 0% 51.2kB ± 0% -0.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 115kB ± 0% 140kB ± 0% +21.69% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 159kB ± 0% 209kB ± 0% +31.14% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 4.14MB ± 0% 4.18MB ± 0% +0.98% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 6.62MB ± 0% 6.70MB ± 0% +1.21% (p=0.000 n=9+10)
name old allocs/op new allocs/op delta
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 61.0 ± 0% 61.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 97.0 ± 0% 97.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 61.0 ± 0% 61.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 97.0 ± 0% 97.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 100 ± 0% 124 ± 0% +24.00% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 174 ± 0% 189 ± 0% +8.62% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 2.98k ± 0% 3.10k ± 0% +4.03% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 5.94k ± 0% 6.05k ± 0% +1.75% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 61.0 ± 0% 61.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 97.0 ± 0% 97.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 67.0 ± 0% 67.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 109 ± 0% 109 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 123 ± 0% 156 ± 0% +26.83% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 217 ± 0% 274 ± 0% +26.27% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 3.21k ± 0% 3.26k ± 0% +1.37% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=false/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 6.37k ± 0% 6.45k ± 0% +1.19% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=2/ordCols=0-24 61.0 ± 0% 61.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=1/cols=4/ordCols=0-24 97.0 ± 0% 97.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=2/ordCols=0-24 63.0 ± 0% 63.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=64/cols=4/ordCols=0-24 101 ± 0% 101 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=2/ordCols=0-24 105 ± 0% 110 ± 0% +4.76% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=4096/cols=4/ordCols=0-24 165 ± 0% 193 ± 0% +16.97% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=2/ordCols=0-24 2.97k ± 0% 3.09k ± 0% +4.04% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.001/rows=262144/cols=4/ordCols=0-24 5.86k ± 0% 6.04k ± 0% +3.04% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=2/ordCols=0-24 61.0 ± 0% 61.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=1/cols=4/ordCols=0-24 97.0 ± 0% 97.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=2/ordCols=0-24 69.0 ± 0% 69.0 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=64/cols=4/ordCols=0-24 109 ± 0% 109 ± 0% ~ (all equal)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=2/ordCols=0-24 123 ± 0% 156 ± 0% +26.83% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=4096/cols=4/ordCols=0-24 217 ± 0% 274 ± 0% +26.27% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=2/ordCols=0-24 3.21k ± 0% 3.26k ± 0% +1.37% (p=0.000 n=10+10)
Distinct/Unordered/hasNulls=true/newTupleProbability=0.100/rows=262144/cols=4/ordCols=0-24 6.37k ± 0% 6.45k ± 0% +1.19% (p=0.000 n=10+10)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment