Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.617=-0.000
σ	0.352-0.350=0.001
min	54.482-54.480=0.001
max	55.617-55.614=0.003

*mean*	415.000-416.000=-1.000
σ	0.000
min	415.000-416.000=-1.000
max	415.000-416.000=-1.000

*mean*	0.141-0.141=-0.000
σ	0.004-0.004=0.000
min	0.135-0.137=-0.001
max	0.146-0.148=-0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.785=-0.000
σ	0.007-0.006=0.002
min	43.775-43.779=-0.004
max	43.803-43.796=0.007

*mean*	415.000-416.000=-1.000
σ	0.000
min	415.000-416.000=-1.000
max	415.000-416.000=-1.000

*mean*	0.120-0.122=-0.002
σ	0.004-0.005=-0.001
min	0.115-0.116=-0.001
max	0.127-0.129=-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*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	12.109-12.371=-0.262
σ	0.322-0.261=0.061
min	11.702-11.957=-0.254
max	12.545-12.858=-0.313

op=column_set() on indexed, repeat

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

*mean*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	11.394-11.880=-0.486
σ	0.312-0.670=-0.358
min	10.954-11.267=-0.313
max	11.955-12.974=-1.019

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*	6050.000-6038.000=12.000
σ	0.000
min	6050.000-6038.000=12.000
max	6050.000-6038.000=12.000

*mean*	13.184-13.279=-0.096
σ	1.104-1.143=-0.039
min	11.451-10.943=0.508
max	15.094-14.747=0.347

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*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	12.701-12.439=0.262
σ	1.812-1.836=-0.024
min	10.382-10.549=-0.167
max	14.930-14.877=0.054

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

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

*mean*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	8.648-8.460=0.188
σ	1.399-0.292=1.108
min	7.515-8.012=-0.497
max	11.979-8.800=3.179

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

*mean*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	6.655-6.414=0.241
σ	1.202-0.190=1.012
min	5.943-6.061=-0.117
max	9.599-6.609=2.990

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.669-25.670=-0.000

*mean*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	5.169-5.456=-0.288
σ	0.122-0.137=-0.015
min	5.011-5.265=-0.254
max	5.369-5.622=-0.254

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*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	5.010-5.343=-0.332
σ	0.152-0.078=0.074
min	4.693-5.191=-0.498
max	5.188-5.437=-0.249

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

*mean*	6050.000-6038.000=12.000
σ	0.000
min	6050.000-6038.000=12.000
max	6050.000-6038.000=12.000

*mean*	1514.481-1452.458=62.023
σ	760.963-613.448=147.515
min	1047.308-1052.371=-5.062
max	3035.621-2420.653=614.968

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

*mean*	3807.875-3820.000=-12.125
σ	1672.726-1646.133=26.593
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	4352.119-4527.703=-175.584
σ	1403.276-1382.987=20.289
min	3558.020-3558.093=-0.073
max	7620.761-7300.673=320.088

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*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	85.844-81.442=4.402
σ	19.177-9.937=9.240
min	70.148-70.628=-0.480
max	125.798-98.344=27.455

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944-40.944=0.000
σ	0.001-0.001=0.000
min	40.944
max	40.945-40.945=0.000

*mean*	6050.000-6038.000=12.000
σ	0.000
min	6050.000-6038.000=12.000
max	6050.000-6038.000=12.000

*mean*	97.821-97.183=0.638
σ	8.693-8.667=0.026
min	84.154-85.078=-0.924
max	108.148-107.736=0.412

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

*mean*	6050.000-6038.000=12.000
σ	0.000
min	6050.000-6038.000=12.000
max	6050.000-6038.000=12.000

*mean*	227.547-228.591=-1.044
σ	234.554-237.620=-3.067
min	123.560-125.111=-1.552
max	807.026-815.743=-8.717

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*	4098.125-4101.000=-2.875
σ	1584.399-1566.663=17.736
min	1913.000-1981.000=-68.000
max	6050.000-6038.000=12.000

*mean*	6415.452-6493.128=-77.676
σ	1339.306-1371.010=-31.704
min	4926.819-4964.980=-38.161
max	8349.008-8375.641=-26.633

op=vertical_lookup_list() on indexed

*mean*	11560.069-11560.069=-0.000
σ	0.002-0.002=-0.000
min	11560.067
max	11560.072-11560.073=-0.001

*mean*	6050.000-6038.000=12.000
σ	0.000
min	6050.000-6038.000=12.000
max	6050.000-6038.000=12.000

*mean*	6586.916-6593.968=-7.051
σ	1401.614-1432.762=-31.148
min	4399.790-4445.130=-45.340
max	8285.899-8281.056=4.843

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.585-172.581=0.003
σ	0.027-0.023=0.003
min	172.558
max	172.627-172.610=0.017

*mean*	1913.000-1981.000=-68.000
σ	0.000
min	1913.000-1981.000=-68.000
max	1913.000-1981.000=-68.000

*mean*	357.051-343.709=13.342
σ	40.885-39.242=1.643
min	268.727-272.006=-3.279
max	401.111-392.553=8.557

op=pointedIndexFromKvs

rows=400000

*mean*	357.360-357.367=-0.007
σ	0.037-0.046=-0.009
min	357.321
max	357.396-357.438=-0.042

*mean*	1913.000-1981.000=-68.000
σ	0.000
min	1913.000-1981.000=-68.000
max	1913.000-1981.000=-68.000

