Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.616=0.001
σ	0.348-0.347=0.001
min	54.489-54.482=0.007
max	55.609-55.604=0.005

*mean*	418.000-415.000=3.000
σ	0.000
min	418.000-415.000=3.000
max	418.000-415.000=3.000

*mean*	0.145-0.138=0.006
σ	0.008-0.004=0.004
min	0.136-0.134=0.002
max	0.157-0.144=0.013

cache=y

dps=1

iters=10

policies=100

*mean*	43.787-43.785=0.002
σ	0.006-0.007=-0.001
min	43.777-43.777=0.000
max	43.796-43.801=-0.005

*mean*	418.000-415.000=3.000
σ	0.000
min	418.000-415.000=3.000
max	418.000-415.000=3.000

*mean*	0.130-0.123=0.007
σ	0.011-0.004=0.006
min	0.119-0.115=0.004
max	0.149-0.129=0.019

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

*mean*	4096.750-4269.625=-172.875
σ	1579.053-1895.506=-316.453
min	1941.000-1968.000=-27.000
max	6044.000-7585.000=-1541.000

*mean*	12.563-13.012=-0.449
σ	0.271-1.705=-1.435
min	12.245-11.954=0.291
max	12.968-17.159=-4.190

op=column_set() on indexed, repeat

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

*mean*	4096.750-4269.625=-172.875
σ	1579.053-1895.506=-316.453
min	1941.000-1968.000=-27.000
max	6044.000-7585.000=-1541.000

*mean*	12.654-13.049=-0.396
σ	0.454-1.794=-1.340
min	11.772-11.111=0.661
max	13.137-16.968=-3.831

op=table_records(), no indexes

*mean*	41.928-41.929=-0.000
σ	0.000-0.002=-0.001
min	41.928-41.928=0.000
max	41.929-41.933=-0.004

*mean*	6044.000-7585.000=-1541.000
σ	0.000
min	6044.000-7585.000=-1541.000
max	6044.000-7585.000=-1541.000

*mean*	13.137-13.598=-0.460
σ	1.339-1.185=0.153
min	11.006-12.080=-1.075
max	15.221-14.905=0.317

op=table_records(), repeat

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

*mean*	4096.750-4005.875=90.875
σ	1579.053-1591.677=-12.623
min	1941.000-1968.000=-27.000
max	6044.000-5964.000=80.000

*mean*	12.460-12.945=-0.485
σ	1.823-1.898=-0.075
min	10.542-10.203=0.339
max	14.723-14.592=0.131

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

*mean*	27.605-27.605=-0.001
σ	0.002-0.003=-0.001
min	27.603-27.603=-0.000
max	27.607-27.611=-0.004

*mean*	4096.750-4005.875=90.875
σ	1579.053-1591.677=-12.623
min	1941.000-1968.000=-27.000
max	6044.000-5964.000=80.000

*mean*	8.376-8.477=-0.101
σ	0.350-0.357=-0.007
min	7.794-8.019=-0.225
max	8.843-8.954=-0.111

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

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

*mean*	4096.750-4067.000=29.750
σ	1579.053-1544.638=34.416
min	1941.000-1968.000=-27.000
max	6044.000-5964.000=80.000

*mean*	6.221-6.443=-0.222
σ	0.404-0.441=-0.037
min	5.376-5.839=-0.464
max	6.719-7.099=-0.380

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4096.750-4269.625=-172.875
σ	1579.053-1895.506=-316.453
min	1941.000-1968.000=-27.000
max	6044.000-7585.000=-1541.000

*mean*	5.556-5.639=-0.083
σ	0.169-0.545=-0.377
min	5.321-5.361=-0.040
max	5.832-6.972=-1.141

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

*mean*	4096.750-4269.625=-172.875
σ	1579.053-1895.506=-316.453
min	1941.000-1968.000=-27.000
max	6044.000-7585.000=-1541.000

*mean*	5.206-5.498=-0.292
σ	0.206-0.596=-0.390
min	4.887-5.182=-0.296
max	5.449-6.964=-1.515

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

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

*mean*	6044.000-7585.000=-1541.000
σ	0.000
min	6044.000-7585.000=-1541.000
max	6044.000-7585.000=-1541.000

*mean*	1515.739-1159.533=356.207
σ	732.651-215.417=517.234
min	1047.798-1036.990=10.808
max	3039.490-1513.559=1525.931

