Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-54.618=-0.002
σ	0.348-0.351=-0.003
min	54.483-54.483=-0.000
max	55.605-55.616=-0.011

*mean*	416.700-415.000=1.700
σ	0.483-0.000=0.483
min	416.000-415.000=1.000
max	417.000-415.000=2.000

*mean*	0.141-0.138=0.003
σ	0.004-0.005=-0.001
min	0.136-0.132=0.003
max	0.147-0.146=0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.785=0.000
σ	0.007-0.006=0.002
min	43.778-43.779=-0.001
max	43.803-43.798=0.006

*mean*	417.000-415.000=2.000
σ	0.000
min	417.000-415.000=2.000
max	417.000-415.000=2.000

*mean*	0.121-0.122=-0.002
σ	0.005-0.004=0.001
min	0.115-0.119=-0.004
max	0.128-0.130=-0.002

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

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

*mean*	4136.000-4089.375=46.625
σ	1552.022-1586.689=-34.667
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	57.262-12.019=45.243
σ	127.485-0.399=127.086
min	11.885-11.613=0.272
max	372.770-12.741=360.029

op=column_set() on indexed, repeat

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

*mean*	4136.000-4089.375=46.625
σ	1552.022-1586.689=-34.667
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	12.473-11.217=1.256
σ	1.295-0.150=1.145
min	11.219-10.996=0.223
max	15.237-11.485=3.752

op=table_records(), no indexes

*mean*	41.928-41.928=-0.000
σ	0.000-0.000=-0.000
min	41.928
max	41.929-41.929=-0.000

*mean*	6051.000-6041.000=10.000
σ	0.000
min	6051.000-6041.000=10.000
max	6051.000-6041.000=10.000

*mean*	13.559-13.234=0.324
σ	1.607-1.130=0.477
min	11.230-11.060=0.171
max	14.875-14.906=-0.031

op=table_records(), repeat

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

*mean*	4055.000-4089.375=-34.375
σ	1618.391-1586.689=31.701
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	12.419-12.236=0.182
σ	1.843-1.859=-0.016
min	10.153-10.271=-0.117
max	14.517-14.411=0.107

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

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

*mean*	4055.000-4089.375=-34.375
σ	1618.391-1586.689=31.701
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	8.169-8.114=0.054
σ	0.474-0.281=0.193
min	7.274-7.760=-0.486
max	8.690-8.557=0.133

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
max	26.403-26.403=-0.000

*mean*	4055.000-4089.375=-34.375
σ	1618.391-1586.689=31.701
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	6.078-6.051=0.027
σ	0.307-0.358=-0.051
min	5.626-5.537=0.090
max	6.633-6.653=-0.020

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4136.000-4089.375=46.625
σ	1552.022-1586.689=-34.667
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	5.435-5.187=0.248
σ	0.117-0.177=-0.060
min	5.161-4.974=0.187
max	5.517-5.481=0.035

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-25.967=0.000
max	25.971

*mean*	4136.000-4089.375=46.625
σ	1552.022-1586.689=-34.667
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	5.152-4.987=0.165
σ	0.125-0.153=-0.028
min	4.864-4.760=0.104
max	5.237-5.213=0.025

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

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

*mean*	6051.000-6041.000=10.000
σ	0.000
min	6051.000-6041.000=10.000
max	6051.000-6041.000=10.000

*mean*	1895.690-1440.812=454.878
σ	902.334-625.391=276.943
min	1027.603-1045.781=-18.177
max	3383.143-2704.363=678.779

op=load_product(), with indexes

*mean*	8744.559-8744.559=0.000
σ	0.033-0.033=-0.001
min	8744.544-8744.544=0.000
max	8744.640-8744.641=-0.001

*mean*	3836.000-3797.750=38.250
σ	1646.825-1676.607=-29.782
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	4739.142-4624.437=114.705
σ	1430.549-1476.191=-45.641
min	3510.580-3555.135=-44.555
max	7328.735-7280.586=48.150

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

