Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.619-54.619=-0.000
σ	0.350-0.349=0.000
min	54.486-54.487=-0.001
max	55.614-55.613=0.001

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.142-0.141=0.000
σ	0.005-0.004=0.001
min	0.136-0.137=-0.001
max	0.150-0.149=0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.789-43.788=0.001
σ	0.006-0.007=-0.000
min	43.783-43.780=0.003
max	43.803-43.802=0.001

*mean*	416.000
σ	0.000
min	416.000
max	416.000

*mean*	0.125-0.124=0.001
σ	0.004-0.004=0.000
min	0.121-0.119=0.002
max	0.133-0.132=0.001

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*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	12.820-12.760=0.060
σ	0.123-0.174=-0.051
min	12.652-12.484=0.168
max	13.034-13.060=-0.026

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.620=0.000

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	13.038-12.596=0.442
σ	0.578-0.616=-0.038
min	11.985-11.721=0.264
max	13.633-13.421=0.213

op=table_records(), no indexes

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

*mean*	7321.000-7327.000=-6.000
σ	0.000
min	7321.000-7327.000=-6.000
max	7321.000-7327.000=-6.000

*mean*	15.323-15.174=0.149
σ	0.711-0.762=-0.051
min	13.636-13.360=0.276
max	15.884-15.698=0.186

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.931-41.931=-0.000

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	13.261-12.752=0.508
σ	1.961-1.862=0.100
min	11.013-10.625=0.389
max	15.781-15.369=0.413

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

*mean*	27.653-27.653=-0.000
σ	0.136-0.136=0.000
min	27.603-27.603=0.000
max	27.990

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	8.983-8.964=0.018
σ	0.201-0.478=-0.277
min	8.661-8.356=0.305
max	9.206-9.729=-0.523

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

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

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	6.721-6.459=0.262
σ	0.469-0.319=0.149
min	6.004-5.964=0.040
max	7.277-6.901=0.376

op=vertical_lookup_row_list() on 2 indexed

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

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	6.081-5.988=0.093
σ	0.192-0.164=0.028
min	5.769-5.781=-0.012
max	6.288-6.250=0.038

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

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	5.706-5.606=0.101
σ	0.170-0.189=-0.018
min	5.451-5.390=0.061
max	5.893-5.804=0.089

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.606-2524.606=0.000
σ	0.000-0.000=-0.000
min	2524.606
max	2524.607-2524.607=-0.000

*mean*	7321.000-7327.000=-6.000
σ	0.000
min	7321.000-7327.000=-6.000
max	7321.000-7327.000=-6.000

*mean*	1077.624-1047.485=30.139
σ	86.672-7.636=79.036
min	1039.793-1037.555=2.238
max	1291.942-1060.683=231.259

op=load_product(), with indexes

*mean*	8744.722-8744.722=-0.000
σ	0.469-0.469=0.000
min	8744.553-8744.554=-0.000
max	8745.883-8745.883=-0.000

*mean*	3577.625-3579.500=-1.875
σ	1799.756-1803.098=-3.342
min	1045.000
max	5808.000-5818.000=-10.000

*mean*	4741.386-5026.786=-285.400
σ	1293.117-1756.665=-463.548
min	3564.133-3531.051=33.082
max	6498.277-7596.579=-1098.302

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-62.076=-0.000
max	62.081

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	83.909-79.314=4.594
σ	9.728-8.592=1.136
min	72.687-70.793=1.894
max	96.080-95.244=0.836

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	7321.000-7327.000=-6.000
σ	0.000
min	7321.000-7327.000=-6.000
max	7321.000-7327.000=-6.000

*mean*	106.295-105.835=0.459
σ	4.562-4.943=-0.381
min	98.255-97.447=0.808
max	111.563-111.482=0.081

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

*mean*	7321.000-7327.000=-6.000
σ	0.000
min	7321.000-7327.000=-6.000
max	7321.000-7327.000=-6.000

