Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.619-54.617=0.002
σ	0.349-0.350=-0.000
min	54.481-54.474=0.006
max	55.613-55.611=0.001

*mean*	418.000-414.700=3.300
σ	0.000-0.483=-0.483
min	418.000-414.000=4.000
max	418.000-415.000=3.000

*mean*	0.140-0.138=0.001
σ	0.004-0.005=-0.001
min	0.136-0.130=0.007
max	0.150-0.146=0.004

cache=y

dps=1

iters=10

policies=100

*mean*	43.788-43.785=0.003
σ	0.006-0.006=-0.000
min	43.779-43.774=0.004
max	43.800-43.793=0.007

*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.122-0.124=-0.002
σ	0.004-0.004=0.000
min	0.118-0.120=-0.002
max	0.130-0.131=-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
max	36.620-36.620=-0.000

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	12.819-12.220=0.599
σ	0.302-0.274=0.028
min	12.400-11.733=0.667
max	13.208-12.684=0.524

op=column_set() on indexed, repeat

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

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	12.709-12.230=0.479
σ	0.779-0.499=0.280
min	11.621-11.464=0.158
max	13.511-12.848=0.663

op=table_records(), no indexes

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

*mean*	7289.000-6041.000=1248.000
σ	0.000
min	7289.000-6041.000=1248.000
max	7289.000-6041.000=1248.000

*mean*	15.479-13.024=2.455
σ	0.337-1.095=-0.758
min	15.023-11.143=3.880
max	16.069-14.544=1.524

op=table_records(), repeat

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

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	12.939-12.300=0.639
σ	1.612-1.764=-0.152
min	10.830-10.348=0.482
max	15.163-14.985=0.179

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

*mean*	27.653-27.605=0.048
σ	0.137-0.002=0.135
min	27.603
max	27.991-27.607=0.384

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	9.009-8.341=0.668
σ	0.325-0.408=-0.082
min	8.566-7.896=0.670
max	9.407-8.799=0.608

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

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	6.763-6.389=0.375
σ	0.312-0.214=0.098
min	6.310-6.073=0.237
max	7.202-6.632=0.570

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	6.046-5.485=0.561
σ	0.113-0.082=0.031
min	5.847-5.407=0.439
max	6.172-5.617=0.555

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.972-25.971=0.001

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	5.893-5.303=0.590
σ	0.139-0.088=0.051
min	5.713-5.156=0.557
max	6.144-5.431=0.712

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.606-2524.593=0.013
σ	0.000-0.000=0.000
min	2524.606-2524.593=0.013
max	2524.607-2524.594=0.013

*mean*	7289.000-6041.000=1248.000
σ	0.000
min	7289.000-6041.000=1248.000
max	7289.000-6041.000=1248.000

*mean*	1484.536-1536.313=-51.778
σ	849.540-787.997=61.543
min	1046.268-1032.390=13.878
max	3497.164-2933.180=563.984

op=load_product(), with indexes

*mean*	8744.722-8744.558=0.164
σ	0.469-0.033=0.436
min	8744.554-8744.544=0.010
max	8745.883-8744.640=1.243

*mean*	3571.000-3819.625=-248.625
σ	1794.127-1647.380=146.746
min	1045.000-1980.000=-935.000
max	5789.000-6041.000=-252.000

*mean*	4775.700-4561.645=214.055
σ	1647.579-1488.192=159.387
min	3516.446-3537.848=-21.402
max	7250.131-7543.589=-293.458

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

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

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	83.934-81.547=2.387
σ	12.502-10.940=1.562
min	70.119-70.126=-0.008
max	100.703-96.506=4.198

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	7289.000-6041.000=1248.000
σ	0.000
min	7289.000-6041.000=1248.000
max	7289.000-6041.000=1248.000

*mean*	108.725-96.726=11.999
σ	3.862-9.106=-5.245
min	102.036-82.588=19.448
max	113.049-107.232=5.817

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-66.685=-0.000
max	66.687-66.687=-0.000

