Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.581-54.577=0.004
σ	0.342-0.349=-0.007
min	54.449-54.438=0.011
max	55.554-55.569=-0.015

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.140-0.138=0.002
σ	0.005-0.006=-0.001
min	0.132-0.130=0.002
max	0.150-0.150=-0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.704-43.706=-0.002
σ	0.007-0.007=0.000
min	43.695-43.693=0.002
max	43.715-43.716=-0.001

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.121-0.123=-0.002
σ	0.005-0.004=0.000
min	0.116-0.118=-0.002
max	0.130-0.130=0.000

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618-36.618=-0.000
σ	0.002-0.002=0.000
min	36.615-36.616=-0.000
max	36.620-36.620=-0.000

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	13.090-12.762=0.328
σ	0.234-0.259=-0.025
min	12.596-12.243=0.353
max	13.338-13.077=0.262

op=column_set() on indexed, repeat

*mean*	36.617-36.617=0.000
σ	0.002-0.002=-0.000
min	36.616-36.615=0.000
max	36.619-36.620=-0.000

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	12.927-12.480=0.447
σ	0.739-0.688=0.051
min	12.176-11.595=0.581
max	13.938-13.269=0.669

op=table_records(), no indexes

*mean*	41.932-41.932=-0.000
σ	0.001-0.001=0.000
min	41.929-41.929=-0.001
max	41.933-41.933=-0.000

*mean*	7326.000-7311.000=15.000
σ	0.000
min	7326.000-7311.000=15.000
max	7326.000-7311.000=15.000

*mean*	15.409-15.059=0.349
σ	0.767-0.840=-0.073
min	13.715-13.122=0.593
max	15.955-15.755=0.199

op=table_records(), repeat

*mean*	41.928-41.928=0.000
σ	0.002-0.002=0.000
min	41.927-41.927=0.000
max	41.932-41.931=0.001

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	13.485-12.903=0.582
σ	1.975-1.727=0.248
min	11.169-11.087=0.082
max	16.012-15.608=0.404

op=vertical_lookup_list() on indexed, after table_records()

*mean*	27.653-27.653=-0.000
σ	0.136-0.136=-0.000
min	27.603-27.603=-0.000
max	27.990-27.990=-0.000

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	9.004-8.861=0.143
σ	0.268-0.318=-0.050
min	8.639-8.389=0.250
max	9.377-9.332=0.045

op=vertical_lookup_list() on indexed, after table_records(), repeat

*mean*	26.400-26.400=-0.000
σ	0.002-0.002=0.000
min	26.399-26.399=-0.000
max	26.403

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	6.742-6.830=-0.088
σ	0.237-0.419=-0.181
min	6.423-6.045=0.378
max	7.146-7.251=-0.105

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666-25.666=-0.000
σ	0.002-0.002=0.000
min	25.665
max	25.668-25.668=0.000

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	6.013-5.965=0.048
σ	0.126-0.090=0.036
min	5.845-5.792=0.053
max	6.249-6.078=0.171

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968-25.968=0.000
σ	0.002-0.002=-0.000
min	25.967
max	25.972-25.972=-0.000

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	5.874-5.817=0.057
σ	0.117-0.116=0.000
min	5.740-5.599=0.141
max	6.101-5.949=0.153

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.606-2524.606=-0.000
σ	0.000-0.000=-0.000
min	2524.606
max	2524.606-2524.607=-0.001

*mean*	7326.000-7311.000=15.000
σ	0.000
min	7326.000-7311.000=15.000
max	7326.000-7311.000=15.000

*mean*	1053.344-1053.417=-0.073
σ	4.867-5.449=-0.583
min	1047.689-1046.931=0.758
max	1061.347-1060.489=0.858

op=load_product(), with indexes

*mean*	8744.722-8744.721=0.001
σ	0.469-0.469=0.001
min	8744.553-8744.554=-0.001
max	8745.883-8745.881=0.002

*mean*	3577.750-3576.500=1.250
σ	1802.684-1797.482=5.202
min	1044.000-1051.000=-7.000
max	5815.000-5802.000=13.000

*mean*	4929.427-4808.499=120.928
σ	1644.339-1656.283=-11.944
min	3543.996-3539.972=4.023
max	7608.725-7249.636=359.088

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078-62.078=0.000
σ	0.002-0.002=0.000
min	62.076
max	62.081-62.080=0.000

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	83.600-84.169=-0.569
σ	12.096-11.798=0.298
min	71.329-71.600=-0.271
max	103.779-100.495=3.285

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944-40.944=-0.000
σ	0.001-0.001=0.000
min	40.944-40.944=-0.000
max	40.945