*mean*	4055.000-4089.375=-34.375
σ	1618.391-1586.689=31.701
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	77.129-80.618=-3.489
σ	7.867-11.292=-3.425
min	70.106-69.711=0.395
max	89.205-101.029=-11.823

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944-40.944=-0.000
σ	0.001-0.002=-0.001
min	40.944-40.943=0.000
max	40.945-40.949=-0.004

*mean*	6051.000-6041.000=10.000
σ	0.000
min	6051.000-6041.000=10.000
max	6051.000-6041.000=10.000

*mean*	97.592-97.087=0.505
σ	16.258-9.054=7.204
min	74.015-84.252=-10.237
max	110.140-108.390=1.750

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

*mean*	6051.000-6041.000=10.000
σ	0.000
min	6051.000-6041.000=10.000
max	6051.000-6041.000=10.000

*mean*	149.008-228.993=-79.985
σ	24.759-235.166=-210.407
min	112.052-127.583=-15.531
max	167.669-810.060=-642.391

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833-11656.833=-0.000
σ	4.318-4.318=0.000
min	11655.305
max	11667.521

*mean*	4055.000-4089.375=-34.375
σ	1618.391-1586.689=31.701
min	2029.000-1890.000=139.000
max	6051.000-6041.000=10.000

*mean*	6544.898-6349.986=194.912
σ	1346.278-1228.679=117.599
min	4904.457-4965.952=-61.495
max	8350.793-8421.462=-70.670

op=vertical_lookup_list() on indexed

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

*mean*	6051.000-6041.000=10.000
σ	0.000
min	6051.000-6041.000=10.000
max	6051.000-6041.000=10.000

*mean*	6514.429-6734.869=-220.440
σ	1119.604-1478.364=-358.760
min	4379.703-4431.636=-51.933
max	7765.800-8227.745=-461.945

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.588-172.585=0.003
σ	0.028-0.022=0.005
min	172.560-172.558=0.002
max	172.622-172.621=0.001

*mean*	2029.000-1890.000=139.000
σ	0.000
min	2029.000-1890.000=139.000
max	2029.000-1890.000=139.000

*mean*	378.102-353.839=24.263
σ	55.608-29.934=25.674
min	324.491-291.427=33.064
max	502.947-391.767=111.180

op=pointedIndexFromKvs

rows=400000

*mean*	357.359-357.358=0.001
σ	0.036-0.035=0.000
min	357.321
max	357.398-357.406=-0.008

*mean*	2029.000-1890.000=139.000
σ	0.000
min	2029.000-1890.000=139.000
max	2029.000-1890.000=139.000

*mean*	748.423-755.574=-7.151
σ	66.550-58.611=7.939
min	626.510-620.056=6.454
max	809.518-796.550=12.968

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.188-1008.181=0.008
σ	0.876-0.923=-0.047
min	1007.686-1007.716=-0.030
max	1011.814-1012.019=-0.205

*mean*	1041.900-1038.750=3.150
σ	307.953-307.942=0.012
min	546.000-542.000=4.000
max	1474.000-1471.000=3.000

