Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.615-54.620=-0.005
σ	0.350-0.350=-0.000
min	54.481-54.480=0.001
max	55.610-55.615=-0.005

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.137-0.146=-0.009
σ	0.005-0.010=-0.005
min	0.132-0.135=-0.004
max	0.148-0.160=-0.012

cache=y

dps=1

iters=10

policies=100

*mean*	43.786-43.785=0.000
σ	0.006-0.007=-0.001
min	43.780-43.778=0.001
max	43.797-43.802=-0.005

*mean*	417.000
σ	0.000
min	417.000
max	417.000

*mean*	0.122-0.120=0.002
σ	0.004-0.005=-0.000
min	0.117-0.114=0.002
max	0.130-0.127=0.003

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

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	12.270-12.459=-0.189
σ	0.226-0.160=0.065
min	11.923-12.252=-0.329
max	12.595-12.744=-0.149

op=column_set() on indexed, repeat

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

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	12.533-12.637=-0.104
σ	0.471-0.532=-0.061
min	11.406-11.810=-0.405
max	12.941-13.357=-0.416

op=table_records(), no indexes

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

*mean*	6046.000-6043.000=3.000
σ	0.000
min	6046.000-6043.000=3.000
max	6046.000-6043.000=3.000

*mean*	13.115-13.476=-0.361
σ	1.208-0.872=0.335
min	10.616-12.560=-1.944
max	14.610-15.025=-0.414

op=table_records(), repeat

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

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	12.300-12.475=-0.175
σ	1.919-1.905=0.014
min	10.391-10.316=0.075
max	14.801-14.922=-0.122

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

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

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	8.326-8.424=-0.098
σ	0.327-0.235=0.092
min	7.724-8.156=-0.432
max	8.729-8.760=-0.031

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

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

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	6.079-5.916=0.163
σ	0.467-0.400=0.067
min	5.426-5.384=0.041
max	6.536-6.495=0.041

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	5.368-5.473=-0.105
σ	0.162-0.114=0.048
min	5.112-5.381=-0.269
max	5.558-5.726=-0.168

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
max	25.971

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	5.119-5.182=-0.062
σ	0.110-0.158=-0.048
min	4.923-4.989=-0.066
max	5.231-5.457=-0.226

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

*mean*	6046.000-6043.000=3.000
σ	0.000
min	6046.000-6043.000=3.000
max	6046.000-6043.000=3.000

*mean*	1535.830-1432.124=103.706
σ	748.826-721.325=27.500
min	1050.839-1063.747=-12.908
max	2727.261-3022.099=-294.838

op=load_product(), with indexes

*mean*	8744.558-8744.558=0.000
σ	0.032-0.033=-0.001
min	8744.545-8744.544=0.001
max	8744.639-8744.640=-0.001

*mean*	3826.375-3820.125=6.250
σ	1646.987-1650.643=-3.656
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	4496.916-4512.610=-15.694
σ	1414.454-1351.138=63.316
min	3542.575-3602.924=-60.349
max	7415.270-7439.109=-23.840

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078
σ	0.002
min	62.076
max	62.080

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	79.245-81.189=-1.944
σ	10.423-11.167=-0.744
min	68.744-70.746=-2.001
max	96.369-97.036=-0.667

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	6046.000-6043.000=3.000
σ	0.000
min	6046.000-6043.000=3.000
max	6046.000-6043.000=3.000

*mean*	93.059-95.714=-2.655
σ	13.105-10.132=2.973
min	66.778-79.167=-12.389
max	107.127-107.287=-0.160

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*	6046.000-6043.000=3.000
σ	0.000
min	6046.000-6043.000=3.000
max	6046.000-6043.000=3.000

*mean*	214.984-218.242=-3.258
σ	210.797-212.995=-2.198
min	103.626-119.451=-15.825
max	734.657-743.998=-9.341

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

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

*mean*	4106.375-4102.875=3.500
σ	1568.736-1570.666=-1.930
min	1986.000-1976.000=10.000
max	6046.000-6043.000=3.000

*mean*	6293.436-6394.992=-101.556
σ	1315.922-1159.738=156.184
min	4928.801-5003.318=-74.517
max	8339.174-7849.800=489.374

op=vertical_lookup_list() on indexed

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

*mean*	6046.000-6043.000=3.000
σ	0.000
min	6046.000-6043.000=3.000
max	6046.000-6043.000=3.000

*mean*	6553.718-6656.732=-103.013
σ	1403.644-1512.275=-108.631
min	4411.509-4530.508=-118.999
max	8032.456-8345.190=-312.734

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.582-172.582=0.000
σ	0.029-0.024=0.005
min	172.558
max	172.630-172.620=0.009

*mean*	1986.000-1976.000=10.000
σ	0.000
min	1986.000-1976.000=10.000
max	1986.000-1976.000=10.000

*mean*	360.135-364.184=-4.049
σ	41.677-20.309=21.368
min	267.206-341.920=-74.714
max	397.601-393.774=3.826

op=pointedIndexFromKvs

rows=400000

*mean*	357.362-357.362=-0.000
σ	0.042-0.039=0.003
min	357.321
max	357.409-357.402=0.007

*mean*	1986.000-1976.000=10.000
σ	0.000
min	1986.000-1976.000=10.000
max	1986.000-1976.000=10.000

