Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-54.616=0.001
σ	0.348-0.349=-0.001
min	54.481-54.486=-0.005
max	55.606-55.609=-0.004

*mean*	418.700-418.000=0.700
σ	0.483-0.000=0.483
min	418.000
max	419.000-418.000=1.000

*mean*	0.138-0.138=-0.000
σ	0.005-0.005=0.000
min	0.131-0.132=-0.001
max	0.147-0.148=-0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.787-43.785=0.001
σ	0.007-0.006=0.001
min	43.779-43.778=0.001
max	43.804-43.798=0.006

*mean*	419.000-418.000=1.000
σ	0.000
min	419.000-418.000=1.000
max	419.000-418.000=1.000

*mean*	0.120-0.122=-0.002
σ	0.005-0.003=0.001
min	0.115-0.120=-0.005
max	0.130-0.128=0.002

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*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	12.772-12.139=0.633
σ	1.642-0.220=1.422
min	11.703-11.794=-0.091
max	16.747-12.415=4.332

op=column_set() on indexed, repeat

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

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	12.629-12.577=0.052
σ	1.506-0.587=0.919
min	11.326-11.733=-0.407
max	16.094-13.304=2.790

op=table_records(), no indexes

*mean*	41.928-41.929=-0.001
σ	0.000-0.001=-0.001
min	41.928
max	41.929-41.932=-0.003

*mean*	7537.000-7551.000=-14.000
σ	0.000
min	7537.000-7551.000=-14.000
max	7537.000-7551.000=-14.000

*mean*	13.454-13.915=-0.462
σ	0.906-1.208=-0.302
min	12.567-12.290=0.277
max	14.590-15.187=-0.598

op=table_records(), repeat

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

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	12.012-12.048=-0.036
σ	1.981-1.792=0.188
min	10.163-10.477=-0.314
max	15.646-15.037=0.608

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

*mean*	27.605-27.605=-0.000
σ	0.002-0.002=-0.000
min	27.603-27.603=0.000
max	27.607-27.607=-0.000

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	8.719-8.697=0.022
σ	1.201-0.778=0.423
min	7.889-7.972=-0.084
max	11.627-10.344=1.283

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

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

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	6.914-6.169=0.745
σ	1.099-0.732=0.366
min	6.331-5.251=1.081
max	9.624-7.633=1.991

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666-25.666=-0.000
σ	0.002-0.002=0.000
min	25.664-25.664=0.000
max	25.670-25.670=-0.000

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	5.637-5.501=0.136
σ	0.464-0.166=0.298
min	5.251-5.191=0.060
max	6.733-5.671=1.062

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.971

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	5.423-5.031=0.392
σ	0.491-0.099=0.392
min	5.141-4.894=0.247
max	6.630-5.153=1.477

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.593-2524.594=-0.000
σ	0.000-0.000=-0.000
min	2524.593-2524.594=-0.000
max	2524.594-2524.594=-0.001

*mean*	7537.000-7551.000=-14.000
σ	0.000
min	7537.000-7551.000=-14.000
max	7537.000-7551.000=-14.000

*mean*	1043.540-1053.725=-10.185
σ	3.816-5.952=-2.136
min	1037.759-1045.941=-8.182
max	1049.724-1065.203=-15.479

op=load_product(), with indexes

*mean*	8744.558-8744.559=-0.000
σ	0.033-0.033=-0.000
min	8744.544-8744.545=-0.001
max	8744.639-8744.640=-0.001

*mean*	3788.750-3791.375=-2.625
σ	1608.136-1606.359=1.777
min	1983.000-1988.000=-5.000
max	5947.000-5946.000=1.000

*mean*	4424.494-4470.348=-45.854
σ	1402.825-1220.377=182.448
min	3532.944-3558.080=-25.136
max	7446.625-6824.630=621.995

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078-62.077=0.000
σ	0.002-0.002=0.000
min	62.075-62.076=-0.001
max	62.080

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	85.249-82.438=2.811
σ	13.627-9.511=4.116
min	70.604-70.968=-0.364
max	106.412-94.509=11.903

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*	7537.000-7551.000=-14.000
σ	0.000
min	7537.000-7551.000=-14.000
max	7537.000-7551.000=-14.000

