Compare commits

Home / Compare 39c2b97d .. 461fc5d9

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.582-54.580=0.002
σ0.341-0.342=-0.001
min54.456-54.450=0.006
max55.552-55.552=-0.000
mean418.000-422.000=-4.000
σ0.000
min418.000-422.000=-4.000
max418.000-422.000=-4.000
mean0.144-0.137=0.006
σ0.004-0.006=-0.002
min0.139-0.130=0.009
max0.150-0.145=0.005
cache=y
dps=1
iters=10
policies=100
mean43.704-43.704=-0.001
σ0.005-0.007=-0.002
min43.696-43.697=-0.001
max43.710-43.718=-0.008
mean418.000-422.000=-4.000
σ0.000
min418.000-422.000=-4.000
max418.000-422.000=-4.000
mean0.123-0.122=0.000
σ0.004-0.005=-0.001
min0.120-0.116=0.004
max0.132-0.130=0.001

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618-36.618=-0.000
σ0.002-0.002=-0.000
min36.615
max36.620-36.620=-0.000
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean12.778-12.829=-0.052
σ0.260-0.264=-0.004
min12.491-12.511=-0.020
max13.105-13.184=-0.079
op=column_set() on indexed, repeat
mean36.617-36.617=-0.000
σ0.002-0.002=0.000
min36.616-36.615=0.000
max36.620-36.619=0.000
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean12.969-12.786=0.182
σ0.608-0.616=-0.009
min11.795-11.923=-0.128
max13.620-13.560=0.060
op=table_records(), no indexes
mean41.932-41.932=0.000
σ0.001-0.001=-0.000
min41.928
max41.933-41.933=-0.000
mean7283.000-7306.000=-23.000
σ0.000
min7283.000-7306.000=-23.000
max7283.000-7306.000=-23.000
mean15.355-15.177=0.178
σ0.402-0.685=-0.283
min14.499-13.637=0.863
max15.801-15.701=0.100
op=table_records(), repeat
mean41.928-41.928=0.000
σ0.002-0.002=-0.000
min41.927-41.927=-0.000
max41.931-41.932=-0.001
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean12.750-12.739=0.010
σ1.877-1.674=0.203
min10.780-10.430=0.350
max15.358-15.556=-0.198
op=vertical_lookup_list() on indexed, after table_records()
mean27.653
σ0.136-0.136=-0.000
min27.603-27.603=0.000
max27.990-27.990=-0.000
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean8.931-8.902=0.028
σ0.198-0.364=-0.166
min8.655-8.337=0.318
max9.210-9.374=-0.163
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.400-26.400=-0.000
σ0.002-0.002=0.000
min26.399
max26.403
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean7.020-6.997=0.023
σ0.080-0.197=-0.118
min6.924-6.751=0.173
max7.175-7.340=-0.165
op=vertical_lookup_row_list() on 2 indexed
mean25.666-25.666=0.000
σ0.002-0.002=-0.000
min25.665-25.664=0.000
max25.668-25.669=-0.000
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean6.012-5.940=0.073
σ0.111-0.158=-0.048
min5.816-5.669=0.148
max6.129-6.169=-0.040
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968-25.968=0.000
σ0.002-0.002=0.000
min25.967-25.967=0.000
max25.972-25.972=0.000
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean5.818-5.767=0.052
σ0.091-0.064=0.027
min5.715-5.654=0.061
max5.993-5.812=0.181

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.606-2524.606=-0.000
σ0.000-0.000=0.000
min2524.606
max2524.606
mean7283.000-7306.000=-23.000
σ0.000
min7283.000-7306.000=-23.000
max7283.000-7306.000=-23.000
mean1511.307-1098.208=413.100
σ911.319-144.847=766.473
min1031.672-1037.471=-5.799
max3681.890-1456.470=2225.420
op=load_product(), with indexes
mean8744.721-8744.721=0.000
σ0.469-0.469=0.000
min8744.553-8744.553=0.000
max8745.883-8745.882=0.001
mean3571.250-3573.750=-2.500
σ1794.478-1797.375=-2.896
min1045.000-1044.000=1.000
max5788.000-5796.000=-8.000
mean4905.258-4566.205=339.053
σ1695.038-1356.135=338.903
min3509.229-3522.716=-13.487
max7375.746-6714.801=660.945

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.078-62.078=-0.000
σ0.002-0.002=0.000
min62.076-62.076=-0.000
max62.081-62.081=0.000
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean85.667-80.594=5.073
σ12.925-11.307=1.618
min68.901-70.406=-1.505
max102.578-101.617=0.961
op=vertical_lookup_list() on unindexed missing Int
mean40.944-40.944=0.000
σ0.001-0.001=-0.000
min40.944-40.944=0.000
max40.945
mean7283.000-7306.000=-23.000
σ0.000
min7283.000-7306.000=-23.000
max7283.000-7306.000=-23.000
mean106.881-106.516=0.366
σ2.729-4.841=-2.112
min102.142-97.062=5.080
max110.271-112.371=-2.100
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686-66.686=-0.000
σ0.000-0.000=0.000
min66.685
max66.687
mean7283.000-7306.000=-23.000
σ0.000
min7283.000-7306.000=-23.000
max7283.000-7306.000=-23.000
mean163.761-164.001=-0.240
σ4.538-9.064=-4.526
min154.659-142.800=11.858
max167.248-169.298=-2.050

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.836-11656.836=-0.000
σ4.324-4.324=0.000
min11655.305
max11667.538
mean4149.625-4153.750=-4.125
σ1894.383-1901.212=-6.829
min1556.000-1553.000=3.000
max7283.000-7306.000=-23.000
mean6888.190-6572.602=315.588
σ1214.280-1169.981=44.299
min4905.865-4966.838=-60.973
max8376.110-8180.054=196.056
op=vertical_lookup_list() on indexed
mean11560.065-11560.065=0.000
σ0.001-0.001=-0.000
min11560.064
max11560.066
mean7283.000-7306.000=-23.000
σ0.000
min7283.000-7306.000=-23.000
max7283.000-7306.000=-23.000
mean5279.983-5455.781=-175.798
σ1216.724-1436.626=-219.901
min4335.640-4395.637=-59.997
max7605.605-7738.241=-132.636

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.559
σ0.001
min172.558
max172.562
mean478.000
σ0.000
min478.000
max478.000
mean382.633-382.597=0.036
σ18.531-22.319=-3.788
min337.148-339.857=-2.709
max392.145-400.582=-8.438
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean562.000-561.000=1.000
σ0.000
min562.000-561.000=1.000
max562.000-561.000=1.000
mean746.991-756.707=-9.716
σ45.273-51.836=-6.564
min645.551-633.244=12.308
max779.049-788.342=-9.293

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.501-1008.500=0.000
σ0.759-0.759=-0.000
min1008.026-1008.026=0.000
max1011.642-1011.641=0.000
mean1047.400-1046.750=0.650
σ312.417-313.527=-1.111
min583.000-572.000=11.000
max1512.000-1509.000=3.000
mean1.550-1.553=-0.002
σ0.085-0.083=0.001
min1.404-1.481=-0.076
max1.754-1.772=-0.017

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.913
σ0.020
min0.903
max0.949
mean402.000
σ0.000
min402.000
max402.000
mean0.296-0.319=-0.023
σ0.284-0.336=-0.052
min0.137-0.147=-0.010
max0.799-0.916=-0.118
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.482-0.478=0.004
σ0.327-0.326=0.001
min0.327-0.322=0.005
max1.067-1.061=0.006
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.225-0.217=0.008
σ0.020-0.022=-0.002
min0.208-0.202=0.006
max0.258-0.255=0.003
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.388-0.343=0.045
σ0.113-0.015=0.099
min0.327-0.331=-0.004
max0.589-0.368=0.221

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.741
σ0.011
min964.736
max964.760
mean436.000-431.000=5.000
σ2.236-0.000=2.236
min432.000-431.000=1.000
max437.000-431.000=6.000
mean0.552-0.546=0.006
σ0.037-0.028=0.009
min0.501-0.529=-0.028
max0.589-0.596=-0.008
name=cdr_enhanced_4k_loc.art
mean885.814
σ0.002
min885.812
max885.816
mean443.000-431.000=12.000
σ0.000
min443.000-431.000=12.000
max443.000-431.000=12.000
mean0.468-0.481=-0.013
σ0.015-0.039=-0.024
min0.453-0.435=0.018
max0.491-0.525=-0.034

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.708
σ0.002
min7.707
max7.711
mean443.000-431.000=12.000
σ0.000
min443.000-431.000=12.000
max443.000-431.000=12.000
mean2.620-1.978=0.642
σ0.113-0.088=0.026
min2.442-1.819=0.623
max3.379-2.369=1.009
name=record_render_large_syntax_err.art
mean7.656
σ0.002
min7.655
max7.659
mean443.000-431.000=12.000
σ0.000
min443.000-431.000=12.000
max443.000-431.000=12.000
mean2.558-1.944=0.614
σ0.058-0.063=-0.006
min2.402-1.841=0.561
max2.677-2.191=0.486
name=record_render_success.art
mean2.289
σ0.002
min2.288
max2.292
mean443.000-431.000=12.000
σ0.000
min443.000-431.000=12.000
max443.000-431.000=12.000
mean0.306-0.306=0.000
σ0.028-0.012=0.017
min0.286-0.288=-0.002
max0.573-0.369=0.204
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean443.000-431.000=12.000
σ0.000
min443.000-431.000=12.000
max443.000-431.000=12.000
mean0.290-0.286=0.004
σ0.007-0.007=-0.000
min0.277-0.272=0.005
max0.330-0.318=0.013

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean298.205-298.280=-0.075
σ0.998-1.004=-0.006
min297.732-297.827=-0.096
max301.035-301.130=-0.096
mean442.600-441.000=1.600
σ13.680-15.449=-1.768
min418.000
max462.000-463.000=-1.000
mean0.620-0.614=0.006
σ0.012-0.008=0.004
min0.592-0.605=-0.014
max0.634-0.632=0.002

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.011-222.011=0.000
σ0.000-0.000=0.000
min222.011
max222.011-222.011=0.000
mean1733.250-1759.125=-25.875
σ9.721-13.789=-4.067
min1728.000-1725.000=3.000
max1749.000-1764.000=-15.000
mean204.259-209.089=-4.830
σ2.466-3.468=-1.002
min201.308-203.658=-2.349
max209.109-215.118=-6.009
phase=macro expansion
mean6.133
σ0.000
min6.133
max6.133
mean1733.250-1759.125=-25.875
σ9.721-13.789=-4.067
min1728.000-1725.000=3.000
max1749.000-1764.000=-15.000
mean8.571-8.550=0.021
σ3.619-1.857=1.762
min6.106-6.194=-0.087
max15.406-10.029=5.377
phase=parser
mean1042.098-1042.098=-0.000
σ0.000-0.000=0.000
min1042.097-1042.098=-0.001
max1042.098
mean1733.250-1759.125=-25.875
σ9.721-13.789=-4.067
min1728.000-1725.000=3.000
max1749.000-1764.000=-15.000
mean617.534-677.226=-59.692
σ148.866-124.389=24.477
min381.181-376.389=4.792
max833.104-756.624=76.480
phase=processProdDef
mean6169.657-6169.657=0.000
σ0.001-0.000=0.000
min6169.657
max6169.658-6169.658=0.001
mean1735.875-1764.000=-28.125
σ10.869-0.000=10.869
min1728.000-1764.000=-36.000
max1749.000-1764.000=-15.000
mean6090.474-5703.854=386.620
σ1177.854-1720.161=-542.307
min3875.125-3482.923=392.202
max7313.452-7823.440=-509.988
phase=renaming
mean21.667
σ0.000
min21.667
max21.667
mean1733.250-1759.125=-25.875
σ9.721-13.789=-4.067
min1728.000-1725.000=3.000
max1749.000-1764.000=-15.000
mean35.168-29.876=5.292
σ12.247-4.469=7.778
min19.611-19.942=-0.331
max54.754-35.385=19.370
phase=type checker
mean958.457
σ0.066
min958.360
max958.547
mean1733.250-1759.125=-25.875
σ9.721-13.789=-4.067
min1728.000-1725.000=3.000
max1749.000-1764.000=-15.000
mean766.169-695.112=71.057
σ112.091-71.332=40.758
min622.483-629.572=-7.089
max927.450-830.174=97.276

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.687-293.688=-0.001
σ0.038-0.037=0.000
min293.634-293.635=-0.001
max293.726-293.727=-0.001
mean446.200-445.000=1.200
σ0.447-0.000=0.447
min446.000-445.000=1.000
max447.000-445.000=2.000
mean0.392-0.399=-0.007
σ0.001-0.001=0.000
min0.390-0.397=-0.007
max0.393-0.400=-0.007
iters=5
new-facts=1
prior-facts=6402
mean1303.729-1303.769=-0.040
σ0.091-0.065=0.027
min1303.627-1303.718=-0.091
max1303.840-1303.856=-0.017
mean1096.000
σ174.578-187.250=-12.672
min888.000-838.000=50.000
max1337.000-1321.000=16.000
mean1.983-2.017=-0.034
σ0.090-0.201=-0.111
min1.921-1.841=0.080
max2.141-2.302=-0.161
iters=5
new-facts=6402
prior-facts=1
mean1546.839-1546.825=0.014
σ4.034-4.006=0.028
min1544.852-1544.847=0.005
max1554.050-1553.986=0.065
mean623.400-618.000=5.400
σ88.794-80.025=8.769
min507.000-497.000=10.000
max727.000-712.000=15.000
mean2.373-2.258=0.114
σ0.309-0.114=0.195
min2.094-2.158=-0.064
max2.867-2.428=0.440
iters=5
new-facts=6402
prior-facts=6402
mean1865.808-1865.808=0.001
σ0.050-0.052=-0.002
min1865.742-1865.735=0.007
max1865.881-1865.882=-0.001
mean1707.200-1735.000=-27.800
σ181.370-192.434=-11.064
min1464.000
max1878.000-1912.000=-34.000
mean3.017-3.038=-0.020
σ0.208-0.306=-0.098
min2.864-2.735=0.129
max3.382-3.543=-0.162

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.752-1.751=0.001
σ0.147-0.079=0.068
min1.569-1.618=-0.049
max1.943-1.829=0.114

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean450.088-450.090=-0.002
σ579.265-579.265=0.000
min160.452-160.457=-0.005
max1318.985-1318.987=-0.002
mean102.250
σ8.500
min98.000
max115.000
mean443.000
σ0.000
min443.000
max443.000
mean0.529-0.543=-0.014
σ0.517-0.548=-0.031
min0.266-0.267=-0.001
max1.303-1.364=-0.061
policies=20
mean1604.887-1604.881=0.007
σ0.402-0.361=0.041
min1604.607-1604.624=-0.018
max1605.481-1605.413=0.068
mean980.000
σ0.000
min980.000
max980.000
mean446.750-446.000=0.750
σ2.500-2.000=0.500
min443.000
max448.000-447.000=1.000
mean2.672-2.669=0.003
σ0.018-0.010=0.008
min2.656-2.655=0.002
max2.692-2.677=0.015
policies=200
mean16057.201-16057.180=0.021
σ0.101-0.210=-0.109
min16057.057-16057.028=0.028
max16057.273-16057.489=-0.215
mean9800.000
σ0.000
min9800.000
max9800.000
mean495.500-498.000=-2.500
σ2.082-6.782=-4.701
min493.000-490.000=3.000
max498.000-505.000=-7.000
mean26.945-26.996=-0.051
σ0.081-0.139=-0.058
min26.864-26.838=0.026
max27.048-27.163=-0.115