*mean*	1.561-1.592=-0.031
σ	0.102-0.146=-0.044
min	1.466-1.427=0.040
max	1.816-1.926=-0.110

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*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.419-0.439=-0.020
σ	0.139-0.184=-0.045
min	0.335-0.333=0.002
max	0.664-0.767=-0.103

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.886-0.924=-0.037
σ	0.080-0.163=-0.083
min	0.833-0.838=-0.005
max	1.025-1.214=-0.189

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.576-0.542=0.034
σ	0.090-0.049=0.041
min	0.517-0.499=0.017
max	0.735-0.625=0.111

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.857-0.834=0.023
σ	0.045-0.041=0.004
min	0.827-0.790=0.037
max	0.931-0.898=0.033

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.543-963.551=-0.008
σ	0.025-0.037=-0.012
min	963.523-963.527=-0.004
max	963.584-963.617=-0.033

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.811-0.809=0.002
σ	0.038-0.054=-0.016
min	0.769-0.728=0.041
max	0.852-0.863=-0.011

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.853=0.001
σ	0.008-0.009=-0.000
min	884.847
max	884.867-884.867=0.000

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.693-0.728=-0.035
σ	0.070-0.021=0.050
min	0.606-0.706=-0.100
max	0.754-0.747=0.007

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.711-7.711=0.001

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	4.279-3.565=0.714
σ	0.104-0.118=-0.014
min	4.115-3.410=0.705
max	4.659-4.028=0.631

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	4.261-3.509=0.752
σ	0.062-0.066=-0.004
min	4.133-3.419=0.714
max	4.480-3.747=0.732

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.748-0.753=-0.005
σ	0.015-0.017=-0.002
min	0.723-0.721=0.002
max	0.861-0.858=0.003

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.711-0.715=-0.004
σ	0.016-0.015=0.001
min	0.682-0.692=-0.010
max	0.777-0.802=-0.026

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.543-297.494=0.049
σ	0.246-0.203=0.043
min	297.351-297.320=0.031
max	298.216-298.021=0.195

*mean*	2029.000-1890.000=139.000
σ	0.000
min	2029.000-1890.000=139.000
max	2029.000-1890.000=139.000

*mean*	0.564-0.599=-0.035
σ	0.034-0.018=0.016
min	0.506-0.574=-0.068
max	0.608-0.625=-0.017

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.759-289.769=-0.010
σ	0.047-0.032=0.015
min	289.707-289.728=-0.022
max	289.813-289.803=0.011

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.405-0.398=0.008
σ	0.008-0.015=-0.007
min	0.398-0.378=0.020
max	0.415-0.421=-0.006

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.674-1299.664=0.010
σ	0.107-0.087=0.020
min	1299.525-1299.560=-0.034
max	1299.807-1299.779=0.027

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	2.300-2.078=0.222
σ	0.192-0.068=0.124
min	2.116-2.003=0.112
max	2.620-2.161=0.459

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.661-1542.610=0.051
σ	4.028-4.040=-0.012
min	1540.683-1540.603=0.081
max	1549.861-1549.828=0.033

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	2.307-2.233=0.074
σ	0.142-0.123=0.019
min	2.169-2.119=0.050
max	2.507-2.415=0.091

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.633-1861.623=0.010
σ	0.070-0.082=-0.012
min	1861.543-1861.495=0.048
max	1861.713-1861.701=0.012

*mean*	1726.000-1735.200=-9.200
σ	206.441-165.380=41.061
min	1545.000-1501.000=44.000
max	2029.000-1890.000=139.000

*mean*	2.894-3.077=-0.183
σ	0.128-0.246=-0.118
min	2.716-2.866=-0.151
max	3.062-3.478=-0.416

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.754-1.578=0.176
σ	0.091-0.140=-0.048
min	1.592-1.428=0.164
max	1.814-1.742=0.073

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.186-446.186=-0.000
σ	577.139-577.140=-0.000
min	157.615-157.615=0.000
max	1311.895-1311.896=-0.001

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	0.542-0.536=0.005
σ	0.559-0.539=0.020
min	0.262-0.263=-0.001
max	1.381-1.346=0.035

policies=20

*mean*	1576.423-1576.417=0.006
σ	0.352-0.345=0.007
min	1576.187-1576.186=0.000
max	1576.946-1576.930=0.017

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	2.621-2.621=-0.000
σ	0.012-0.004=0.009
min	2.609-2.618=-0.009
max	2.638-2.626=0.012

policies=200

*mean*	15772.214-15772.208=0.006
σ	0.152-0.120=0.032
min	15772.083-15772.088=-0.005
max	15772.392-15772.346=0.046

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1474.000-1471.000=3.000
σ	0.000
min	1474.000-1471.000=3.000
max	1474.000-1471.000=3.000

*mean*	26.452-26.499=-0.047
σ	0.110-0.078=0.032
min	26.304-26.406=-0.102
max	26.537-26.597=-0.060