Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-54.617=-0.001
σ	0.352-0.348=0.003
min	54.478-54.489=-0.010
max	55.616-55.609=0.007

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.138-0.145=-0.006
σ	0.006-0.008=-0.002
min	0.130-0.136=-0.006
max	0.147-0.157=-0.010

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.787=-0.002
σ	0.006-0.006=-0.000
min	43.776-43.777=-0.001
max	43.798-43.796=0.002

*mean*	418.000
σ	0.000
min	418.000
max	418.000

*mean*	0.123-0.130=-0.007
σ	0.003-0.011=-0.008
min	0.120-0.119=0.000
max	0.128-0.149=-0.021

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

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

*mean*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	12.417-12.563=-0.145
σ	0.177-0.271=-0.094
min	12.116-12.245=-0.129
max	12.612-12.968=-0.356

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

*mean*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	12.192-12.654=-0.462
σ	0.641-0.454=0.187
min	11.372-11.772=-0.400
max	13.094-13.137=-0.043

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-6044.000=7.000
σ	0.000
min	6051.000-6044.000=7.000
max	6051.000-6044.000=7.000

*mean*	13.366-13.137=0.229
σ	1.117-1.339=-0.221
min	11.252-11.006=0.246
max	14.925-15.221=-0.296

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.931=-0.000

*mean*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	12.747-12.460=0.287
σ	2.055-1.823=0.232
min	10.311-10.542=-0.231
max	15.230-14.723=0.507

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*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	8.846-8.376=0.470
σ	1.280-0.350=0.930
min	7.805-7.794=0.011
max	11.875-8.843=3.032

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

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

*mean*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	6.933-6.221=0.712
σ	1.027-0.404=0.623
min	6.235-5.376=0.859
max	9.413-6.719=2.694

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	5.519-5.556=-0.037
σ	0.066-0.169=-0.102
min	5.381-5.321=0.060
max	5.582-5.832=-0.250

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*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	5.294-5.206=0.088
σ	0.236-0.206=0.030
min	4.725-4.887=-0.161
max	5.458-5.449=0.008

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

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

*mean*	6051.000-6044.000=7.000
σ	0.000
min	6051.000-6044.000=7.000
max	6051.000-6044.000=7.000

*mean*	1472.355-1515.739=-43.384
σ	675.656-732.651=-56.994
min	1028.058-1047.798=-19.740
max	2607.703-3039.490=-431.787

op=load_product(), with indexes

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

*mean*	3824.375-3810.000=14.375
σ	1653.325-1662.690=-9.365
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	4394.566-4871.261=-476.696
σ	1215.926-1461.380=-245.455
min	3518.673-3563.534=-44.861
max	6739.720-7157.927=-418.207

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.076-62.076=0.000
max	62.080

*mean*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	83.394-82.466=0.928
σ	17.512-12.336=5.176
min	70.615-69.810=0.804
max	121.708-101.878=19.831

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944
σ	0.001
min	40.944
max	40.945

*mean*	6051.000-6044.000=7.000
σ	0.000
min	6051.000-6044.000=7.000
max	6051.000-6044.000=7.000

*mean*	94.048-95.715=-1.667
σ	10.976-10.823=0.154
min	73.697-78.543=-4.846
max	106.777-106.834=-0.057

op=vertical_lookup_row_list() on unindexed small unique Int

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

*mean*	6051.000-6044.000=7.000
σ	0.000
min	6051.000-6044.000=7.000
max	6051.000-6044.000=7.000

*mean*	227.037-235.082=-8.045
σ	241.336-266.736=-25.400
min	110.584-115.897=-5.313
max	822.790-893.991=-71.201

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833-11656.832=0.001
σ	4.318-4.317=0.001
min	11655.305
max	11667.521-11667.517=0.004

*mean*	4107.250-4096.750=10.500
σ	1571.951-1579.053=-7.102
min	1973.000-1941.000=32.000
max	6051.000-6044.000=7.000

*mean*	6187.664-6610.329=-422.665
σ	1293.909-1347.756=-53.847
min	4904.547-4971.099=-66.552
max	7861.776-8529.833=-668.057

op=vertical_lookup_list() on indexed

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

*mean*	6051.000-6044.000=7.000
σ	0.000
min	6051.000-6044.000=7.000
max	6051.000-6044.000=7.000

*mean*	6429.007-6649.482=-220.475
σ	1168.088-1437.394=-269.306
min	4398.251-4458.839=-60.588
max	7804.055-7798.860=5.195

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.583-172.583=-0.000
σ	0.024-0.024=0.000
min	172.558
max	172.619-172.619=-0.000

*mean*	1973.000-1941.000=32.000
σ	0.000
min	1973.000-1941.000=32.000
max	1973.000-1941.000=32.000

*mean*	352.560-357.448=-4.888
σ	52.832-43.137=9.695
min	261.727-262.879=-1.152
max	409.684-401.649=8.035

op=pointedIndexFromKvs

rows=400000

*mean*	357.362-357.367=-0.005
σ	0.040-0.044=-0.003
min	357.321
max	357.405-357.420=-0.016

*mean*	1973.000-1941.000=32.000
σ	0.000
min	1973.000-1941.000=32.000
max	1973.000-1941.000=32.000

*mean*	783.061-779.724=3.337
σ	24.291-27.142=-2.851
min	732.768-731.570=1.199
max	806.227-808.918=-2.691

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.185-1008.189=-0.004
σ	0.886-0.895=-0.009
min	1007.685-1007.686=-0.001
max	1011.865-1011.905=-0.039