op=load_product(), with indexes

*mean*	8744.558-8744.558=0.000
σ	0.033-0.032=0.001
min	8744.544-8744.545=-0.001
max	8744.641-8744.638=0.003

*mean*	3810.000-3787.500=22.500
σ	1662.690-1621.106=41.584
min	1941.000-1968.000=-27.000
max	6044.000-5964.000=80.000

*mean*	4871.261-4521.210=350.051
σ	1461.380-1347.330=114.050
min	3563.534-3561.119=2.414
max	7157.927-7013.614=144.313

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

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

*mean*	4096.750-4269.625=-172.875
σ	1579.053-1895.506=-316.453
min	1941.000-1968.000=-27.000
max	6044.000-7585.000=-1541.000

*mean*	82.466-191.544=-109.078
σ	12.336-324.030=-311.694
min	69.810-71.195=-1.384
max	101.878-993.342=-891.465

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	6044.000-7585.000=-1541.000
σ	0.000
min	6044.000-7585.000=-1541.000
max	6044.000-7585.000=-1541.000

*mean*	95.715-99.348=-3.633
σ	10.823-9.775=1.047
min	78.543-81.963=-3.420
max	106.834-107.841=-1.007

op=vertical_lookup_row_list() on unindexed small unique Int

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

*mean*	6044.000-7585.000=-1541.000
σ	0.000
min	6044.000-7585.000=-1541.000
max	6044.000-7585.000=-1541.000

*mean*	235.082-321.231=-86.148
σ	266.736-486.430=-219.694
min	115.897-129.030=-13.133
max	893.991-1524.493=-630.501

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

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

*mean*	4096.750-4005.875=90.875
σ	1579.053-1591.677=-12.623
min	1941.000-1968.000=-27.000
max	6044.000-5964.000=80.000

*mean*	6610.329-6070.938=539.391
σ	1347.756-1010.729=337.027
min	4971.099-4973.271=-2.172
max	8529.833-7525.121=1004.712

op=vertical_lookup_list() on indexed

*mean*	11560.069-11560.065=0.004
σ	0.001-0.001=0.000
min	11560.066-11560.064=0.002
max	11560.069-11560.066=0.003

*mean*	6044.000-7585.000=-1541.000
σ	0.000
min	6044.000-7585.000=-1541.000
max	6044.000-7585.000=-1541.000

*mean*	6649.482-5439.436=1210.046
σ	1437.394-1283.370=154.024
min	4458.839-4399.257=59.582
max	7798.860-7189.765=609.095

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.583-172.588=-0.005
σ	0.024-0.027=-0.003
min	172.558
max	172.619-172.621=-0.002

*mean*	1941.000-1968.000=-27.000
σ	0.000
min	1941.000-1968.000=-27.000
max	1941.000-1968.000=-27.000

*mean*	357.448-368.627=-11.179
σ	43.137-22.546=20.591
min	262.879-337.815=-74.936
max	401.649-397.697=3.952

op=pointedIndexFromKvs

rows=400000

*mean*	357.367-357.363=0.004
σ	0.044-0.041=0.002
min	357.321
max	357.420-357.421=-0.001

*mean*	1941.000-1968.000=-27.000
σ	0.000
min	1941.000-1968.000=-27.000
max	1941.000-1968.000=-27.000

*mean*	779.724-759.199=20.525
σ	27.142-47.420=-20.278
min	731.570-650.376=81.194
max	808.918-797.692=11.226

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.189-1008.183=0.007
σ	0.895-0.904=-0.009
min	1007.686-1007.716=-0.029
max	1011.905-1011.945=-0.041

*mean*	1056.550-1037.600=18.950
σ	302.038-303.292=-1.254
min	552.000-556.000=-4.000
max	1464.000-1465.000=-1.000

*mean*	1.541-1.567=-0.026
σ	0.066-0.149=-0.083
min	1.475-1.428=0.048
max	1.748-2.070=-0.322

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

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

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.416-0.413=0.002
σ	0.121-0.129=-0.008
min	0.346-0.334=0.012
max	0.630-0.641=-0.011

name=error_case.art

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

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.882-0.877=0.005
σ	0.091-0.100=-0.009
min	0.830-0.817=0.013
max	1.043-1.050=-0.007

name=heavy_item.art

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

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.544-0.549=-0.005
σ	0.050-0.041=0.010
min	0.504-0.513=-0.008
max	0.631-0.619=0.012

