Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.621-54.620=0.001
σ	0.350-0.347=0.003
min	54.492-54.494=-0.002
max	55.617-55.607=0.010

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

*mean*	0.139-0.140=-0.001
σ	0.005-0.004=0.001
min	0.132-0.136=-0.005
max	0.147-0.147=-0.000

cache=y

dps=1

iters=10

policies=100

*mean*	43.784-43.785=-0.001
σ	0.005-0.006=-0.001
min	43.775-43.778=-0.002
max	43.793-43.797=-0.004

*mean*	419.000
σ	0.000
min	419.000
max	419.000

*mean*	0.121-0.123=-0.002
σ	0.004-0.004=0.001
min	0.116-0.119=-0.003
max	0.128-0.129=-0.001

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

*mean*	4258.125-4266.125=-8.000
σ	1898.484-1879.633=18.850
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	12.286-12.254=0.032
σ	0.182-0.253=-0.071
min	12.081-11.913=0.168
max	12.584-12.726=-0.142

op=column_set() on indexed, repeat

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

*mean*	4258.125-4266.125=-8.000
σ	1898.484-1879.633=18.850
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	12.460-12.246=0.214
σ	0.642-0.678=-0.036
min	11.439-11.027=0.413
max	13.137-13.063=0.074

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*	7559.000-7548.000=11.000
σ	0.000
min	7559.000-7548.000=11.000
max	7559.000-7548.000=11.000

*mean*	13.726-14.208=-0.482
σ	1.409-1.448=-0.039
min	11.032-12.465=-1.433
max	15.308-17.074=-1.766

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.931-41.932=-0.001

*mean*	4187.625-4266.125=-78.500
σ	1951.592-1879.633=71.959
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	13.034-12.607=0.428
σ	1.886-2.111=-0.225
min	10.718-10.569=0.148
max	14.946-15.804=-0.858

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
max	27.607

*mean*	4187.625-4266.125=-78.500
σ	1951.592-1879.633=71.959
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	8.568-9.102=-0.534
σ	0.809-1.332=-0.524
min	7.747-8.178=-0.431
max	10.346-12.216=-1.870

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

*mean*	26.401-26.401=-0.000
σ	0.002-0.003=-0.001
min	26.399-26.399=-0.000
max	26.403-26.407=-0.004

*mean*	4258.125-4266.125=-8.000
σ	1898.484-1879.633=18.850
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	6.705-6.339=0.367
σ	0.752-1.305=-0.553
min	5.924-5.287=0.638
max	8.301-9.480=-1.178

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4258.125-4266.125=-8.000
σ	1898.484-1879.633=18.850
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	5.616-5.481=0.134
σ	0.226-0.185=0.042
min	5.335-5.229=0.106
max	6.067-5.775=0.293

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*	4258.125-4266.125=-8.000
σ	1898.484-1879.633=18.850
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	5.240-5.093=0.147
σ	0.227-0.165=0.062
min	4.765-4.864=-0.100
max	5.484-5.298=0.186

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.593=-0.000
max	2524.593-2524.594=-0.000

*mean*	7559.000-7548.000=11.000
σ	0.000
min	7559.000-7548.000=11.000
max	7559.000-7548.000=11.000

*mean*	1050.285-1059.970=-9.685
σ	5.488-13.438=-7.950
min	1042.765-1052.889=-10.125
max	1059.981-1092.922=-32.941

op=load_product(), with indexes

*mean*	8744.558-8744.558=-0.000
σ	0.033-0.033=-0.000
min	8744.544-8744.544=-0.000
max	8744.640-8744.640=-0.000

*mean*	3763.625-3788.750=-25.125
σ	1639.917-1608.469=31.448
min	1909.000-1979.000=-70.000
max	5949.000-5945.000=4.000

*mean*	4433.702-4595.951=-162.248
σ	1266.448-1433.191=-166.742
min	3545.109-3564.243=-19.134
max	6418.236-7103.437=-685.201

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

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

*mean*	4258.125-4266.125=-8.000
σ	1898.484-1879.633=18.850
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	82.730-82.991=-0.261
σ	12.451-15.753=-3.302
min	69.956-70.447=-0.491
max	105.862-119.522=-13.660

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.943=0.001
max	40.945

