Compare commits

Home / Compare 48ffdb48 .. 5f4ab20e

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.577-54.577=-0.001
σ0.349-0.349=0.000
min54.441-54.445=-0.004
max55.569-55.569=-0.000
mean417.000-416.000=1.000
σ0.000
min417.000-416.000=1.000
max417.000-416.000=1.000
mean0.140-0.136=0.003
σ0.005-0.004=0.001
min0.132-0.132=0.000
max0.149-0.142=0.008
cache=y
dps=1
iters=10
policies=100
mean43.705-43.706=-0.001
σ0.006-0.005=0.001
min43.696-43.699=-0.003
max43.716-43.716=-0.000
mean417.000-416.000=1.000
σ0.000
min417.000-416.000=1.000
max417.000-416.000=1.000
mean0.121-0.123=-0.002
σ0.005-0.004=0.001
min0.116-0.120=-0.004
max0.129-0.132=-0.003

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.619-36.620=-0.000
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean12.718-12.480=0.238
σ0.310-0.247=0.064
min12.339-12.107=0.232
max13.307-12.796=0.511
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.620=-0.000
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean13.148-12.752=0.397
σ0.291-0.499=-0.208
min12.554-11.873=0.681
max13.565-13.161=0.404
op=table_records(), no indexes
mean41.932-41.932=0.000
σ0.001-0.001=-0.000
min41.929-41.929=0.000
max41.933-41.933=-0.000
mean7288.000-7336.000=-48.000
σ0.000
min7288.000-7336.000=-48.000
max7288.000-7336.000=-48.000
mean15.292-14.475=0.817
σ0.701-0.896=-0.195
min13.826-12.375=1.451
max16.084-15.071=1.013
op=table_records(), repeat
mean41.928-41.928=-0.000
σ0.002-0.002=0.000
min41.927
max41.931-41.931=0.000
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean12.842-12.499=0.343
σ1.438-1.810=-0.372
min11.290-10.596=0.694
max15.455-14.892=0.563
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
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean8.924-8.724=0.200
σ0.388-0.348=0.041
min8.440-8.229=0.211
max9.518-9.419=0.100
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
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean6.961-6.337=0.624
σ0.288-0.175=0.112
min6.475-5.983=0.492
max7.317-6.557=0.760
op=vertical_lookup_row_list() on 2 indexed
mean25.666-25.666=0.000
σ0.002-0.002=0.000
min25.664-25.665=-0.000
max25.668
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean6.047-5.691=0.355
σ0.134-0.167=-0.032
min5.766-5.387=0.378
max6.229-5.858=0.372
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
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean5.849-5.458=0.391
σ0.128-0.121=0.007
min5.684-5.277=0.407
max6.105-5.586=0.519

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
mean7288.000-7336.000=-48.000
σ0.000
min7288.000-7336.000=-48.000
max7288.000-7336.000=-48.000
mean1100.832-1035.084=65.747
σ150.002-5.749=144.253
min1040.070-1023.016=17.055
max1471.926-1043.376=428.550
op=load_product(), with indexes
mean8744.721-8744.721=-0.000
σ0.469-0.469=-0.000
min8744.553-8744.553=0.000
max8745.882-8745.883=-0.001
mean3570.250-3581.875=-11.625
σ1794.806-1801.638=-6.832
min1042.000-1046.000=-4.000
max5789.000-5823.000=-34.000
mean4784.833-4877.511=-92.679
σ1477.348-1583.889=-106.541
min3538.411-3503.542=34.869
max7345.415-7490.115=-144.700

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.080=0.000
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean82.656-82.205=0.452
σ11.507-11.769=-0.262
min70.864-70.702=0.161
max102.933-104.310=-1.377
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-40.945=-0.000
mean7288.000-7336.000=-48.000
σ0.000
min7288.000-7336.000=-48.000
max7288.000-7336.000=-48.000
mean107.603-106.099=1.504
σ6.603-6.179=0.424
min93.601-94.433=-0.832
max113.987-112.160=1.827
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
mean7288.000-7336.000=-48.000
σ0.000
min7288.000-7336.000=-48.000
max7288.000-7336.000=-48.000
mean161.343-161.575=-0.232
σ10.754-10.249=0.504
min136.359-139.671=-3.312
max168.872-169.293=-0.422

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-11667.537=0.001
mean4148.875-4158.875=-10.000
σ1895.889-1906.359=-10.470
min1554.000-1556.000=-2.000
max7288.000-7336.000=-48.000
mean6816.553-6142.719=673.833
σ1261.450-1014.071=247.380
min4930.179-4903.479=26.699
max8218.250-7686.161=532.089
op=vertical_lookup_list() on indexed
mean11560.065-11560.065=-0.000
σ0.001-0.001=-0.000
min11560.064
max11560.066
mean7288.000-7336.000=-48.000
σ0.000
min7288.000-7336.000=-48.000
max7288.000-7336.000=-48.000
mean5656.198-5450.391=205.807
σ1337.442-1589.210=-251.768
min4411.834-4311.897=99.937
max7680.530-8609.333=-928.804

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
mean373.851-380.334=-6.483
σ20.398-18.882=1.516
min342.628-350.267=-7.638
max392.425-395.315=-2.890
op=pointedIndexFromKvs
rows=400000
mean357.322
σ0.001
min357.321
max357.325
mean560.000-560.500=-0.500
σ0.000-1.604=-1.604
min560.000-559.000=1.000
max560.000-562.000=-2.000
mean760.827-765.991=-5.164
σ55.174-45.970=9.204
min627.541-667.789=-40.248
max795.946-819.260=-23.314

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.500-1008.497=0.002
σ0.759-0.758=0.001
min1008.026-1008.027=-0.001
max1011.637-1011.635=0.002
mean1043.950-1047.250=-3.300
σ300.165-313.482=-13.317
min561.000-573.000=-12.000
max1447.000-1510.000=-63.000
mean1.512-1.565=-0.052
σ0.087-0.084=0.003
min1.369-1.492=-0.123
max1.745-1.764=-0.019

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.393-0.397=-0.004
σ0.492-0.503=-0.011
min0.151-0.146=0.005
max1.271-1.293=-0.022
name=error_case.art
mean2.339
σ0.012
min2.333
max2.361
mean402.000
σ0.000
min402.000
max402.000
mean0.479-0.478=0.002
σ0.323-0.324=-0.001
min0.327-0.321=0.006
max1.057-1.057=0.000
name=heavy_item.art
mean1.522
σ0.002
min1.521
max1.525
mean402.000
σ0.000
min402.000
max402.000
mean0.223-0.212=0.011
σ0.027-0.025=0.001
min0.206-0.196=0.010
max0.269-0.256=0.013
name=nested_use.art
mean2.357
σ0.002
min2.356
max2.360
mean402.000
σ0.000
min402.000
max402.000
mean0.335-0.329=0.006
σ0.018-0.022=-0.004
min0.315-0.311=0.004
max0.364-0.367=-0.003

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean964.741
σ0.011
min964.736
max964.760
mean435.000-431.000=4.000
σ4.637-0.000=4.637
min431.000
max440.000-431.000=9.000
mean0.542-0.543=-0.001
σ0.049-0.064=-0.016
min0.477-0.450=0.027
max0.590-0.606=-0.016
name=cdr_enhanced_4k_loc.art
mean885.814
σ0.002
min885.812
max885.816
mean440.000-431.000=9.000
σ0.000
min440.000-431.000=9.000
max440.000-431.000=9.000
mean0.474-0.430=0.044
σ0.036-0.061=-0.025
min0.421-0.380=0.041
max0.514-0.517=-0.004

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.708
σ0.002
min7.707
max7.711
mean440.000-431.000=9.000
σ0.000
min440.000-431.000=9.000
max440.000-431.000=9.000
mean2.640-2.635=0.005
σ0.114-0.092=0.022
min2.463-2.473=-0.010
max3.020-2.976=0.044
name=record_render_large_syntax_err.art
mean7.656
σ0.002
min7.655
max7.659
mean440.000-431.000=9.000
σ0.000
min440.000-431.000=9.000
max440.000-431.000=9.000
mean2.666-2.606=0.060
σ0.086-0.078=0.008
min2.494-2.474=0.020
max2.951-2.968=-0.018
name=record_render_success.art
mean2.289
σ0.002
min2.288
max2.292
mean440.000-431.000=9.000
σ0.000
min440.000-431.000=9.000
max440.000-431.000=9.000
mean0.310-0.308=0.003
σ0.012-0.009=0.003
min0.296-0.295=0.001
max0.388-0.359=0.029
name=record_render_syntax_err.art
mean2.165
σ0.002
min2.164
max2.168
mean440.000-431.000=9.000
σ0.000
min440.000-431.000=9.000
max440.000-431.000=9.000
mean0.291-0.292=-0.001
σ0.009-0.007=0.002
min0.268-0.278=-0.011
max0.337-0.325=0.011

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.944-297.959=-0.016
σ0.994-1.066=-0.072
min297.544-297.454=0.090
max300.763-300.972=-0.209
mean441.100-444.500=-3.400
σ15.531-17.840=-2.309
min418.000
max469.000-467.000=2.000
mean0.609-0.609=0.001
σ0.019-0.021=-0.001
min0.568-0.563=0.005
max0.633-0.633=-0.000