*mean*	7289.000-6041.000=1248.000
σ	0.000
min	7289.000-6041.000=1248.000
max	7289.000-6041.000=1248.000

*mean*	165.197-220.991=-55.794
σ	5.051-216.062=-211.012
min	154.390-126.166=28.224
max	169.778-754.772=-584.994

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.836-11656.832=0.004
σ	4.324-4.317=0.007
min	11655.305
max	11667.537-11667.517=0.021

*mean*	4149.500-4099.500=50.000
σ	1896.603-1568.832=327.771
min	1554.000-1980.000=-426.000
max	7289.000-6041.000=1248.000

*mean*	6517.118-6393.343=123.776
σ	1298.224-1301.605=-3.381
min	4881.933-4908.939=-27.006
max	7900.699-8370.281=-469.582

op=vertical_lookup_list() on indexed

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

*mean*	7289.000-6041.000=1248.000
σ	0.000
min	7289.000-6041.000=1248.000
max	7289.000-6041.000=1248.000

*mean*	5665.633-6610.741=-945.108
σ	1299.568-1285.596=13.972
min	4382.721-4429.995=-47.273
max	7713.398-8020.944=-307.546

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.559-172.582=-0.023
σ	0.001-0.027=-0.025
min	172.558
max	172.562-172.626=-0.064

*mean*	477.000-1980.000=-1503.000
σ	0.000
min	477.000-1980.000=-1503.000
max	477.000-1980.000=-1503.000

*mean*	373.567-343.833=29.734
σ	32.399-30.640=1.759
min	302.626-297.992=4.634
max	393.726-394.499=-0.773

op=pointedIndexFromKvs

rows=400000

*mean*	357.322-357.365=-0.043
σ	0.001-0.042=-0.041
min	357.321
max	357.325-357.420=-0.095

*mean*	561.000-1980.000=-1419.000
σ	0.000
min	561.000-1980.000=-1419.000
max	561.000-1980.000=-1419.000

*mean*	777.405-759.616=17.789
σ	18.580-53.930=-35.349
min	751.328-629.715=121.613
max	808.054-801.518=6.536

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.376-1008.185=0.191
σ	0.760-0.905=-0.146
min	1007.900-1007.715=0.185
max	1011.517-1011.953=-0.435

*mean*	1047.200-1040.800=6.400
σ	300.607-306.732=-6.126
min	563.000-555.000=8.000
max	1451.000-1472.000=-21.000

*mean*	1.549-1.577=-0.028
σ	0.077-0.151=-0.074
min	1.411-1.456=-0.045
max	1.757-2.026=-0.269

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.891-0.883=0.008
σ	0.020-0.002=0.018
min	0.881
max	0.928-0.886=0.042

*mean*	402.000-1472.000=-1070.000
σ	0.000
min	402.000-1472.000=-1070.000
max	402.000-1472.000=-1070.000

*mean*	0.392-0.416=-0.024
σ	0.514-0.134=0.380
min	0.137-0.334=-0.197
max	1.308-0.654=0.654

name=error_case.art

*mean*	2.338-2.333=0.004
σ	0.012-0.003=0.010
min	2.332
max	2.359-2.337=0.022

*mean*	402.000-1472.000=-1070.000
σ	0.000
min	402.000-1472.000=-1070.000
max	402.000-1472.000=-1070.000

*mean*	0.660-0.894=-0.234
σ	0.254-0.086=0.167
min	0.344-0.833=-0.489
max	1.048-1.044=0.004

name=heavy_item.art

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

*mean*	402.000-1472.000=-1070.000
σ	0.000
min	402.000-1472.000=-1070.000
max	402.000-1472.000=-1070.000

*mean*	0.375-0.561=-0.186
σ	0.037-0.036=0.001
min	0.349-0.537=-0.188
max	0.438-0.622=-0.183

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	402.000-1472.000=-1070.000
σ	0.000
min	402.000-1472.000=-1070.000
max	402.000-1472.000=-1070.000