*mean*	7326.000-7311.000=15.000
σ	0.000
min	7326.000-7311.000=15.000
max	7326.000-7311.000=15.000

*mean*	106.250-106.828=-0.577
σ	5.795-8.004=-2.209
min	95.309-89.486=5.824
max	112.801-113.511=-0.710

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686-66.686=-0.000
σ	0.000-0.000=-0.000
min	66.685
max	66.687-66.687=-0.000

*mean*	7326.000-7311.000=15.000
σ	0.000
min	7326.000-7311.000=15.000
max	7326.000-7311.000=15.000

*mean*	162.405-160.030=2.374
σ	9.115-11.583=-2.468
min	141.307-132.967=8.340
max	167.989-168.377=-0.388

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.836-11656.836=-0.000
σ	4.324-4.324=0.000
min	11655.305
max	11667.538

*mean*	4156.750-4154.750=2.000
σ	1906.689-1901.993=4.696
min	1557.000-1552.000=5.000
max	7326.000-7311.000=15.000

*mean*	6704.001-6139.089=564.911
σ	1272.507-1101.668=170.839
min	4938.628-4982.496=-43.868
max	8000.360-8161.534=-161.173

op=vertical_lookup_list() on indexed

*mean*	11560.065-11560.065=0.000
σ	0.001-0.001=0.000
min	11560.064
max	11560.066-11560.066=0.001

*mean*	7326.000-7311.000=15.000
σ	0.000
min	7326.000-7311.000=15.000
max	7326.000-7311.000=15.000

*mean*	5848.682-6079.750=-231.068
σ	1951.791-1778.018=173.773
min	4345.659-4403.057=-57.398
max	9151.155-9049.522=101.634

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.559
σ	0.001
min	172.558
max	172.562

*mean*	476.000-478.000=-2.000
σ	0.000
min	476.000-478.000=-2.000
max	476.000-478.000=-2.000

*mean*	382.823-380.183=2.639
σ	18.833-19.598=-0.766
min	352.567-352.297=0.270
max	397.782-398.198=-0.416

op=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.001
min	357.321
max	357.325

*mean*	562.000-561.000=1.000
σ	0.000
min	562.000-561.000=1.000
max	562.000-561.000=1.000

*mean*	697.869-745.764=-47.895
σ	69.430-51.178=18.252
min	638.847-633.918=4.929
max	790.620-796.563=-5.942

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.500-1008.500=-0.000
σ	0.759-0.759=-0.001
min	1008.028-1008.024=0.005
max	1011.638-1011.640=-0.002

*mean*	1044.800-1043.850=0.950
σ	308.959-310.928=-1.970
min	595.000-572.000=23.000
max	1501.000-1502.000=-1.000

*mean*	1.545-1.534=0.012
σ	0.072-0.061=0.011
min	1.471-1.456=0.015
max	1.763-1.703=0.060

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.913
σ	0.020
min	0.903
max	0.949

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.387-0.407=-0.021
σ	0.487-0.505=-0.018
min	0.141-0.150=-0.009
max	1.255-1.308=-0.053

name=error_case.art

*mean*	2.339
σ	0.012
min	2.333
max	2.361

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.478-0.482=-0.004
σ	0.328-0.313=0.015
min	0.320-0.335=-0.016
max	1.065-1.041=0.023

name=heavy_item.art

*mean*	1.522
σ	0.002
min	1.521
max	1.525

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.222-0.227=-0.005
σ	0.020-0.024=-0.004
min	0.204-0.204=-0.000
max	0.257-0.261=-0.004

name=nested_use.art

*mean*	2.357
σ	0.002
min	2.356
max	2.360

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.334-0.331=0.002
σ	0.017-0.018=-0.001
min	0.320-0.320=0.001
max	0.363-0.363=0.001

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	964.741
σ	0.011
min	964.736
max	964.760

*mean*	436.000-436.600=-0.600
σ	2.236-6.066=-3.830
min	432.000-431.000=1.000
max	437.000-443.000=-6.000

*mean*	0.548-0.565=-0.017
σ	0.056-0.034=0.022
min	0.485-0.517=-0.032
max	0.615-0.609=0.006

name=cdr_enhanced_4k_loc.art

*mean*	885.814
σ	0.002
min	885.812
max	885.816

