Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-53.706=0.911
σ	0.351-0.368=-0.017
min	54.484-53.565=0.920
max	55.615-54.752=0.863

*mean*	417.000-416.500=0.500
σ	0.000-0.527=-0.527
min	417.000-416.000=1.000
max	417.000

*mean*	0.143-0.140=0.002
σ	0.004-0.004=0.001
min	0.139-0.136=0.003
max	0.150-0.147=0.003

cache=y

dps=1

iters=10

policies=100

*mean*	43.786-43.059=0.726
σ	0.007-0.005=0.002
min	43.776-43.051=0.725
max	43.801-43.067=0.734

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.124-0.121=0.003
σ	0.004-0.004=0.000
min	0.120-0.114=0.006
max	0.131-0.127=0.004

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on indexed

rows=200000

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

*mean*	4285.875-4280.500=5.375
σ	1977.368-1970.683=6.685
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	56.637-12.834=43.802
σ	124.170-0.234=123.937
min	12.467-12.565=-0.098
max	363.942-13.177=350.765

iterations=8

operation_display=column_set() on indexed, repeat

rows=200000

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

*mean*	4285.875-4280.500=5.375
σ	1977.368-1970.683=6.685
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	12.512-12.921=-0.410
σ	0.559-2.263=-1.704
min	12.134-11.909=0.225
max	13.824-18.513=-4.689

iterations=8

operation_display=table_records(), no indexes

rows=200000

*mean*	41.930-41.930=0.001
σ	0.002-0.002=0.000
min	41.928-41.928=0.000
max	41.933-41.932=0.001

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	15.117-15.060=0.057
σ	0.874-0.657=0.218
min	13.437-13.951=-0.513
max	15.803-15.684=0.119

iterations=8

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.929-41.930=-0.000
σ	0.002-0.002=-0.000
min	41.928-41.928=-0.000
max	41.932-41.932=0.000

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	14.587-13.892=0.695
σ	0.921-0.795=0.126
min	13.108-12.675=0.433
max	15.758-15.047=0.711

iterations=8

operation_display=table_records(), repeat

rows=200000

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

*mean*	4168.625-4163.750=4.875
σ	1899.901-1892.567=7.334
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	13.877-13.797=0.079
σ	1.645-1.655=-0.010
min	11.081-11.272=-0.191
max	15.428-15.238=0.190

iterations=8

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

rows=200000

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

*mean*	4168.625-4163.750=4.875
σ	1899.901-1892.567=7.334
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	9.396-9.092=0.304
σ	0.371-0.485=-0.114
min	8.812-8.471=0.341
max	9.792-9.625=0.167

iterations=8

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

rows=200000

*mean*	26.401-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*	4168.625-4163.750=4.875
σ	1899.901-1892.567=7.334
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	7.003-6.976=0.027
σ	0.367-0.472=-0.105
min	6.558-6.146=0.413
max	7.610-7.410=0.199

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

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

*mean*	4285.875-4280.500=5.375
σ	1977.368-1970.683=6.685
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	6.085-6.205=-0.120
σ	0.142-0.583=-0.441
min	5.827-5.817=0.010
max	6.309-7.581=-1.272

iterations=8

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.661-25.661=0.000
σ	0.002-0.002=-0.000
min	25.659-25.659=-0.000
max	25.663-25.663=-0.000

*mean*	4285.875-4280.500=5.375
σ	1977.368-1970.683=6.685
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	5.652-6.016=-0.364
σ	0.211-0.677=-0.465
min	5.339-5.645=-0.306
max	6.014-7.622=-1.609

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.968-25.969=-0.001
σ	0.002-0.002=-0.001
min	25.967-25.967=-0.000
max	25.971-25.972=-0.001

*mean*	4285.875-4280.500=5.375
σ	1977.368-1970.683=6.685
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	5.278-5.926=-0.648
σ	0.222-0.428=-0.206
min	5.013-5.750=-0.737
max	5.648-6.984=-1.336

iterations=8

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	25.968-25.968=-0.000
σ	0.001-0.002=-0.000
min	25.967
max	25.971

*mean*	4285.875-4280.500=5.375
σ	1977.368-1970.683=6.685
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	5.169-5.896=-0.727
σ	0.234-0.640=-0.406
min	4.927-5.585=-0.658
max	5.602-7.469=-1.867

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.595-2524.596=-0.001
σ	0.002-0.002=-0.000
min	2524.594
max	2524.598

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	1482.641-1530.202=-47.561
σ	687.227-780.496=-93.269
min	1048.360-1040.022=8.338
max	2846.299-3149.532=-303.232