*mean*	100.582-221.340=-120.758
σ	7.556-341.380=-333.824
min	88.174-85.991=2.183
max	109.085-1065.992=-956.907

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.686-66.687=-0.000

*mean*	7537.000-7551.000=-14.000
σ	0.000
min	7537.000-7551.000=-14.000
max	7537.000-7551.000=-14.000

*mean*	150.563-151.996=-1.433
σ	14.496-14.539=-0.043
min	127.225-135.511=-8.286
max	167.190-168.801=-1.611

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833-11656.833=0.000
σ	4.318-4.317=0.001
min	11655.305
max	11667.520-11667.517=0.003

*mean*	4264.125-4268.500=-4.375
σ	1876.550-1878.822=-2.272
min	1983.000-1988.000=-5.000
max	7537.000-7551.000=-14.000

*mean*	6366.729-6188.583=178.145
σ	1161.803-1290.678=-128.876
min	4965.166-4914.316=50.850
max	8148.390-8211.299=-62.909

op=vertical_lookup_list() on indexed

*mean*	11560.068-11560.068=-0.000
σ	0.001-0.001=0.000
min	11560.066-11560.066=-0.001
max	11560.069

*mean*	7537.000-7551.000=-14.000
σ	0.000
min	7537.000-7551.000=-14.000
max	7537.000-7551.000=-14.000

*mean*	5428.145-5136.369=291.776
σ	1341.750-1136.961=204.789
min	4382.067-4433.525=-51.458
max	7486.002-7037.181=448.821

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.581-172.581=0.000
σ	0.025-0.020=0.005
min	172.558
max	172.623-172.607=0.015

*mean*	1983.000-1988.000=-5.000
σ	0.000
min	1983.000-1988.000=-5.000
max	1983.000-1988.000=-5.000

*mean*	347.469-345.552=1.917
σ	38.746-41.171=-2.425
min	264.971-266.166=-1.195
max	390.621-397.524=-6.903

op=pointedIndexFromKvs

rows=400000

*mean*	357.366-357.370=-0.004
σ	0.046-0.047=-0.000
min	357.321
max	357.445-357.443=0.002

*mean*	1983.000-1988.000=-5.000
σ	0.000
min	1983.000-1988.000=-5.000
max	1983.000-1988.000=-5.000

*mean*	735.782-730.278=5.504
σ	60.627-86.059=-25.432
min	642.528-557.721=84.807
max	802.805-802.653=0.153

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.190-1008.185=0.004
σ	0.868-0.877=-0.009
min	1007.688-1007.686=0.002
max	1011.774-1011.819=-0.045

*mean*	1043.450-1040.500=2.950
σ	301.157-295.505=5.652
min	548.000-559.000=-11.000
max	1469.000-1439.000=30.000

*mean*	1.521-1.525=-0.004
σ	0.068-0.086=-0.018
min	1.454-1.453=0.001
max	1.757-1.753=0.004

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883
σ	0.002
min	0.881
max	0.886

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.427-0.410=0.017
σ	0.136-0.125=0.011
min	0.341-0.327=0.015
max	0.668-0.628=0.040

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.898-0.876=0.022
σ	0.095-0.087=0.009
min	0.841-0.816=0.025
max	1.066-1.029=0.037

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.556-0.543=0.013
σ	0.047-0.040=0.006
min	0.524-0.507=0.017
max	0.637-0.608=0.028

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.855-0.837=0.018
σ	0.043-0.031=0.012
min	0.819-0.814=0.005
max	0.928-0.891=0.037

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.542-963.543=-0.001
σ	0.029-0.031=-0.001
min	963.523
max	963.593-963.596=-0.004

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.790-0.828=-0.039
σ	0.059-0.031=0.028
min	0.727-0.780=-0.053
max	0.866-0.858=0.009

name=cdr_enhanced_4k_loc.art