*mean*	7559.000-7548.000=11.000
σ	0.000
min	7559.000-7548.000=11.000
max	7559.000-7548.000=11.000

*mean*	99.260-97.954=1.306
σ	9.411-7.572=1.839
min	84.581-89.797=-5.216
max	107.958-107.106=0.852

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686-66.686=0.001
σ	0.001-0.000=0.001
min	66.685
max	66.690-66.687=0.003

*mean*	7559.000-7548.000=11.000
σ	0.000
min	7559.000-7548.000=11.000
max	7559.000-7548.000=11.000

*mean*	150.683-150.376=0.307
σ	15.649-12.905=2.744
min	126.353-134.153=-7.800
max	167.806-165.388=2.418

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833-11656.833=-0.000
σ	4.317-4.317=-0.000
min	11655.305-11655.305=0.000
max	11667.516-11667.517=-0.001

*mean*	4187.625-4266.125=-78.500
σ	1951.592-1879.633=71.959
min	1909.000-1979.000=-70.000
max	7559.000-7548.000=11.000

*mean*	6354.352-6564.837=-210.485
σ	1183.528-1289.760=-106.233
min	4961.971-4925.167=36.804
max	7949.842-8513.110=-563.268

op=vertical_lookup_list() on indexed

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

*mean*	7559.000-7548.000=11.000
σ	0.000
min	7559.000-7548.000=11.000
max	7559.000-7548.000=11.000

*mean*	5491.143-5183.161=307.981
σ	1154.106-1003.340=150.766
min	4430.071-4406.720=23.351
max	7421.783-7259.006=162.777

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.584-172.586=-0.002
σ	0.023-0.025=-0.001
min	172.558
max	172.622-172.620=0.001

*mean*	1909.000-1979.000=-70.000
σ	0.000
min	1909.000-1979.000=-70.000
max	1909.000-1979.000=-70.000

*mean*	360.555-355.968=4.587
σ	42.869-58.790=-15.921
min	259.985-265.817=-5.832
max	391.256-408.002=-16.746

op=pointedIndexFromKvs

rows=400000

*mean*	357.363-357.360=0.003
σ	0.040-0.041=-0.001
min	357.321
max	357.408-357.402=0.005

*mean*	1909.000-1979.000=-70.000
σ	0.000
min	1909.000-1979.000=-70.000
max	1909.000-1979.000=-70.000

*mean*	793.231-751.728=41.503
σ	10.521-61.180=-50.659
min	774.369-630.623=143.746
max	808.350-796.623=11.727

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.186-1008.182=0.004
σ	0.860-0.879=-0.019
min	1007.688-1007.687=0.002
max	1011.735-1011.826=-0.091

*mean*	1051.800-1039.200=12.600
σ	301.670-297.177=4.493
min	550.000-547.000=3.000
max	1456.000-1440.000=16.000

*mean*	1.537-1.536=0.002
σ	0.085-0.090=-0.004
min	1.455-1.454=0.001
max	1.747-1.763=-0.015

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*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.421-0.422=-0.001
σ	0.126-0.122=0.004
min	0.341-0.348=-0.007
max	0.644-0.636=0.008

name=error_case.art