*mean*	163.344-161.165=2.179
σ	8.729-8.238=0.490
min	143.751-143.014=0.738
max	169.141-167.208=1.933

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.836-11656.836=0.001
σ	4.324-4.324=-0.001
min	11655.305
max	11667.537-11667.538=-0.001

*mean*	4156.250-4158.250=-2.000
σ	1904.856-1906.875=-2.019
min	1553.000-1555.000=-2.000
max	7321.000-7327.000=-6.000

*mean*	6367.211-6392.809=-25.598
σ	1232.077-1182.085=49.992
min	4992.724-4911.949=80.775
max	8045.722-8161.601=-115.879

op=vertical_lookup_list() on indexed

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

*mean*	7321.000-7327.000=-6.000
σ	0.000
min	7321.000-7327.000=-6.000
max	7321.000-7327.000=-6.000

*mean*	5501.964-5843.006=-341.042
σ	1369.760-1503.606=-133.847
min	4438.753-4414.882=23.871
max	7696.791-7994.700=-297.909

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.559
σ	0.001
min	172.558
max	172.562

*mean*	478.000
σ	0.000
min	478.000
max	478.000

*mean*	380.716-359.061=21.655
σ	17.872-28.914=-11.042
min	347.080-308.227=38.853
max	396.237-392.848=3.389

op=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.001
min	357.321
max	357.325

*mean*	562.000
σ	0.000
min	562.000
max	562.000

*mean*	731.373-777.486=-46.113
σ	59.274-18.232=41.043
min	636.710-746.006=-109.296
max	789.391-801.318=-11.927

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.373-1008.375=-0.002
σ	0.760-0.760=0.000
min	1007.900-1007.900=0.000
max	1011.518-1011.517=0.001

*mean*	1039.850-1043.300=-3.450
σ	307.320-310.724=-3.405
min	570.000-571.000=-1.000
max	1490.000-1501.000=-11.000

*mean*	1.522-1.533=-0.010
σ	0.074-0.069=0.005
min	1.385-1.468=-0.084
max	1.732-1.729=0.002

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.891
σ	0.020
min	0.881
max	0.928

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.410-0.305=0.105
σ	0.536-0.288=0.248
min	0.141-0.142=-0.001
max	1.366-0.818=0.548

name=error_case.art

*mean*	2.338
σ	0.012
min	2.332
max	2.359

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.486-0.478=0.008
σ	0.324-0.327=-0.003
min	0.333-0.324=0.009
max	1.066-1.063=0.003

name=heavy_item.art

*mean*	1.522
σ	0.002
min	1.520
max	1.524

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.221-0.219=0.002
σ	0.023-0.027=-0.004
min	0.202-0.195=0.007
max	0.259-0.264=-0.005

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	402.000
σ	0.000
min	402.000
max	402.000

*mean*	0.335-0.337=-0.002
σ	0.015-0.014=0.001
min	0.321-0.326=-0.005
max	0.359-0.357=0.002

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.908
σ	0.011
min	963.902
max	963.926

*mean*	434.800-434.400=0.400
σ	1.643-1.342=0.302
min	432.000
max	436.000-435.000=1.000

*mean*	0.544-0.560=-0.016
σ	0.054-0.032=0.022
min	0.465-0.531=-0.066
max	0.608-0.609=-0.001

name=cdr_enhanced_4k_loc.art

*mean*	884.884
σ	0.002
min	884.883
max	884.886

*mean*	436.000-435.000=1.000
σ	0.000
min	436.000-435.000=1.000
max	436.000-435.000=1.000

*mean*	0.472-0.465=0.007
σ	0.042-0.019=0.023
min	0.422-0.435=-0.014
max	0.532-0.485=0.047

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.706
σ	0.002
min	7.705
max	7.709

*mean*	436.000-435.000=1.000
σ	0.000
min	436.000-435.000=1.000
max	436.000-435.000=1.000