*mean*	443.000
σ	0.000
min	443.000
max	443.000

*mean*	0.464-0.519=-0.055
σ	0.047-0.027=0.020
min	0.383-0.471=-0.087
max	0.496-0.535=-0.039

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.708
σ	0.002
min	7.707
max	7.711

*mean*	443.000
σ	0.000
min	443.000
max	443.000

*mean*	2.335-2.661=-0.326
σ	0.331-0.099=0.232
min	1.829-2.465=-0.636
max	2.896-2.998=-0.103

name=record_render_large_syntax_err.art

*mean*	7.656
σ	0.002
min	7.655
max	7.659

*mean*	443.000
σ	0.000
min	443.000
max	443.000

*mean*	2.625-2.635=-0.010
σ	0.095-0.098=-0.003
min	2.446-2.459=-0.013
max	2.933-2.958=-0.025

name=record_render_success.art

*mean*	2.289
σ	0.002
min	2.288
max	2.292

*mean*	443.000
σ	0.000
min	443.000
max	443.000

*mean*	0.303-0.307=-0.004
σ	0.010-0.009=0.001
min	0.285-0.292=-0.007
max	0.367-0.364=0.004

name=record_render_syntax_err.art

*mean*	2.165
σ	0.002
min	2.164
max	2.168

*mean*	443.000
σ	0.000
min	443.000
max	443.000

*mean*	0.287-0.290=-0.002
σ	0.013-0.007=0.005
min	0.273-0.278=-0.005
max	0.374-0.333=0.042

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	298.248-298.083=0.164
σ	0.992-1.046=-0.053
min	297.804-297.685=0.119
max	301.054-301.055=-0.001

*mean*	444.000-442.600=1.400
σ	14.757-16.126=-1.369
min	422.000-418.000=4.000
max	465.000-466.000=-1.000

*mean*	0.609-0.603=0.006
σ	0.018-0.022=-0.005
min	0.583-0.547=0.035
max	0.636-0.633=0.003

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	222.008-222.008=0.000
σ	0.000-0.000=0.000
min	222.008-222.008=-0.000
max	222.008-222.008=0.000

*mean*	1680.000-1737.500=-57.500
σ	0.000-10.351=-10.351
min	1680.000-1725.000=-45.000
max	1680.000-1745.000=-65.000

*mean*	209.545-203.806=5.739
σ	2.580-2.386=0.194
min	204.835-200.355=4.479
max	212.779-207.205=5.574

phase=macro expansion

*mean*	6.130
σ	0.000
min	6.130
max	6.130

*mean*	1680.000-1737.500=-57.500
σ	0.000-10.351=-10.351
min	1680.000-1725.000=-45.000
max	1680.000-1745.000=-65.000

*mean*	8.968-10.744=-1.775
σ	1.987-2.295=-0.308
min	6.227-6.175=0.052
max	12.594-12.780=-0.186

phase=parser

*mean*	1042.098-1042.103=-0.005
σ	0.000-0.001=-0.000
min	1042.097-1042.102=-0.005
max	1042.098-1042.103=-0.005

*mean*	1680.000-1737.500=-57.500
σ	0.000-10.351=-10.351
min	1680.000-1725.000=-45.000
max	1680.000-1745.000=-65.000

*mean*	621.146-662.829=-41.683
σ	86.785-138.549=-51.764
min	483.874-386.716=97.159
max	721.758-827.487=-105.729

phase=processProdDef

*mean*	6169.660-6169.657=0.003
σ	0.000-0.000=-0.000
min	6169.660-6169.656=0.003
max	6169.660-6169.658=0.003

*mean*	1680.000-1740.000=-60.000
σ	0.000-9.258=-9.258
min	1680.000-1725.000=-45.000
max	1680.000-1745.000=-65.000

*mean*	6742.690-5671.592=1071.098
σ	790.416-1468.496=-678.080
min	5482.716-3667.415=1815.301
max	7411.009-7631.096=-220.087

phase=renaming

*mean*	21.671-21.667=0.004
σ	0.000
min	21.671-21.667=0.004
max	21.671-21.667=0.004

*mean*	1680.000-1737.500=-57.500
σ	0.000-10.351=-10.351
min	1680.000-1725.000=-45.000
max	1680.000-1745.000=-65.000

*mean*	44.542-42.233=2.309
σ	6.078-7.222=-1.144
min	33.917-30.362=3.555
max	50.886-51.512=-0.626

phase=type checker