name=nested_use.art

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

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.839-0.836=0.003
σ	0.046-0.043=0.002
min	0.802-0.804=-0.003
max	0.916-0.907=0.009

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.540-963.541=-0.001
σ	0.028-0.032=-0.004
min	963.523
max	963.589-963.596=-0.007

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.800-0.818=-0.018
σ	0.053-0.033=0.021
min	0.745-0.770=-0.025
max	0.858-0.851=0.007

name=cdr_enhanced_4k_loc.art

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

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.724-0.709=0.015
σ	0.034-0.029=0.005
min	0.670-0.671=-0.001
max	0.749-0.740=0.009

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.711=-0.002

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	4.286-4.268=0.019
σ	0.071-0.084=-0.013
min	4.167-4.131=0.036
max	4.533-4.595=-0.062

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	4.278-4.245=0.032
σ	0.073-0.057=0.016
min	4.152-4.126=0.026
max	4.535-4.420=0.116

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.757-0.753=0.004
σ	0.019-0.016=0.003
min	0.722-0.720=0.003
max	0.870-0.859=0.011

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.716-0.719=-0.004
σ	0.018-0.016=0.002
min	0.651-0.692=-0.041
max	0.793-0.812=-0.019

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.443-297.345=0.098
σ	0.216-0.179=0.037
min	297.291-297.218=0.073
max	298.030-297.839=0.191

*mean*	1941.000-1968.000=-27.000
σ	0.000
min	1941.000-1968.000=-27.000
max	1941.000-1968.000=-27.000

*mean*	0.585-0.564=0.021
σ	0.051-0.034=0.018
min	0.525-0.518=0.007
max	0.706-0.609=0.098

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.776-289.773=0.003
σ	0.032-0.038=-0.005
min	289.730-289.729=0.001
max	289.807-289.814=-0.006

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.402-0.404=-0.003
σ	0.006-0.010=-0.003
min	0.396-0.396=0.001
max	0.413-0.417=-0.004

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.663-1299.663=0.000
σ	0.054-0.097=-0.043
min	1299.620-1299.565=0.055
max	1299.739-1299.797=-0.058

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	2.168-2.156=0.012
σ	0.107-0.173=-0.066
min	2.038-1.881=0.157
max	2.284-2.317=-0.033

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.709-1542.690=0.019
σ	3.993-4.022=-0.028
min	1540.785-1540.737=0.048
max	1549.849-1549.880=-0.032

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	2.488-2.403=0.086
σ	0.197-0.152=0.045
min	2.217-2.257=-0.040
max	2.668-2.642=0.025

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.630-1861.629=0.001
σ	0.074-0.061=0.014
min	1861.523-1861.547=-0.024
max	1861.705-1861.698=0.007

*mean*	1756.200-1716.200=40.000
σ	192.569-170.390=22.179
min	1511.000-1524.000=-13.000
max	1941.000-1968.000=-27.000

*mean*	3.282-2.941=0.341
σ	0.389-0.174=0.215
min	2.856-2.726=0.130
max	3.859-3.193=0.665

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.806-1.834=-0.028
σ	0.188-0.027=0.162
min	1.474-1.804=-0.329
max	1.936-1.863=0.073

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.182-446.186=-0.004
σ	577.140-577.140=0.000
min	157.609-157.615=-0.006
max	1311.893-1311.896=-0.004

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	0.538-0.546=-0.008
σ	0.537-0.566=-0.030
min	0.266-0.250=0.015
max	1.343-1.395=-0.052

policies=20

*mean*	1576.397-1576.422=-0.025
σ	0.355-0.348=0.007
min	1576.159-1576.187=-0.028
max	1576.925-1576.939=-0.014

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	2.632-2.626=0.006
σ	0.005-0.014=-0.009
min	2.628-2.606=0.022
max	2.638-2.636=0.002

policies=200

*mean*	15772.160-15772.049=0.111
σ	0.109-0.411=-0.301
min	15772.031-15771.443=0.588
max	15772.288-15772.341=-0.053

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1464.000-1465.000=-1.000
σ	0.000
min	1464.000-1465.000=-1.000
max	1464.000-1465.000=-1.000

*mean*	26.569-26.473=0.095
σ	0.040-0.150=-0.110
min	26.521-26.255=0.266
max	26.616-26.577=0.038