Timed compile per phase

Factorallocated MiBpeak allocated MiBtime (ms)
phase=buildDeclTree
mean222.008-222.008=-0.000
σ0.000
min222.008-222.008=-0.000
max222.008-222.008=-0.000
mean1745.250-1745.500=-0.250
σ1.389-0.926=0.463
min1743.000-1745.000=-2.000
max1746.000-1747.000=-1.000
mean205.414-204.656=0.759
σ1.616-1.464=0.152
min203.369-202.796=0.573
max207.646-207.511=0.135
phase=macro expansion
mean6.130
σ0.000
min6.130
max6.130
mean1745.250-1745.500=-0.250
σ1.389-0.926=0.463
min1743.000-1745.000=-2.000
max1746.000-1747.000=-1.000
mean11.210-11.920=-0.710
σ2.176-1.220=0.956
min7.302-9.473=-2.170
max12.953-12.858=0.096
phase=parser
mean1042.099-1042.099=0.000
σ0.000-0.000=-0.000
min1042.099-1042.098=0.001
max1042.099-1042.099=0.000
mean1745.250-1745.500=-0.250
σ1.389-0.926=0.463
min1743.000-1745.000=-2.000
max1746.000-1747.000=-1.000
mean652.122-708.697=-56.575
σ109.945-57.022=52.923
min424.382-568.795=-144.413
max731.908-742.323=-10.415
phase=processProdDef
mean6169.660-6169.656=0.004
σ0.001-0.001=-0.000
min6169.659-6169.655=0.003
max6169.660-6169.657=0.003
mean1745.750
σ1.165-1.035=0.130
min1743.000-1745.000=-2.000
max1747.000
mean5077.535-5472.913=-395.379
σ1037.032-1122.873=-85.842
min3910.199-4391.071=-480.873
max6841.433-7720.100=-878.667
phase=renaming
mean21.671-21.667=0.004
σ0.000
min21.671-21.667=0.004
max21.671-21.667=0.004
mean1745.250-1745.500=-0.250
σ1.389-0.926=0.463
min1743.000-1745.000=-2.000
max1746.000-1747.000=-1.000
mean42.725-45.208=-2.483
σ7.625-5.036=2.589
min26.158-34.625=-8.467
max48.014-48.261=-0.246
phase=type checker
mean958.457
σ0.066
min958.360
max958.547
mean1745.250-1745.500=-0.250
σ1.389-0.926=0.463
min1743.000-1745.000=-2.000
max1746.000-1747.000=-1.000
mean757.327-803.741=-46.415
σ96.512-75.972=20.540
min638.131-677.179=-39.049
max889.204-883.047=6.157

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean293.689-293.685=0.005
σ0.044-0.040=0.004
min293.631-293.630=0.001
max293.739-293.724=0.015
mean446.000-445.000=1.000
σ0.000
min446.000-445.000=1.000
max446.000-445.000=1.000
mean0.404-0.398=0.006
σ0.009-0.001=0.007
min0.400-0.397=0.002
max0.420-0.400=0.020
iters=5
new-facts=1
prior-facts=6402
mean1303.801-1303.769=0.032
σ0.093-0.076=0.017
min1303.649-1303.644=0.004
max1303.875-1303.829=0.046
mean1086.600-1084.000=2.600
σ180.864-167.905=12.959
min840.000-885.000=-45.000
max1304.000-1313.000=-9.000
mean2.146-2.059=0.087
σ0.309-0.217=0.092
min1.813-1.816=-0.003
max2.591-2.265=0.326
iters=5
new-facts=6402
prior-facts=1
mean1546.795-1546.838=-0.043
σ4.028-4.008=0.020
min1544.786-1544.902=-0.116
max1553.994-1554.003=-0.009
mean619.400-618.400=1.000
σ80.133-88.041=-7.908
min499.000-522.000=-23.000
max714.000-726.000=-12.000
mean2.201-2.362=-0.161
σ0.120-0.232=-0.112
min2.014-2.121=-0.108
max2.347-2.594=-0.247
iters=5
new-facts=6402
prior-facts=6402
mean1865.783-1865.782=0.002
σ0.054-0.065=-0.011
min1865.711-1865.725=-0.014
max1865.859-1865.887=-0.027
mean1745.800-1725.000=20.800
σ228.215-179.612=48.603
min1442.000-1470.000=-28.000
max1962.000-1891.000=71.000
mean2.962-2.993=-0.030
σ0.130-0.221=-0.090
min2.869-2.788=0.081
max3.166-3.357=-0.191

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.792-1.823=-0.030
σ0.147-0.135=0.012
min1.554-1.596=-0.042
max1.937-1.928=0.009

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean447.981-447.981=-0.000
σ579.239-579.242=-0.002
min158.360-158.357=0.003
max1316.840-1316.844=-0.004
mean96.250
σ8.500
min92.000
max109.000
mean443.000-441.000=2.000
σ0.000
min443.000-441.000=2.000
max443.000-441.000=2.000
mean0.536-0.530=0.006
σ0.545-0.523=0.022
min0.263-0.268=-0.005
max1.354-1.315=0.039
policies=20
mean1583.922-1583.926=-0.004
σ0.360-0.365=-0.005
min1583.673-1583.673=0.000
max1584.454-1584.465=-0.011
mean920.000
σ0.000
min920.000
max920.000
mean445.250-446.500=-1.250
σ1.500-6.351=-4.851
min443.000-441.000=2.000
max446.000-452.000=-6.000
mean2.646-2.638=0.008
σ0.012-0.008=0.004
min2.635-2.630=0.006
max2.658-2.646=0.012
policies=200
mean15847.154-15847.112=0.042
σ0.114-0.050=0.065
min15847.045-15847.055=-0.010
max15847.285-15847.176=0.109
mean9200.000
σ0.000
min9200.000
max9200.000
mean497.500-492.750=4.750
σ4.655-3.948=0.707
min492.000-488.000=4.000
max503.000-496.000=7.000
mean26.742-26.631=0.111
σ0.153-0.130=0.023
min26.615-26.524=0.091
max26.956-26.791=0.165