*mean*	1.944-2.587=-0.642
σ	0.062-0.071=-0.009
min	1.812-2.452=-0.640
max	2.148-2.811=-0.662

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	436.000-435.000=1.000
σ	0.000
min	436.000-435.000=1.000
max	436.000-435.000=1.000

*mean*	2.630-2.572=0.058
σ	0.133-0.067=0.066
min	1.968-2.462=-0.494
max	2.934-2.895=0.039

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	436.000-435.000=1.000
σ	0.000
min	436.000-435.000=1.000
max	436.000-435.000=1.000

*mean*	0.307-0.306=0.001
σ	0.009-0.008=0.001
min	0.292-0.291=0.001
max	0.361-0.363=-0.002

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	436.000-435.000=1.000
σ	0.000
min	436.000-435.000=1.000
max	436.000-435.000=1.000

*mean*	0.291-0.294=-0.003
σ	0.007-0.007=-0.000
min	0.277-0.281=-0.004
max	0.324-0.328=-0.004

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	298.068-298.008=0.059
σ	0.985-1.020=-0.035
min	297.604-297.640=-0.036
max	300.854-300.909=-0.055

*mean*	444.200-444.300=-0.100
σ	13.415-15.370=-1.955
min	428.000-418.000=10.000
max	466.000-465.000=1.000

*mean*	0.610-0.607=0.003
σ	0.016-0.021=-0.005
min	0.583-0.564=0.019
max	0.632-0.635=-0.003

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	222.008-222.008=-0.000
σ	0.000
min	222.008-222.008=-0.000
max	222.008-222.008=-0.000

*mean*	1723.125-1677.750=45.375
σ	61.872-21.920=39.952
min	1570.000-1670.000=-100.000
max	1745.000-1732.000=13.000

*mean*	202.755-204.450=-1.695
σ	2.289-1.216=1.073
min	199.534-202.846=-3.312
max	205.439-205.771=-0.332

phase=macro expansion

*mean*	6.130
σ	0.000
min	6.130
max	6.130

*mean*	1723.125-1677.750=45.375
σ	61.872-21.920=39.952
min	1570.000-1670.000=-100.000
max	1745.000-1732.000=13.000

*mean*	12.190-11.375=0.815
σ	2.032-2.335=-0.303
min	9.253-6.239=3.014
max	15.565-12.620=2.945

phase=parser

*mean*	1041.166-1041.162=0.003
σ	0.000-0.000=0.000
min	1041.165-1041.162=0.003
max	1041.166-1041.163=0.003

*mean*	1723.125-1677.750=45.375
σ	61.872-21.920=39.952
min	1570.000-1670.000=-100.000
max	1745.000-1732.000=13.000

*mean*	702.492-680.900=21.593
σ	84.285-123.634=-39.349
min	576.874-419.256=157.618
max	839.839-827.162=12.677

phase=processProdDef

*mean*	6169.657-6169.656=0.002
σ	0.000-0.001=-0.000
min	6169.657-6169.655=0.002
max	6169.658-6169.656=0.001

*mean*	1745.000-1685.500=59.500
σ	0.000-28.700=-28.700
min	1745.000-1670.000=75.000
max	1745.000-1732.000=13.000

*mean*	4699.491-5303.460=-603.969
σ	755.303-988.859=-233.556
min	3824.517-3266.101=558.416
max	5876.556-6672.384=-795.828

phase=renaming

*mean*	21.667
σ	0.000
min	21.667
max	21.667

*mean*	1723.125-1677.750=45.375
σ	61.872-21.920=39.952
min	1570.000-1670.000=-100.000
max	1745.000-1732.000=13.000

*mean*	46.750-43.554=3.196
σ	5.257-9.801=-4.545
min	39.190-20.222=18.967
max	56.019-48.516=7.503

phase=type checker

*mean*	958.540-958.537=0.004
σ	0.066
min	958.442-958.439=0.004
max	958.630-958.626=0.004