*mean*	884.853-884.853=-0.000
σ	0.006-0.006=-0.000
min	884.847
max	884.860-884.860=-0.000

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.741-0.719=0.022
σ	0.005-0.031=-0.026
min	0.737-0.674=0.063
max	0.748-0.747=0.001

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706-7.706=-0.000
σ	0.002-0.002=-0.000
min	7.705
max	7.709-7.712=-0.003

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	4.294-4.258=0.036
σ	0.084-0.095=-0.011
min	4.143-4.084=0.059
max	4.580-4.642=-0.062

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	4.272-4.247=0.025
σ	0.077-0.087=-0.010
min	4.143-4.105=0.038
max	4.584-4.530=0.054

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.758-0.742=0.015
σ	0.018-0.019=-0.002
min	0.728-0.680=0.048
max	0.880-0.843=0.037

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.709-0.702=0.007
σ	0.045-0.015=0.030
min	0.502-0.671=-0.169
max	0.802-0.786=0.016

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.443-297.659=-0.216
σ	0.238-0.201=0.037
min	297.223-297.365=-0.142
max	298.069-298.122=-0.052

*mean*	1983.000-1988.000=-5.000
σ	0.000
min	1983.000-1988.000=-5.000
max	1983.000-1988.000=-5.000

*mean*	0.555-0.561=-0.006
σ	0.032-0.042=-0.011
min	0.504-0.501=0.004
max	0.599-0.613=-0.015

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.770-289.772=-0.002
σ	0.032-0.035=-0.003
min	289.727-289.724=0.003
max	289.804-289.806=-0.002

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.397-0.400=-0.004
σ	0.015-0.011=0.004
min	0.377-0.393=-0.016
max	0.421-0.420=0.000

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.648-1299.643=0.006
σ	0.067-0.068=-0.000
min	1299.572-1299.563=0.009
max	1299.708-1299.697=0.011

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	2.095-2.107=-0.012
σ	0.064-0.048=0.017
min	1.997-2.038=-0.042
max	2.146-2.164=-0.018

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.625-1542.637=-0.012
σ	4.032-4.046=-0.014
min	1540.591-1540.608=-0.017
max	1549.828-1549.866=-0.038

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	2.260-2.306=-0.046
σ	0.164-0.193=-0.029
min	2.128-2.137=-0.009
max	2.448-2.567=-0.119

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.632-1861.632=-0.000
σ	0.057-0.065=-0.008
min	1861.559-1861.541=0.018
max	1861.700-1861.703=-0.003

*mean*	1768.200-1774.400=-6.200
σ	226.466-225.518=0.948
min	1470.000-1477.000=-7.000
max	1983.000-1988.000=-5.000

*mean*	3.222-3.287=-0.065
σ	0.313-0.425=-0.112
min	2.879-2.878=0.001
max	3.550-3.900=-0.350

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.772-1.778=-0.006
σ	0.102-0.113=-0.011
min	1.606-1.658=-0.052
max	1.866-1.888=-0.022

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.186-446.148=0.038
σ	577.139-577.065=0.075
min	157.615-157.614=0.001
max	1311.895-1311.745=0.150

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	0.539-0.551=-0.011
σ	0.557-0.565=-0.008
min	0.260-0.267=-0.008
max	1.375-1.398=-0.023

policies=20

*mean*	1576.427-1576.411=0.016
σ	0.358-0.338=0.020
min	1576.186-1576.186=0.001
max	1576.959-1576.914=0.045

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	2.637-2.612=0.025
σ	0.030-0.015=0.016
min	2.607-2.594=0.014
max	2.672-2.626=0.046

policies=200

*mean*	15772.201-15772.234=-0.033
σ	0.164-0.090=0.074
min	15772.078-15772.113=-0.036
max	15772.439-15772.316=0.123

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1469.000-1439.000=30.000
σ	0.000
min	1469.000-1439.000=30.000
max	1469.000-1439.000=30.000

*mean*	26.440-26.393=0.047
σ	0.062-0.033=0.029
min	26.365-26.359=0.005
max	26.513-26.432=0.081