*mean*	958.457-958.461=-0.004
σ	0.066
min	958.360-958.363=-0.004
max	958.547-958.551=-0.004

*mean*	1680.000-1737.500=-57.500
σ	0.000-10.351=-10.351
min	1680.000-1725.000=-45.000
max	1680.000-1745.000=-65.000

*mean*	751.231-803.369=-52.137
σ	49.930-96.761=-46.831
min	657.976-668.371=-10.395
max	796.252-914.934=-118.682

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	293.686-293.688=-0.002
σ	0.039-0.038=0.001
min	293.632-293.633=-0.001
max	293.727-293.724=0.002

*mean*	445.000-444.000=1.000
σ	0.000
min	445.000-444.000=1.000
max	445.000-444.000=1.000

*mean*	0.401-0.408=-0.007
σ	0.011-0.008=0.003
min	0.396-0.401=-0.005
max	0.421-0.418=0.002

iters=5

new-facts=1

prior-facts=6402

*mean*	1303.726-1303.782=-0.056
σ	0.067-0.088=-0.021
min	1303.642-1303.645=-0.004
max	1303.789-1303.871=-0.081

*mean*	1062.600-1095.800=-33.200
σ	168.589-188.524=-19.935
min	840.000-836.000=4.000
max	1273.000-1322.000=-49.000

*mean*	1.889-2.104=-0.214
σ	0.095-0.274=-0.180
min	1.814-1.819=-0.005
max	2.038-2.448=-0.409

iters=5

new-facts=6402

prior-facts=1

*mean*	1546.817-1546.810=0.007
σ	4.016-4.027=-0.011
min	1544.813-1544.818=-0.005
max	1553.995-1554.008=-0.013

*mean*	611.800-618.200=-6.400
σ	73.152-80.160=-7.009
min	497.000
max	690.000-712.000=-22.000

*mean*	2.238-2.246=-0.008
σ	0.122-0.116=0.007
min	2.134-2.125=0.009
max	2.442-2.422=0.019

iters=5

new-facts=6402

prior-facts=6402

*mean*	1865.806-1865.784=0.022
σ	0.060-0.073=-0.013
min	1865.749-1865.710=0.039
max	1865.896-1865.894=0.002

*mean*	1710.000-1731.000=-21.000
σ	249.716-184.141=65.575
min	1418.000-1466.000=-48.000
max	2064.000-1896.000=168.000

*mean*	2.957-3.131=-0.174
σ	0.104-0.377=-0.273
min	2.884-2.866=0.018
max	3.121-3.797=-0.676

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.742-1.630=0.112
σ	0.167-0.062=0.104
min	1.511-1.565=-0.054
max	1.918-1.726=0.192

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	450.089-447.981=2.108
σ	579.265-579.239=0.026
min	160.453-158.361=2.092
max	1318.986-1316.839=2.147

*mean*	102.250-96.250=6.000
σ	8.500
min	98.000-92.000=6.000
max	115.000-109.000=6.000

*mean*	443.000-444.000=-1.000
σ	0.000
min	443.000-444.000=-1.000
max	443.000-444.000=-1.000

*mean*	0.540-0.532=0.009
σ	0.540-0.533=0.007
min	0.269-0.263=0.005
max	1.350-1.331=0.019

policies=20

*mean*	1604.906-1583.916=20.990
σ	0.404-0.365=0.039
min	1604.626-1583.662=20.964
max	1605.504-1584.456=21.048

*mean*	980.000-920.000=60.000
σ	0.000
min	980.000-920.000=60.000
max	980.000-920.000=60.000

*mean*	446.000-446.250=-0.250
σ	2.000-1.500=0.500
min	443.000-444.000=-1.000
max	447.000

*mean*	2.680-2.657=0.023
σ	0.010-0.060=-0.050
min	2.667-2.618=0.050
max	2.690-2.747=-0.056

policies=200

*mean*	16057.228-15847.064=210.164
σ	0.085-0.120=-0.035
min	16057.124-15846.896=210.228
max	16057.320-15847.171=210.149

*mean*	9800.000-9200.000=600.000
σ	0.000
min	9800.000-9200.000=600.000
max	9800.000-9200.000=600.000

*mean*	493.500-495.000=-1.500
σ	3.697-3.651=0.045
min	489.000-491.000=-2.000
max	497.000-499.000=-2.000

*mean*	27.114-26.755=0.359
σ	0.135-0.186=-0.051
min	26.979-26.603=0.376
max	27.262-26.985=0.278