iterations=8

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.560-8744.560=-0.000
σ	0.041-0.040=0.000
min	8744.544-8744.545=-0.000
max	8744.661-8744.660=0.001

*mean*	3590.875-3591.125=-0.250
σ	1813.257-1815.743=-2.486
min	1073.000
max	5817.000-5820.000=-3.000

*mean*	4621.477-4775.338=-153.861
σ	1205.577-1640.545=-434.969
min	3560.565-3527.561=33.004
max	6253.265-7551.994=-1298.729

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=column_set() on unindexed, dense

rows=200000

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

*mean*	4168.625-4163.750=4.875
σ	1899.901-1892.567=7.334
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	81.471-77.224=4.248
σ	9.275-5.280=3.995
min	71.796-71.632=0.164
max	99.040-87.068=11.971

iterations=8

operation_display=column_set() on unindexed, dense, repeat

rows=200000

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

*mean*	4168.625-4163.750=4.875
σ	1899.901-1892.567=7.334
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	82.608-77.668=4.940
σ	9.578-5.635=3.942
min	72.754-71.685=1.069
max	101.619-88.172=13.447

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.945-40.945=-0.000
σ	0.002-0.002=0.000
min	40.943-40.944=-0.000
max	40.947

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	102.994-105.394=-2.399
σ	6.547-6.136=0.410
min	90.775-94.321=-3.546
max	107.069-109.603=-2.534

iterations=8

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.945-40.945=-0.001
σ	0.002-0.002=-0.000
min	40.943-40.944=-0.000
max	40.947-40.948=-0.000

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	103.272-105.333=-2.061
σ	6.649-6.165=0.484
min	91.292-94.222=-2.930
max	107.503-109.931=-2.428

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.951-40.951=-0.000
σ	0.002-0.002=0.000
min	40.949
max	40.954-40.953=0.002

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	104.696-108.433=-3.737
σ	5.931-4.175=1.756
min	94.293-101.333=-7.040
max	109.153-113.479=-4.327

iterations=8

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	40.950-40.950=-0.000
σ	0.002-0.002=-0.001
min	40.949
max	40.953-40.954=-0.002

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	103.433-105.625=-2.192
σ	6.711-6.097=0.614
min	91.034-94.437=-3.403
max	107.850-109.951=-2.101

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.687-66.686=0.001
σ	0.002-0.001=0.001
min	66.685
max	66.690-66.689=0.001

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	225.617-220.148=5.469
σ	186.164-166.162=20.003
min	141.991-146.292=-4.301
max	685.751-630.853=54.897

iterations=8

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.686-66.687=-0.000
σ	0.002-0.002=0.000
min	66.685
max	66.689-66.689=0.000

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	155.532-157.208=-1.676
σ	16.456-18.002=-1.546
min	122.447-117.817=4.630
max	167.952-171.147=-3.195

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=table_records()

rows=200000

*mean*	11656.834-11656.833=0.001
σ	4.318-4.318=-0.000
min	11655.305
max	11667.520-11667.519=0.001

*mean*	4168.625-4163.750=4.875
σ	1899.901-1892.567=7.334
min	1548.000-1553.000=-5.000
max	7213.000-7172.000=41.000

*mean*	6984.002-6326.387=657.615
σ	1115.760-1353.671=-237.911
min	4949.293-4887.964=61.330
max	8156.798-7912.661=244.137

iterations=8

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	11560.066-11560.065=0.000
σ	0.002-0.001=0.000
min	11560.064
max	11560.068

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	5551.112-6023.819=-472.708
σ	1195.174-1467.049=-271.875
min	4451.280-4420.342=30.938
max	7526.822-7880.291=-353.469

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=8

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.662-172.657=0.004
σ	0.018-0.014=0.004
min	172.637-172.645=-0.008
max	172.684-172.677=0.007

*mean*	487.500-488.000=-0.500
σ	0.926-0.000=0.926
min	487.000-488.000=-1.000
max	489.000-488.000=1.000

*mean*	383.744-363.314=20.430
σ	40.466-46.759=-6.293
min	315.300-305.387=9.913
max	425.758-420.969=4.789

iterations=8

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.461-357.471=-0.010
σ	0.150-0.156=-0.007
min	357.321
max	357.629-357.633=-0.004

*mean*	572.000-565.000=7.000
σ	0.000
min	572.000-565.000=7.000
max	572.000-565.000=7.000