*mean*	772.113-782.343=-10.230
σ	17.710-15.766=1.944
min	742.566-763.619=-21.053
max	795.285-803.557=-8.272

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.186-1008.185=0.001
σ	0.865-0.877=-0.012
min	1007.684-1007.687=-0.004
max	1011.762-1011.818=-0.056

*mean*	1038.800-1041.850=-3.050
σ	304.463-306.731=-2.268
min	554.000-546.000=8.000
max	1464.000-1471.000=-7.000

*mean*	1.539-1.544=-0.005
σ	0.137-0.132=0.005
min	1.371-1.456=-0.085
max	2.009-2.027=-0.018

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*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.437-0.441=-0.004
σ	0.124-0.123=0.001
min	0.360-0.376=-0.016
max	0.656-0.661=-0.005

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.915-0.906=0.009
σ	0.086-0.095=-0.008
min	0.860-0.838=0.022
max	1.067-1.069=-0.002

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.559-0.551=0.008
σ	0.051-0.052=-0.001
min	0.517-0.509=0.008
max	0.644-0.641=0.003

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.864-0.865=-0.001
σ	0.031-0.040=-0.010
min	0.844-0.835=0.009
max	0.917-0.928=-0.010

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.920-963.922=-0.002
σ	0.027-0.025=0.002
min	963.902
max	963.968-963.964=0.004

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.825-0.829=-0.004
σ	0.067-0.036=0.031
min	0.714-0.779=-0.065
max	0.869-0.865=0.005

name=cdr_enhanced_4k_loc.art

*mean*	884.890-884.889=0.001
σ	0.007-0.007=0.000
min	884.883
max	884.898-884.897=0.001

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.757-0.683=0.074
σ	0.004-0.046=-0.042
min	0.752-0.646=0.106
max	0.762-0.746=0.016

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.712-7.711=0.002

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	4.262-4.255=0.007
σ	0.081-0.085=-0.004
min	4.117-4.110=0.007
max	4.634-4.585=0.048

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.658-7.659=-0.001

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	4.243-4.278=-0.035
σ	0.076-0.078=-0.002
min	4.118-4.140=-0.022
max	4.508-4.543=-0.035

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.751-0.773=-0.022
σ	0.055-0.029=0.026
min	0.548-0.615=-0.067
max	0.867-0.897=-0.030

name=record_render_syntax_err.art

*mean*	2.163-2.163=0.000
σ	0.002-0.002=-0.000
min	2.163
max	2.166

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.732-0.732=0.000
σ	0.016-0.015=0.001
min	0.699-0.693=0.006
max	0.827-0.817=0.010

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.422-297.211=0.211
σ	0.214-0.228=-0.014
min	297.261-297.061=0.200
max	298.006-297.845=0.161

*mean*	1913.000-1981.000=-68.000
σ	0.000
min	1913.000-1981.000=-68.000
max	1913.000-1981.000=-68.000

*mean*	0.585-0.558=0.027
σ	0.049-0.029=0.020
min	0.509-0.516=-0.007
max	0.693-0.592=0.101

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.766-289.772=-0.006
σ	0.038-0.036=0.002
min	289.716-289.725=-0.008
max	289.804-289.810=-0.006

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.390-0.402=-0.012
σ	0.004-0.015=-0.010
min	0.386-0.395=-0.009
max	0.397-0.428=-0.031

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.677-1299.620=0.057
σ	0.055-0.103=-0.048
min	1299.610-1299.495=0.115
max	1299.733-1299.725=0.009

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	2.130-1.938=0.193
σ	0.153-0.049=0.104
min	2.015-1.863=0.152
max	2.392-1.987=0.405

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.597-1542.604=-0.007
σ	4.009-4.039=-0.030
min	1540.595-1540.598=-0.003
max	1549.759-1549.820=-0.061

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	2.216-2.215=0.001
σ	0.102-0.150=-0.048
min	2.087-2.061=0.026
max	2.327-2.397=-0.070

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.626-1861.634=-0.008
σ	0.077-0.055=0.022
min	1861.507-1861.576=-0.068
max	1861.705-1861.707=-0.002

*mean*	1745.000-1767.600=-22.600
σ	181.731-225.188=-43.458
min	1487.000-1471.000=16.000
max	1913.000-1981.000=-68.000

*mean*	3.130-3.094=0.036
σ	0.299-0.245=0.054
min	2.858-2.871=-0.013
max	3.600-3.502=0.098

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.811-1.731=0.080
σ	0.086-0.151=-0.064
min	1.667-1.589=0.078
max	1.883-1.957=-0.074

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.208-446.206=0.002
σ	577.184-577.183=0.001
min	157.615-157.613=0.002
max	1311.984-1311.981=0.003

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	0.550-0.542=0.008
σ	0.571-0.549=0.022
min	0.261-0.267=-0.006
max	1.407-1.366=0.041

policies=20

*mean*	1576.413-1576.382=0.031
σ	0.325-0.302=0.023
min	1576.189-1576.171=0.017
max	1576.896-1576.829=0.067

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	2.586-2.548=0.038
σ	0.010-0.146=-0.137
min	2.578-2.330=0.248
max	2.595-2.642=-0.046

policies=200

*mean*	15772.318-15772.301=0.017
σ	0.108-0.100=0.008
min	15772.240-15772.185=0.055
max	15772.475-15772.422=0.053

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1464.000-1471.000=-7.000
σ	0.000
min	1464.000-1471.000=-7.000
max	1464.000-1471.000=-7.000

*mean*	26.318-26.357=-0.039
σ	0.024-0.036=-0.013
min	26.295-26.314=-0.019
max	26.351-26.398=-0.047