Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.618=-0.001
σ	0.352-0.350=0.002
min	54.479-54.487=-0.008
max	55.619-55.613=0.006

*mean*	417.000-422.000=-5.000
σ	0.000
min	417.000-422.000=-5.000
max	417.000-422.000=-5.000

*mean*	0.139-0.141=-0.002
σ	0.004-0.009=-0.006
min	0.135-0.131=0.004
max	0.146-0.159=-0.013

cache=y

dps=1

iters=10

policies=100

*mean*	43.787-43.787=0.000
σ	0.007-0.009=-0.002
min	43.776-43.775=0.001
max	43.799-43.804=-0.006

*mean*	417.000-422.000=-5.000
σ	0.000
min	417.000-422.000=-5.000
max	417.000-422.000=-5.000

*mean*	0.123-0.125=-0.002
σ	0.004-0.007=-0.003
min	0.119-0.120=-0.001
max	0.129-0.144=-0.015

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*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	12.354-12.885=-0.532
σ	0.345-1.673=-1.329
min	11.914-11.944=-0.029
max	12.998-16.973=-3.975

op=column_set() on indexed, repeat

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

*mean*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	12.454-13.343=-0.888
σ	0.628-1.625=-0.997
min	11.406-12.531=-1.126
max	13.178-17.344=-4.166

op=table_records(), no indexes

*mean*	41.928-41.928=-0.000
σ	0.000-0.001=-0.000
min	41.928
max	41.929-41.929=-0.000

*mean*	6045.000-7542.000=-1497.000
σ	0.000
min	6045.000-7542.000=-1497.000
max	6045.000-7542.000=-1497.000

*mean*	13.193-13.618=-0.425
σ	1.179-0.992=0.187
min	11.120-12.491=-1.370
max	14.992-14.683=0.309

op=table_records(), repeat

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

*mean*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	12.232-12.401=-0.168
σ	1.361-2.205=-0.844
min	10.337-10.289=0.048
max	13.702-15.161=-1.459

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

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

*mean*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	8.742-8.817=-0.075
σ	0.756-1.298=-0.542
min	7.901-7.873=0.029
max	10.344-11.922=-1.579

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

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	6.803-6.684=0.119
σ	0.721-1.119=-0.398
min	6.134-6.004=0.130
max	8.485-9.403=-0.918

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.666-25.666=-0.000
σ	0.002-0.002=-0.000
min	25.665-25.665=-0.000
max	25.670-25.669=0.000

*mean*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	5.585-5.639=-0.054
σ	0.092-0.536=-0.445
min	5.400-5.233=0.166
max	5.684-6.942=-1.258

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*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	5.459-5.409=0.050
σ	0.078-0.534=-0.456
min	5.361-5.066=0.295
max	5.602-6.704=-1.102

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

*mean*	6045.000-7542.000=-1497.000
σ	0.000
min	6045.000-7542.000=-1497.000
max	6045.000-7542.000=-1497.000

*mean*	1573.291-1106.450=466.841
σ	856.826-159.785=697.042
min	1040.538-1043.068=-2.530
max	3128.706-1501.606=1627.100

op=load_product(), with indexes

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

*mean*	3823.125-3794.750=28.375
σ	1648.610-1606.742=41.868
min	1981.000-1990.000=-9.000
max	6045.000-5949.000=96.000

*mean*	4398.607-4649.167=-250.560
σ	1431.584-1504.717=-73.132
min	3576.226-3557.034=19.192
max	7456.514-7361.410=95.104

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

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

*mean*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	81.898-88.702=-6.804
σ	11.468-13.429=-1.961
min	70.350-76.363=-6.013
max	97.867-117.417=-19.549

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	6045.000-7542.000=-1497.000
σ	0.000
min	6045.000-7542.000=-1497.000
max	6045.000-7542.000=-1497.000

*mean*	95.852-237.522=-141.670
σ	10.117-386.855=-376.738
min	80.976-85.718=-4.742
max	108.474-1194.766=-1086.293

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.686-66.689=-0.003

*mean*	6045.000-7542.000=-1497.000
σ	0.000
min	6045.000-7542.000=-1497.000
max	6045.000-7542.000=-1497.000

*mean*	223.994-148.441=75.553
σ	231.068-16.114=214.954
min	120.401-120.791=-0.390
max	794.657-165.812=628.846

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

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

*mean*	4104.000-4271.500=-167.500
σ	1569.709-1875.122=-305.413
min	1981.000-1990.000=-9.000
max	6045.000-7542.000=-1497.000

*mean*	6344.214-6553.247=-209.033
σ	1330.989-1297.635=33.354
min	4974.857-4985.947=-11.090
max	8397.614-8270.335=127.279

op=vertical_lookup_list() on indexed

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

*mean*	6045.000-7542.000=-1497.000
σ	0.000
min	6045.000-7542.000=-1497.000
max	6045.000-7542.000=-1497.000

*mean*	6446.862-5482.501=964.361
σ	1416.333-1343.777=72.556
min	4432.160-4411.811=20.350
max	8205.525-7267.779=937.746

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.583-172.582=0.000
σ	0.024-0.026=-0.002
min	172.558
max	172.620-172.624=-0.004

*mean*	1981.000-1990.000=-9.000
σ	0.000
min	1981.000-1990.000=-9.000
max	1981.000-1990.000=-9.000

*mean*	356.016-350.621=5.395
σ	39.927-35.790=4.137
min	265.921-274.307=-8.386
max	400.149-403.568=-3.419

op=pointedIndexFromKvs

rows=400000

*mean*	357.364-357.362=0.002
σ	0.043-0.043=-0.001
min	357.321
max	357.430-357.405=0.025