*mean*	808.899-769.462=39.437
σ	33.118-61.391=-28.272
min	778.082-661.788=116.294
max	879.233-823.991=55.242

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.081-1005.002=3.079
σ	0.761-0.751=0.010
min	1007.610-1004.530=3.080
max	1011.227-1008.107=3.119

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	1.486-1.636=-0.149
σ	0.086-0.170=-0.084
min	1.403-1.469=-0.066
max	1.645-2.020=-0.375

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.884-0.883=0.001
σ	0.003-0.002=0.001
min	0.881
max	0.887-0.886=0.002

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.337-0.439=-0.102
σ	0.107-0.162=-0.055
min	0.266-0.350=-0.084
max	0.516-0.728=-0.212

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.786-0.942=-0.156
σ	0.088-0.144=-0.056
min	0.632-0.830=-0.198
max	0.843-1.186=-0.343

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.530-0.532=-0.003
σ	0.032-0.045=-0.013
min	0.507-0.499=0.008
max	0.584-0.611=-0.027

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.841-0.840=0.001
σ	0.038-0.027=0.011
min	0.810-0.806=0.004
max	0.905-0.882=0.023

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.550-963.552=-0.002
σ	0.023-0.022=0.000
min	963.527
max	963.584-963.580=0.005

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.802-0.810=-0.008
σ	0.063-0.044=0.019
min	0.696-0.744=-0.048
max	0.849-0.844=0.005

name=cdr_enhanced_4k_loc.art

*mean*	884.853-884.853=0.000
σ	0.009-0.006=0.003
min	884.847
max	884.867-884.863=0.004

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.705-0.623=0.082
σ	0.030-0.050=-0.020
min	0.677-0.536=0.142
max	0.739-0.659=0.081

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*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	4.273-3.536=0.737
σ	0.083-0.084=-0.001
min	4.117-3.409=0.708
max	4.526-3.828=0.698

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.660-7.659=0.000

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	4.234-3.564=0.670
σ	0.086-0.075=0.011
min	4.097-3.419=0.679
max	4.518-3.851=0.667

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.749-0.538=0.211
σ	0.034-0.014=0.020
min	0.565-0.513=0.053
max	0.932-0.617=0.314

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.710-0.522=0.189
σ	0.018-0.036=-0.017
min	0.651-0.496=0.155
max	0.790-0.759=0.031

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.432-294.381=3.052
σ	0.220-0.225=-0.006
min	297.257-294.160=3.097
max	298.038-294.970=3.068

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.597-0.550=0.048
σ	0.064-0.034=0.030
min	0.515-0.505=0.010
max	0.734-0.593=0.141

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.736-281.459=8.277
σ	0.035-0.035=-0.000
min	289.680-281.405=8.276
max	289.779-281.491=8.287

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.389-0.386=0.004
σ	0.001-0.009=-0.008
min	0.388-0.380=0.008
max	0.392-0.402=-0.010

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.641-1291.483=8.159
σ	0.093-0.087=0.006
min	1299.525-1291.369=8.155
max	1299.750-1291.580=8.169

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	1.888-1.973=-0.085
σ	0.085-0.051=0.034
min	1.821-1.888=-0.067
max	2.026-2.013=0.013

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.616-1534.332=8.284
σ	4.054-4.047=0.007
min	1540.575-1532.308=8.268
max	1549.861-1541.565=8.296

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	2.227-2.234=-0.007
σ	0.215-0.238=-0.023
min	2.043-2.028=0.014
max	2.589-2.627=-0.038

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.599-1853.334=8.265
σ	0.050-0.091=-0.041
min	1861.532-1853.199=8.333
max	1861.651-1853.435=8.216

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	3.041-3.115=-0.074
σ	0.173-0.376=-0.203
min	2.876-2.639=0.237
max	3.335-3.574=-0.239

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.530-1.564=-0.034
σ	0.168-0.216=-0.048
min	1.299-1.290=0.009
max	1.711-1.772=-0.062

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.150-442.428=3.722
σ	577.064-577.064=0.000
min	157.616-153.893=3.723
max	1311.746-1308.024=3.722

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	0.568-0.534=0.034
σ	0.598-0.538=0.060
min	0.268-0.264=0.004
max	1.464-1.340=0.124

policies=20

*mean*	1576.418-1539.221=37.197
σ	0.350-0.335=0.016
min	1576.192-1538.989=37.203
max	1576.941-1539.717=37.224

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	2.652-2.605=0.047
σ	0.040-0.013=0.027
min	2.627-2.587=0.040
max	2.712-2.616=0.096

policies=200

*mean*	15772.186-15400.352=371.834
σ	0.170-0.066=0.104
min	15772.048-15400.290=371.758
max	15772.406-15400.430=371.976

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	7213.000-7172.000=41.000
σ	0.000
min	7213.000-7172.000=41.000
max	7213.000-7172.000=41.000

*mean*	26.588-26.152=0.436
σ	0.103-0.143=-0.041
min	26.480-26.014=0.466
max	26.727-26.353=0.374