*mean*	0.588-0.842=-0.255
σ	0.020-0.049=-0.029
min	0.574-0.803=-0.229
max	0.621-0.923=-0.302

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.908-963.541=0.367
σ	0.011-0.032=-0.021
min	963.902-963.523=0.379
max	963.926-963.597=0.330

*mean*	434.400-1472.000=-1037.600
σ	1.342-0.000=1.342
min	432.000-1472.000=-1040.000
max	435.000-1472.000=-1037.000

*mean*	0.697-0.804=-0.107
σ	0.065-0.046=0.019
min	0.592-0.741=-0.149
max	0.746-0.864=-0.119

name=cdr_enhanced_4k_loc.art

*mean*	884.884-884.854=0.030
σ	0.002-0.005=-0.004
min	884.883-884.847=0.036
max	884.886-884.861=0.025

*mean*	435.000-1472.000=-1037.000
σ	0.000
min	435.000-1472.000=-1037.000
max	435.000-1472.000=-1037.000

*mean*	0.512-0.731=-0.219
σ	0.019-0.029=-0.010
min	0.483-0.679=-0.196
max	0.529-0.748=-0.219

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.713=-0.004

*mean*	435.000-1472.000=-1037.000
σ	0.000
min	435.000-1472.000=-1037.000
max	435.000-1472.000=-1037.000

*mean*	2.695-3.626=-0.932
σ	0.082-0.083=-0.001
min	2.527-3.443=-0.916
max	2.968-3.961=-0.992

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	435.000-1472.000=-1037.000
σ	0.000
min	435.000-1472.000=-1037.000
max	435.000-1472.000=-1037.000

*mean*	2.589-3.547=-0.958
σ	0.092-0.071=0.021
min	2.430-3.405=-0.976
max	2.913-3.852=-0.940

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	435.000-1472.000=-1037.000
σ	0.000
min	435.000-1472.000=-1037.000
max	435.000-1472.000=-1037.000

*mean*	0.306-0.756=-0.449
σ	0.009-0.019=-0.010
min	0.292-0.721=-0.429
max	0.371-0.858=-0.486

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	435.000-1472.000=-1037.000
σ	0.000
min	435.000-1472.000=-1037.000
max	435.000-1472.000=-1037.000

*mean*	0.295-0.715=-0.420
σ	0.038-0.013=0.024
min	0.280-0.689=-0.409
max	0.661-0.760=-0.098

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.808-297.440=0.368
σ	1.010-0.233=0.778
min	297.431-297.278=0.154
max	300.682-298.086=2.596

*mean*	445.400-1980.000=-1534.600
σ	20.614-0.000=20.614
min	415.000-1980.000=-1565.000
max	473.000-1980.000=-1507.000

*mean*	0.618-0.568=0.050
σ	0.013-0.043=-0.029
min	0.601-0.513=0.088
max	0.637-0.622=0.015

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	222.011
σ	0.000
min	222.011
max	222.011

*mean*	1762.250
σ	23.608
min	1724.000
max	1775.000

*mean*	210.588
σ	2.895
min	207.051
max	216.688

phase=macro expansion

*mean*	6.133
σ	0.000
min	6.133
max	6.133

*mean*	1762.250
σ	23.608
min	1724.000
max	1775.000

*mean*	11.184
σ	1.527
min	9.370
max	12.684

phase=parser

*mean*	1041.161
σ	0.000
min	1041.160
max	1041.161

*mean*	1762.250
σ	23.608
min	1724.000
max	1775.000

*mean*	662.712
σ	71.466
min	565.680
max	728.769

phase=processProdDef

*mean*	6169.658
σ	0.000
min	6169.657
max	6169.658

*mean*	1768.625
σ	18.031
min	1724.000
max	1775.000

*mean*	5488.282
σ	1211.329
min	3648.001
max	6769.545

phase=renaming

*mean*	21.667
σ	0.000
min	21.667
max	21.667

*mean*	1762.250
σ	23.608
min	1724.000
max	1775.000