*mean*	779.243-738.871=40.372
σ	19.488-69.372=-49.884
min	747.639-613.448=134.191
max	807.012-804.903=2.109

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.184-1008.191=-0.008
σ	0.883-0.855=0.028
min	1007.698-1007.681=0.016
max	1011.851-1011.706=0.144

*mean*	1051.500-1051.100=0.400
σ	301.604-296.557=5.047
min	548.000-569.000=-21.000
max	1454.000-1446.000=8.000

*mean*	1.544-1.520=0.023
σ	0.098-0.073=0.025
min	1.442-1.434=0.008
max	1.780-1.726=0.054

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*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.410-0.417=-0.007
σ	0.138-0.128=0.010
min	0.325-0.348=-0.023
max	0.653-0.644=0.010

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.884-0.875=0.009
σ	0.091-0.095=-0.004
min	0.828-0.816=0.012
max	1.045-1.041=0.003

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.544-0.542=0.002
σ	0.048-0.046=0.002
min	0.498-0.509=-0.011
max	0.623-0.624=-0.000

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.843-0.830=0.013
σ	0.046-0.036=0.010
min	0.798-0.804=-0.006
max	0.915-0.893=0.023

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.543-963.543=0.001
σ	0.025-0.024=0.001
min	963.523
max	963.585-963.581=0.004

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.802-0.841=-0.040
σ	0.054-0.041=0.014
min	0.723-0.782=-0.059
max	0.864-0.878=-0.013

name=cdr_enhanced_4k_loc.art

*mean*	884.853-884.854=-0.000
σ	0.005-0.005=0.000
min	884.847
max	884.859-884.861=-0.002

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.709-0.681=0.028
σ	0.056-0.047=0.009
min	0.618-0.617=0.001
max	0.750-0.722=0.027

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*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	4.243-4.316=-0.073
σ	0.113-0.114=-0.002
min	4.066-4.135=-0.069
max	4.580-4.631=-0.052

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

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	4.221-4.296=-0.075
σ	0.084-0.087=-0.003
min	4.071-4.155=-0.084
max	4.433-4.605=-0.172

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.741-0.738=0.003
σ	0.030-0.017=0.013
min	0.546-0.712=-0.165
max	0.854-0.850=0.004

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.709-0.703=0.006
σ	0.015-0.013=0.002
min	0.672-0.674=-0.003
max	0.756-0.772=-0.016

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.421-297.305=0.116
σ	0.210-0.245=-0.034
min	297.265-297.082=0.183
max	297.984-297.941=0.043

*mean*	1986.000-1976.000=10.000
σ	0.000
min	1986.000-1976.000=10.000
max	1986.000-1976.000=10.000

*mean*	0.538-0.556=-0.018
σ	0.032-0.037=-0.005
min	0.504-0.504=0.001
max	0.588-0.611=-0.022

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.776-289.778=-0.002
σ	0.034-0.036=-0.002
min	289.731-289.731=0.000
max	289.814-289.814=-0.000

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.401-0.398=0.003
σ	0.010-0.012=-0.002
min	0.395-0.392=0.002
max	0.419-0.419=-0.000

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.666-1299.605=0.060
σ	0.052-0.101=-0.048
min	1299.607-1299.501=0.106
max	1299.718-1299.761=-0.043

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	2.126-1.998=0.128
σ	0.108-0.120=-0.012
min	2.006-1.874=0.132
max	2.222-2.181=0.041

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.624-1542.654=-0.030
σ	4.031-3.996=0.035
min	1540.604-1540.691=-0.087
max	1549.825-1549.796=0.030

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	2.268-2.258=0.011
σ	0.154-0.135=0.018
min	2.093-2.113=-0.020
max	2.433-2.441=-0.008

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.622-1861.648=-0.026
σ	0.078-0.075=0.003
min	1861.505-1861.556=-0.051
max	1861.709-1861.738=-0.029

*mean*	1771.400-1764.400=7.000
σ	226.297-223.295=3.002
min	1473.000-1472.000=1.000
max	1986.000-1976.000=10.000

*mean*	3.223-3.178=0.045
σ	0.400-0.311=0.089
min	2.711-2.855=-0.144
max	3.704-3.529=0.175

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.745-1.723=0.022
σ	0.129-0.122=0.007
min	1.572-1.645=-0.073
max	1.889-1.938=-0.049

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.186-446.183=0.003
σ	577.140-577.140=-0.001
min	157.615-157.613=0.002
max	1311.895-1311.893=0.002

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	0.543-0.558=-0.015
σ	0.560-0.585=-0.025
min	0.261-0.261=0.000
max	1.383-1.435=-0.052

policies=20

*mean*	1576.424-1576.403=0.021
σ	0.356-0.346=0.010
min	1576.187-1576.170=0.016
max	1576.954-1576.918=0.036

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	2.640-2.621=0.019
σ	0.016-0.017=-0.000
min	2.625-2.605=0.020
max	2.661-2.644=0.017

policies=200

*mean*	15772.328-15772.253=0.075
σ	0.125-0.068=0.058
min	15772.223-15772.169=0.054
max	15772.501-15772.329=0.172

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1454.000-1446.000=8.000
σ	0.000
min	1454.000-1446.000=8.000
max	1454.000-1446.000=8.000

*mean*	26.477-26.449=0.027
σ	0.045-0.090=-0.045
min	26.420-26.360=0.060
max	26.529-26.569=-0.040