Compare commits

Home / Compare f3e892be .. c0f47993

grey: no significant change wrt stddev
red: change exceeding max stddev
purple: some change, not seemingly significant

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.617-54.054=0.562
σ0.351-0.370=-0.019
min54.480-53.909=0.571
max55.616-55.108=0.508
mean417.000-415.000=2.000
σ0.000
min417.000-415.000=2.000
max417.000-415.000=2.000
mean0.141-0.140=0.001
σ0.004-0.005=-0.001
min0.137-0.132=0.006
max0.148-0.147=0.001
cache=y
dps=1
iters=10
policies=100
mean43.785-43.393=0.393
σ0.005-0.007=-0.002
min43.778-43.384=0.394
max43.797-43.407=0.390
mean417.000-415.000=2.000
σ0.000
min417.000-415.000=2.000
max417.000-415.000=2.000
mean0.122-0.121=0.001
σ0.005-0.004=0.001
min0.117-0.115=0.001
max0.131-0.130=0.001

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.003
min36.615
max36.623
mean4269.000
σ1880.401
min1984.000
max7554.000
mean12.760
σ1.742
min11.839
max16.980
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.619
mean4269.000
σ1880.401
min1984.000
max7554.000
mean12.242
σ2.202
min11.110
max17.562
op=table_records(), no indexes
mean41.928
σ0.000
min41.928
max41.929
mean7554.000
σ0.000
min7554.000
max7554.000
mean13.767
σ1.173
min12.308
max15.317
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.932
mean4269.000
σ1880.401
min1984.000
max7554.000
mean11.999
σ1.982
min9.992
max15.135
op=vertical_lookup_list() on indexed, after table_records()
mean27.605
σ0.002
min27.603
max27.607
mean4269.000
σ1880.401
min1984.000
max7554.000
mean8.706
σ1.171
min7.829
max11.505
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400
σ0.002
min26.399
max26.403
mean4269.000
σ1880.401
min1984.000
max7554.000
mean6.526
σ1.168
min5.787
max9.374
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4269.000
σ1880.401
min1984.000
max7554.000
mean5.588
σ0.583
min5.099
max6.934
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4269.000
σ1880.401
min1984.000
max7554.000
mean5.195
σ0.572
min4.716
max6.517

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.593
σ0.000
min2524.593
max2524.594
mean7554.000
σ0.000
min7554.000
max7554.000
mean1106.087
σ169.576
min1040.152
max1525.658
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.544
max8744.641
mean3791.375
σ1610.309
min1984.000
max5953.000
mean4655.295
σ1479.609
min3540.960
max7039.120

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078
σ0.002
min62.075
max62.080
mean4269.000
σ1880.401
min1984.000
max7554.000
mean83.713
σ12.712
min69.068
max104.720
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7554.000
σ0.000
min7554.000
max7554.000
mean233.445
σ374.864
min89.191
max1160.996
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.686
mean7554.000
σ0.000
min7554.000
max7554.000
mean150.430
σ13.786
min132.158
max169.614

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.318
min11655.305
max11667.521
mean4269.000
σ1880.401
min1984.000
max7554.000
mean6430.850
σ1141.046
min4954.368
max8353.089
op=vertical_lookup_list() on indexed
mean11560.069
σ0.002
min11560.066
max11560.072
mean7554.000
σ0.000
min7554.000
max7554.000
mean5562.530
σ1297.039
min4429.761
max7421.386

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.583
σ0.025
min172.558
max172.625
mean1984.000
σ0.000
min1984.000
max1984.000
mean366.525
σ23.389
min340.762
max398.240
op=pointedIndexFromKvs
rows=400000
mean357.364
σ0.042
min357.321
max357.408
mean1984.000
σ0.000
min1984.000
max1984.000
mean729.512
σ76.289
min602.890
max796.626

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.188-1007.005=1.183
σ0.880-1.200=-0.321
min1007.687-1006.443=1.244
max1011.834-1012.039=-0.205
mean1038.800-1050.200=-11.400
σ296.897-309.011=-12.114
min547.000-574.000=-27.000
max1439.000-1647.000=-208.000
mean1.575-1.557=0.018
σ0.131-0.080=0.050
min1.483-1.481=0.002
max2.057-1.777=0.280

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883-0.883=-0.000
σ0.002-0.003=-0.000
min0.881-0.882=-0.000
max0.886-0.887=-0.001
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.416-0.419=-0.003
σ0.127-0.137=-0.010
min0.333-0.332=0.001
max0.641-0.661=-0.021
name=error_case.art
mean2.333-2.339=-0.006
σ0.003-0.002=0.000
min2.332-2.337=-0.005
max2.337-2.342=-0.005
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.889-0.865=0.024
σ0.090-0.099=-0.009
min0.831-0.802=0.029
max1.045-1.039=0.005
name=heavy_item.art
mean1.521-1.524=-0.002
σ0.002
min1.520-1.522=-0.002
max1.524-1.526=-0.002
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.546-0.522=0.024
σ0.050-0.050=0.000
min0.517-0.486=0.031
max0.636-0.607=0.029
name=nested_use.art
mean2.355-2.361=-0.005
σ0.002
min2.355-2.360=-0.005
max2.358-2.364=-0.005
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.847-0.838=0.009
σ0.041-0.040=0.001
min0.818-0.795=0.023
max0.919-0.901=0.018

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.543-964.839=-1.297
σ0.030-0.035=-0.004
min963.523-964.811=-1.288
max963.596-964.897=-1.301
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.808-0.842=-0.034
σ0.036-0.031=0.005
min0.760-0.788=-0.029
max0.858-0.865=-0.008
name=cdr_enhanced_4k_loc.art
mean884.854-885.512=-0.658
σ0.006-0.007=-0.002
min884.847-885.504=-0.657
max884.862-885.523=-0.661
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.708-0.726=-0.018
σ0.040-0.030=0.010
min0.672-0.675=-0.003
max0.753-0.753=-0.001

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706-7.716=-0.010
σ0.002-0.002=-0.000
min7.705-7.715=-0.010
max7.709-7.720=-0.011
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean4.229-4.208=0.021
σ0.120-0.090=0.030
min4.105-4.046=0.059
max5.140-4.575=0.565
name=record_render_large_syntax_err.art
mean7.655-7.665=-0.010
σ0.002
min7.654-7.664=-0.010
max7.658-7.668=-0.010
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean4.211-4.215=-0.004
σ0.063-0.092=-0.030
min4.086-4.030=0.056
max4.400-4.599=-0.199
name=record_render_success.art
mean2.288-2.291=-0.003
σ0.002
min2.287-2.290=-0.003
max2.291-2.294=-0.003
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.754-0.739=0.015
σ0.016-0.018=-0.002
min0.721-0.700=0.021
max0.849-0.848=0.001
name=record_render_syntax_err.art
mean2.163-2.166=-0.002
σ0.002
min2.163-2.165=-0.002
max2.166-2.169=-0.002
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.713-0.694=0.019
σ0.014-0.016=-0.003
min0.684-0.665=0.020
max0.781-0.785=-0.004

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.406-296.833=0.573
σ0.204-0.221=-0.017
min297.207-296.701=0.506
max297.891-297.428=0.463
mean1984.000-1902.000=82.000
σ0.000
min1984.000-1902.000=82.000
max1984.000-1902.000=82.000
mean0.566-0.587=-0.021
σ0.034-0.054=-0.020
min0.508-0.509=-0.001
max0.593-0.702=-0.109

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.760-286.820=2.940
σ0.044-0.037=0.007
min289.722-286.770=2.952
max289.811-286.857=2.953
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.404-0.393=0.011
σ0.011-0.006=0.004
min0.394-0.386=0.008
max0.420-0.400=0.020
iters=5
new-facts=1
prior-facts=6402
mean1299.691-1297.271=2.420
σ0.092-0.091=0.001
min1299.581-1297.158=2.423
max1299.819-1297.397=2.422
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean2.275-2.269=0.006
σ0.094-0.159=-0.065
min2.150-2.139=0.011
max2.349-2.544=-0.195
iters=5
new-facts=6402
prior-facts=1
mean1542.665-1541.344=1.321
σ4.004-6.841=-2.837
min1540.705-1538.091=2.614
max1549.822-1553.578=-3.755
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean2.308-2.242=0.065
σ0.129-0.170=-0.041
min2.177-2.130=0.047
max2.481-2.544=-0.063
iters=5
new-facts=6402
prior-facts=6402
mean1861.628-1859.119=2.509
σ0.064-0.066=-0.002
min1861.541-1859.030=2.510
max1861.706-1859.196=2.510
mean1771.000-1777.400=-6.400
σ224.690-125.801=98.889
min1475.000-1647.000=-172.000
max1984.000-1902.000=82.000
mean3.242-3.123=0.119
σ0.343-0.285=0.058
min2.875-2.833=0.042
max3.667-3.550=0.117

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.788-1.194=0.594
σ0.160-0.318=-0.159
min1.509-0.930=0.579
max1.906-1.612=0.294

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.185-448.822=-2.637
σ577.140-581.372=-4.232
min157.612-158.134=-0.522
max1311.895-1320.879=-8.984
mean96.250
σ8.500
min92.000
max109.000
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean0.534-0.562=-0.028
σ0.539-0.598=-0.059
min0.261-0.261=0.000
max1.342-1.459=-0.116
policies=20
mean1576.434-1581.629=-5.195
σ0.372-0.360=0.012
min1576.188-1581.386=-5.197
max1576.987-1582.163=-5.176
mean920.000
σ0.000
min920.000
max920.000
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean2.666-2.638=0.028
σ0.068-0.014=0.054
min2.624-2.630=-0.006
max2.768-2.659=0.109
policies=200
mean15772.285-15824.126=-51.841
σ0.044-0.166=-0.123
min15772.247-15824.024=-51.777
max15772.327-15824.373=-52.046
mean9200.000
σ0.000
min9200.000
max9200.000
mean1439.000-1647.000=-208.000
σ0.000
min1439.000-1647.000=-208.000
max1439.000-1647.000=-208.000
mean26.502-26.630=-0.127
σ0.034-0.038=-0.004
min26.464-26.603=-0.139
max26.546-26.686=-0.140