*mean*	51.977
σ	19.490
min	34.867
max	98.564

phase=type checker

*mean*	958.670
σ	0.066
min	958.573
max	958.760

*mean*	1762.250
σ	23.608
min	1724.000
max	1775.000

*mean*	775.127
σ	73.215
min	673.271
max	884.566

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	292.774-289.765=3.009
σ	0.035-0.045=-0.010
min	292.725-289.720=3.005
max	292.810-289.815=2.996

*mean*	445.000-1472.000=-1027.000
σ	0.000
min	445.000-1472.000=-1027.000
max	445.000-1472.000=-1027.000

*mean*	0.402-0.408=-0.006
σ	0.008-0.012=-0.004
min	0.395-0.393=0.002
max	0.411-0.419=-0.009

iters=5

new-facts=1

prior-facts=6402

*mean*	1302.865-1299.690=3.175
σ	0.080-0.092=-0.012
min	1302.730-1299.586=3.144
max	1302.928-1299.823=3.105

*mean*	1087.800-1472.000=-384.200
σ	168.584-0.000=168.584
min	893.000-1472.000=-579.000
max	1321.000-1472.000=-151.000

*mean*	2.085-2.268=-0.183
σ	0.266-0.081=0.185
min	1.815-2.167=-0.352
max	2.442-2.331=0.111

iters=5

new-facts=6402

prior-facts=1

*mean*	1545.930-1542.658=3.272
σ	4.024-4.013=0.011
min	1543.976-1540.697=3.279
max	1553.122-1549.832=3.291

*mean*	632.600-1472.000=-839.400
σ	90.007-0.000=90.007
min	493.000-1472.000=-979.000
max	726.000-1472.000=-746.000

*mean*	2.351-2.284=0.067
σ	0.240-0.125=0.115
min	2.103-2.145=-0.041
max	2.679-2.469=0.210

iters=5

new-facts=6402

prior-facts=6402

*mean*	1864.840-1861.630=3.210
σ	0.042-0.059=-0.016
min	1864.773-1861.554=3.219
max	1864.883-1861.698=3.184

*mean*	1729.800-1766.400=-36.600
σ	175.796-224.654=-48.858
min	1485.000-1472.000=13.000
max	1894.000-1980.000=-86.000

*mean*	3.095-3.246=-0.150
σ	0.327-0.363=-0.035
min	2.888-2.855=0.033
max	3.677-3.692=-0.015

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.664-1.840=-0.176
σ	0.108-0.025=0.083
min	1.510-1.811=-0.302
max	1.797-1.870=-0.073

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	447.755-446.185=1.569
σ	579.111-577.140=1.971
min	158.195-157.614=0.581
max	1316.421-1311.895=4.525

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	443.000-1472.000=-1029.000
σ	0.000
min	443.000-1472.000=-1029.000
max	443.000-1472.000=-1029.000

*mean*	0.505-0.539=-0.034
σ	0.487-0.543=-0.055
min	0.261-0.266=-0.005
max	1.237-1.353=-0.116

policies=20

*mean*	1582.280-1576.406=5.874
σ	0.343-0.334=0.009
min	1582.037-1576.183=5.854
max	1582.786-1576.903=5.883

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	448.000-1472.000=-1024.000
σ	5.774-0.000=5.774
min	443.000-1472.000=-1029.000
max	453.000-1472.000=-1019.000

*mean*	2.615-2.620=-0.005
σ	0.024-0.016=0.008
min	2.591-2.599=-0.008
max	2.647-2.635=0.012

policies=200

*mean*	15830.848-15772.240=58.609
σ	0.031-0.170=-0.139
min	15830.805-15772.074=58.731
max	15830.876-15772.476=58.401

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	496.500-1472.000=-975.500
σ	4.509-0.000=4.509
min	491.000-1472.000=-981.000
max	502.000-1472.000=-970.000

*mean*	26.546-26.425=0.121
σ	0.159-0.127=0.032
min	26.380-26.274=0.106
max	26.684-26.585=0.099