*mean*	1052.650-1056.550=-3.900
σ	313.439-302.038=11.401
min	568.000-552.000=16.000
max	1515.000-1464.000=51.000

*mean*	1.551-1.541=0.010
σ	0.083-0.066=0.017
min	1.419-1.475=-0.057
max	1.770-1.748=0.022

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883-0.882=0.001
σ	0.002-0.002=0.000
min	0.881
max	0.886

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.440-0.416=0.025
σ	0.174-0.121=0.054
min	0.336-0.346=-0.010
max	0.750-0.630=0.120

name=error_case.art

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

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.929-0.882=0.047
σ	0.175-0.091=0.084
min	0.819-0.830=-0.011
max	1.238-1.043=0.195

name=heavy_item.art

*mean*	1.521-1.521=0.001
σ	0.002-0.001=0.001
min	1.520
max	1.524-1.523=0.001

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.540-0.544=-0.003
σ	0.049-0.050=-0.002
min	0.502-0.504=-0.002
max	0.623-0.631=-0.008

name=nested_use.art

*mean*	2.355-2.356=-0.001
σ	0.002-0.002=-0.000
min	2.355
max	2.358

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.841-0.839=0.001
σ	0.044-0.046=-0.002
min	0.798-0.802=-0.004
max	0.904-0.916=-0.012

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.549-963.540=0.008
σ	0.030-0.028=0.003
min	963.528-963.523=0.005
max	963.602-963.589=0.013

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.759-0.800=-0.041
σ	0.083-0.053=0.029
min	0.656-0.745=-0.090
max	0.853-0.858=-0.004

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.854=-0.001
σ	0.007-0.004=0.002
min	884.847-884.851=-0.004
max	884.863-884.862=0.001

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.717-0.724=-0.007
σ	0.037-0.034=0.004
min	0.658-0.670=-0.012
max	0.743-0.749=-0.005

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

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	4.276-4.286=-0.011
σ	0.099-0.071=0.028
min	4.138-4.167=-0.029
max	4.706-4.533=0.173

name=record_render_large_syntax_err.art

*mean*	7.655-7.655=0.000
σ	0.002-0.002=0.000
min	7.654
max	7.659-7.658=0.001

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	4.259-4.278=-0.019
σ	0.085-0.073=0.012
min	4.084-4.152=-0.068
max	4.496-4.535=-0.040

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.750-0.757=-0.007
σ	0.018-0.019=-0.000
min	0.717-0.722=-0.005
max	0.841-0.870=-0.030

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.717-0.716=0.001
σ	0.019-0.018=0.001
min	0.628-0.651=-0.024
max	0.810-0.793=0.017

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.479-297.443=0.036
σ	0.188-0.216=-0.028
min	297.342-297.291=0.051
max	297.993-298.030=-0.037

*mean*	1973.000-1941.000=32.000
σ	0.000
min	1973.000-1941.000=32.000
max	1973.000-1941.000=32.000

*mean*	0.588-0.585=0.003
σ	0.026-0.051=-0.026
min	0.548-0.525=0.023
max	0.633-0.706=-0.074

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.767-289.776=-0.009
σ	0.040-0.032=0.008
min	289.722-289.730=-0.008
max	289.810-289.807=0.003

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.400-0.402=-0.002
σ	0.011-0.006=0.004
min	0.394-0.396=-0.003
max	0.419-0.413=0.006

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.647-1299.663=-0.016
σ	0.075-0.054=0.021
min	1299.555-1299.620=-0.065
max	1299.720-1299.739=-0.019

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	2.089-2.168=-0.078
σ	0.062-0.107=-0.045
min	2.012-2.038=-0.027
max	2.162-2.284=-0.122

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.630-1542.709=-0.079
σ	4.015-3.993=0.022
min	1540.597-1540.785=-0.188
max	1549.804-1549.849=-0.044

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	2.279-2.488=-0.209
σ	0.200-0.197=0.004
min	2.099-2.217=-0.118
max	2.597-2.668=-0.070

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.632-1861.630=0.002
σ	0.077-0.074=0.003
min	1861.515-1861.523=-0.008
max	1861.715-1861.705=0.011

*mean*	1773.800-1756.200=17.600
σ	206.478-192.569=13.909
min	1515.000-1511.000=4.000
max	1973.000-1941.000=32.000

*mean*	3.272-3.282=-0.009
σ	0.413-0.389=0.024
min	2.850-2.856=-0.006
max	3.752-3.859=-0.107

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.643-1.806=-0.163
σ	0.201-0.188=0.012
min	1.338-1.474=-0.137
max	1.830-1.936=-0.106

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.185-446.182=0.002
σ	577.139-577.140=-0.001
min	157.613-157.609=0.004
max	1311.894-1311.893=0.001

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	0.540-0.538=0.002
σ	0.553-0.537=0.016
min	0.262-0.266=-0.004
max	1.369-1.343=0.026

policies=20

*mean*	1576.414-1576.397=0.018
σ	0.350-0.355=-0.005
min	1576.175-1576.159=0.017
max	1576.934-1576.925=0.009

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	2.616-2.632=-0.016
σ	0.022-0.005=0.018
min	2.587-2.628=-0.041
max	2.640-2.638=0.002

policies=200

*mean*	15772.219-15772.160=0.059
σ	0.078-0.109=-0.031
min	15772.121-15772.031=0.090
max	15772.313-15772.288=0.025

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1515.000-1464.000=51.000
σ	0.000
min	1515.000-1464.000=51.000
max	1515.000-1464.000=51.000

*mean*	26.482-26.569=-0.086
σ	0.038-0.040=-0.002
min	26.440-26.521=-0.081
max	26.528-26.616=-0.087