*mean*	1723.125-1677.750=45.375
σ	61.872-21.920=39.952
min	1570.000-1670.000=-100.000
max	1745.000-1732.000=13.000

*mean*	786.374-794.112=-7.738
σ	93.438-102.271=-8.833
min	656.680-630.226=26.454
max	901.745-887.514=14.231

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	292.773-292.775=-0.001
σ	0.035-0.034=0.001
min	292.723-292.727=-0.003
max	292.812-292.811=0.000

*mean*	445.000
σ	0.000
min	445.000
max	445.000

*mean*	0.403-0.404=-0.001
σ	0.006-0.007=-0.001
min	0.396-0.397=-0.002
max	0.412-0.416=-0.004

iters=5

new-facts=1

prior-facts=6402

*mean*	1302.905-1302.857=0.047
σ	0.045-0.073=-0.027
min	1302.843-1302.744=0.099
max	1302.956-1302.930=0.026

*mean*	1075.600-1089.600=-14.000
σ	187.142-171.960=15.182
min	840.000-891.000=-51.000
max	1324.000-1322.000=2.000

*mean*	2.072-2.054=0.018
σ	0.186-0.176=0.010
min	1.762-1.855=-0.093
max	2.219-2.215=0.005

iters=5

new-facts=6402

prior-facts=1

*mean*	1545.912-1545.927=-0.015
σ	4.037-4.046=-0.008
min	1543.942-1543.979=-0.037
max	1553.128-1553.159=-0.031

*mean*	610.400-632.600=-22.200
σ	74.484-89.687=-15.204
min	493.000-494.000=-1.000
max	689.000-726.000=-37.000

*mean*	2.296-2.351=-0.055
σ	0.207-0.272=-0.066
min	2.177-2.147=0.030
max	2.663-2.812=-0.149

iters=5

new-facts=6402

prior-facts=6402

*mean*	1864.835-1864.836=-0.001
σ	0.051-0.048=0.004
min	1864.764-1864.771=-0.008
max	1864.889-1864.883=0.006

*mean*	1711.800-1730.800=-19.000
σ	235.677-177.026=58.651
min	1431.000-1485.000=-54.000
max	2025.000-1897.000=128.000

*mean*	2.935-3.071=-0.136
σ	0.056-0.195=-0.139
min	2.890-2.927=-0.037
max	3.007-3.411=-0.403

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.612-1.766=-0.154
σ	0.220-0.178=0.042
min	1.336-1.512=-0.177
max	1.834-1.959=-0.125

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	447.737-447.738=-0.001
σ	579.077-579.076=0.000
min	158.196-158.199=-0.004
max	1316.352-1316.353=-0.000

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	444.000-447.000=-3.000
σ	0.000
min	444.000-447.000=-3.000
max	444.000-447.000=-3.000

*mean*	0.535-0.541=-0.006
σ	0.530-0.554=-0.025
min	0.267-0.263=0.004
max	1.330-1.373=-0.043

policies=20

*mean*	1582.291-1582.289=0.001
σ	0.360-0.354=0.006
min	1582.041-1582.043=-0.002
max	1582.824-1582.812=0.011

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	448.000-448.500=-0.500
σ	4.619-1.732=2.887
min	444.000-447.000=-3.000
max	452.000-450.000=2.000

*mean*	2.634-2.631=0.003
σ	0.021-0.013=0.008
min	2.607-2.612=-0.005
max	2.656-2.638=0.018

policies=200

*mean*	15830.912-15830.811=0.101
σ	0.103-0.201=-0.097
min	15830.805-15830.690=0.116
max	15831.041-15831.110=-0.069

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	498.000-497.000=1.000
σ	4.690-4.163=0.527
min	493.000-492.000=1.000
max	504.000-502.000=2.000

*mean*	26.690-26.691=-0.001
σ	0.105-0.184=-0.079
min	26.553-26.492=0.061
max	26.777-26.857=-0.080