*mean*	1981.000-1990.000=-9.000
σ	0.000
min	1981.000-1990.000=-9.000
max	1981.000-1990.000=-9.000

*mean*	775.961-763.268=12.693
σ	31.149-64.684=-33.536
min	719.523-611.603=107.919
max	809.610-809.514=0.096

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.182-1008.182=-0.000
σ	0.938-0.927=0.011
min	1007.717-1007.716=0.001
max	1012.094-1012.041=0.053

*mean*	1044.600-1058.450=-13.850
σ	295.859-316.802=-20.943
min	548.000-581.000=-33.000
max	1448.000-1528.000=-80.000

*mean*	1.553-1.552=0.001
σ	0.137-0.111=0.027
min	1.456-1.452=0.004
max	2.051-1.905=0.146

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

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

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.436-0.439=-0.003
σ	0.174-0.132=0.042
min	0.347-0.340=0.007
max	0.747-0.656=0.091

name=error_case.art

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

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.933-0.901=0.032
σ	0.174-0.102=0.071
min	0.845-0.837=0.008
max	1.243-1.082=0.161

name=heavy_item.art

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

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.557-0.548=0.008
σ	0.053-0.041=0.012
min	0.507-0.515=-0.008
max	0.645-0.620=0.026

name=nested_use.art

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

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.858-0.840=0.019
σ	0.045-0.050=-0.005
min	0.817-0.799=0.017
max	0.929-0.919=0.010

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.548-963.550=-0.002
σ	0.031-0.035=-0.004
min	963.523
max	963.602-963.611=-0.009

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.836-0.828=0.007
σ	0.034-0.030=0.004
min	0.782-0.790=-0.007
max	0.861-0.859=0.002

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.853=0.001
σ	0.006-0.006=0.001
min	884.847
max	884.861

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.724-0.743=-0.019
σ	0.024-0.006=0.018
min	0.696-0.735=-0.039
max	0.744-0.750=-0.006

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*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	3.570-3.559=0.011
σ	0.104-0.086=0.017
min	3.409-3.410=-0.002
max	4.225-3.882=0.343

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	3.547-3.557=-0.010
σ	0.069-0.059=0.009
min	3.417-3.440=-0.023
max	3.717-3.795=-0.078

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.755-0.761=-0.007
σ	0.017-0.017=-0.000
min	0.720-0.728=-0.009
max	0.860-0.876=-0.016

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.714-0.717=-0.004
σ	0.015-0.019=-0.004
min	0.681-0.627=0.054
max	0.791-0.798=-0.007

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.230-297.427=-0.197
σ	0.203-0.253=-0.050
min	297.073-297.198=-0.125
max	297.772-298.107=-0.336

*mean*	1981.000-1990.000=-9.000
σ	0.000
min	1981.000-1990.000=-9.000
max	1981.000-1990.000=-9.000

*mean*	0.559-0.579=-0.021
σ	0.027-0.029=-0.002
min	0.522-0.526=-0.004
max	0.588-0.616=-0.029

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.774-289.773=0.001
σ	0.038-0.035=0.003
min	289.724-289.726=-0.002
max	289.813-289.810=0.003

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.400-0.396=0.004
σ	0.011-0.006=0.006
min	0.394-0.393=0.001
max	0.420-0.406=0.014

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.592-1299.662=-0.070
σ	0.078-0.070=0.008
min	1299.506-1299.584=-0.078
max	1299.707-1299.732=-0.026

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	1.955-2.097=-0.142
σ	0.093-0.072=0.021
min	1.852-2.007=-0.155
max	2.099-2.177=-0.078

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.647-1542.589=0.058
σ	4.008-4.031=-0.023
min	1540.671-1540.556=0.115
max	1549.811-1549.790=0.021

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	2.249-2.191=0.058
σ	0.178-0.158=0.019
min	2.026-1.974=0.052
max	2.476-2.375=0.100

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.647-1861.628=0.019
σ	0.067-0.078=-0.011
min	1861.578-1861.507=0.071
max	1861.726-1861.704=0.022

*mean*	1766.400-1785.600=-19.200
σ	226.297-210.469=15.828
min	1468.000-1528.000=-60.000
max	1981.000-1990.000=-9.000

*mean*	3.139-3.270=-0.131
σ	0.256-0.381=-0.125
min	2.841-2.861=-0.020
max	3.484-3.681=-0.198

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.636-1.595=0.041
σ	0.159-0.344=-0.185
min	1.414-1.017=0.396
max	1.853-1.861=-0.008

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.183-446.183=-0.000
σ	577.140-577.140=-0.001
min	157.611-157.610=0.001
max	1311.892-1311.894=-0.002

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	0.530-0.541=-0.011
σ	0.535-0.558=-0.022
min	0.261-0.261=0.000
max	1.333-1.378=-0.044

policies=20

*mean*	1576.395-1576.404=-0.009
σ	0.345-0.353=-0.008
min	1576.163-1576.171=-0.008
max	1576.908-1576.930=-0.022

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	2.622-2.629=-0.007
σ	0.011-0.035=-0.025
min	2.613-2.587=0.026
max	2.633-2.673=-0.040

policies=200

*mean*	15772.207-15772.305=-0.097
σ	0.117-0.137=-0.020
min	15772.112-15772.115=-0.003
max	15772.377-15772.442=-0.065

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1448.000-1528.000=-80.000
σ	0.000
min	1448.000-1528.000=-80.000
max	1448.000-1528.000=-80.000

*mean*	26.335-26.416=-0.081
σ	0.051-0.046=0.005
min	26.289-26.363=-0.073
max	26.405-26.474=-0.069