*mean*	2.333-2.334=-0.000
σ	0.003-0.002=0.000
min	2.332
max	2.337

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.882-0.900=-0.018
σ	0.087-0.086=0.000
min	0.818-0.837=-0.019
max	1.030-1.051=-0.022

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.542-0.550=-0.008
σ	0.046-0.051=-0.005
min	0.507-0.510=-0.003
max	0.620-0.635=-0.015

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.840-0.845=-0.006
σ	0.039-0.047=-0.008
min	0.815-0.811=0.004
max	0.908-0.923=-0.015

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.030-0.031=-0.001
min	963.523
max	963.595-963.597=-0.002

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.833-0.815=0.018
σ	0.038-0.047=-0.009
min	0.773-0.742=0.031
max	0.867-0.858=0.009

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.854=0.000
σ	0.007-0.007=0.000
min	884.847
max	884.862

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.702-0.731=-0.029
σ	0.039-0.032=0.006
min	0.662-0.673=-0.011
max	0.745-0.749=-0.004

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.709=0.001

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	4.245-4.247=-0.003
σ	0.097-0.087=0.009
min	4.085-4.104=-0.020
max	4.593-4.537=0.056

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	4.236-4.240=-0.004
σ	0.068-0.104=-0.035
min	4.091-4.037=0.054
max	4.491-4.802=-0.311

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.751-0.752=-0.001
σ	0.021-0.033=-0.012
min	0.652-0.702=-0.050
max	0.883-0.851=0.032

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.711-0.723=-0.013
σ	0.033-0.034=-0.001
min	0.674-0.669=0.005
max	0.994-0.805=0.189

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.386-297.445=-0.059
σ	0.233-0.243=-0.009
min	297.171-297.278=-0.107
max	298.018-298.114=-0.097

*mean*	1909.000-1979.000=-70.000
σ	0.000
min	1909.000-1979.000=-70.000
max	1909.000-1979.000=-70.000

*mean*	0.591-0.581=0.010
σ	0.057-0.031=0.025
min	0.512-0.516=-0.004
max	0.722-0.612=0.109

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.729-289.729=-0.000
σ	0.051-0.041=0.010
min	289.653-289.660=-0.007
max	289.788-289.762=0.026

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.392-0.407=-0.016
σ	0.008-0.013=-0.005
min	0.384-0.393=-0.009
max	0.404-0.418=-0.014

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.699-1299.689=0.010
σ	0.049-0.045=0.005
min	1299.647-1299.632=0.015
max	1299.744-1299.741=0.003

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	2.191-2.268=-0.077
σ	0.058-0.084=-0.026
min	2.114-2.177=-0.063
max	2.263-2.343=-0.079

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.735-1542.722=0.013
σ	4.018-4.014=0.003
min	1540.797-1540.763=0.034
max	1549.918-1549.898=0.020

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	2.373-2.298=0.075
σ	0.196-0.100=0.096
min	2.173-2.181=-0.007
max	2.701-2.400=0.301

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.619-1861.630=-0.011
σ	0.073-0.070=0.002
min	1861.540-1861.565=-0.024
max	1861.717-1861.728=-0.011

*mean*	1745.400-1767.800=-22.400
σ	175.078-223.150=-48.072
min	1500.000-1475.000=25.000
max	1909.000-1979.000=-70.000

*mean*	3.065-3.332=-0.268
σ	0.272-0.451=-0.179
min	2.780-2.870=-0.090
max	3.472-3.846=-0.374

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.777-1.796=-0.019
σ	0.153-0.063=0.089
min	1.512-1.712=-0.199
max	1.898-1.875=0.023

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.665-446.666=-0.001
σ	577.138-577.138=0.000
min	158.091-158.093=-0.002
max	1312.372-1312.373=-0.001

*mean*	98.250
σ	8.500
min	94.000
max	111.000

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	0.548-0.533=0.015
σ	0.564-0.540=0.024
min	0.264-0.262=0.002
max	1.395-1.344=0.051

policies=20

*mean*	1581.223-1581.232=-0.009
σ	0.369-0.353=0.016
min	1580.973-1580.985=-0.012
max	1581.771-1581.755=0.016

*mean*	940.000
σ	0.000
min	940.000
max	940.000

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	2.643-2.623=0.020
σ	0.014-0.019=-0.004
min	2.624-2.604=0.020
max	2.658-2.639=0.019

policies=200

*mean*	15820.424-15820.489=-0.065
σ	0.087-0.079=0.009
min	15820.347-15820.421=-0.074
max	15820.545-15820.602=-0.057

*mean*	9400.000
σ	0.000
min	9400.000
max	9400.000

*mean*	1456.000-1440.000=16.000
σ	0.000
min	1456.000-1440.000=16.000
max	1456.000-1440.000=16.000

*mean*	26.607-26.560=0.046
σ	0.137-0.014=0.123
min	26.428-26.547=-0.120
max	26.753-26.581=0.173