Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.676-54.679=-0.003
σ	0.357-0.359=-0.003
min	54.543-54.540=0.003
max	55.690-55.701=-0.012

*mean*	422.000-416.000=6.000
σ	0.000
min	422.000-416.000=6.000
max	422.000-416.000=6.000

*mean*	0.140-0.141=-0.001
σ	0.005-0.004=0.001
min	0.134-0.138=-0.003
max	0.148-0.150=-0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.705-43.705=0.000
σ	0.004-0.006=-0.001
min	43.698-43.697=0.001
max	43.711-43.713=-0.002

*mean*	422.000-416.000=6.000
σ	0.000
min	422.000-416.000=6.000
max	422.000-416.000=6.000

*mean*	0.123-0.121=0.002
σ	0.004-0.004=0.000
min	0.121-0.116=0.004
max	0.132-0.130=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.616
max	36.620

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	12.587-12.765=-0.178
σ	0.321-0.203=0.118
min	12.070-12.468=-0.398
max	12.948-12.998=-0.050

op=column_set() on indexed, repeat

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

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	12.129-13.128=-0.999
σ	0.713-0.604=0.109
min	11.287-11.761=-0.474
max	13.099-13.678=-0.578

op=table_records(), no indexes

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

*mean*	7301.000-7323.000=-22.000
σ	0.000
min	7301.000-7323.000=-22.000
max	7301.000-7323.000=-22.000

*mean*	15.172-14.498=0.674
σ	0.566-0.873=-0.307
min	13.866-12.442=1.424
max	15.653-15.241=0.413

op=table_records(), repeat

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

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	13.221-12.167=1.055
σ	1.818-1.562=0.256
min	10.814-10.709=0.105
max	15.727-14.204=1.523

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

*mean*	27.654-27.654=-0.000
σ	0.136-0.136=0.000
min	27.604-27.604=-0.000
max	27.991

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	9.018-8.937=0.082
σ	0.290-0.372=-0.083
min	8.591-8.474=0.117
max	9.619-9.418=0.201

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.400-26.400=-0.000
max	26.404

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	6.638-7.042=-0.405
σ	0.331-0.119=0.212
min	6.207-6.863=-0.657
max	7.065-7.221=-0.156

op=vertical_lookup_row_list() on 2 indexed

*mean*	25.668-25.668=0.000
σ	0.003-0.003=0.000
min	25.666-25.666=-0.000
max	25.674-25.674=-0.000

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	5.920-6.045=-0.125
σ	0.102-0.084=0.019
min	5.735-5.913=-0.178
max	6.032-6.128=-0.096

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.970-25.970=-0.000
σ	0.002-0.002=0.000
min	25.968-25.968=-0.000
max	25.974-25.974=0.000

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	5.690-5.847=-0.157
σ	0.212-0.084=0.128
min	5.342-5.713=-0.371
max	6.012-5.993=0.018

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.606-2524.606=0.000

*mean*	7301.000-7323.000=-22.000
σ	0.000
min	7301.000-7323.000=-22.000
max	7301.000-7323.000=-22.000

*mean*	1390.923-1049.725=341.198
σ	633.305-10.660=622.645
min	1036.516-1036.114=0.401
max	2857.434-1070.103=1787.331

op=load_product(), with indexes

*mean*	8744.722-8744.721=0.000
σ	0.469-0.469=-0.000
min	8744.553-8744.553=-0.000
max	8745.882-8745.882=-0.000

*mean*	3572.250-3580.000=-7.750
σ	1797.062-1803.660=-6.598
min	1042.000-1044.000=-2.000
max	5795.000-5819.000=-24.000

*mean*	4782.640-4728.413=54.227
σ	1512.196-1561.377=-49.181
min	3535.941-3524.247=11.693
max	7382.257-7087.058=295.199

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

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	82.885-79.406=3.479
σ	12.684-9.036=3.648
min	67.887-69.706=-1.820
max	102.880-93.521=9.359

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	7301.000-7323.000=-22.000
σ	0.000
min	7301.000-7323.000=-22.000
max	7301.000-7323.000=-22.000

*mean*	107.013-104.557=2.456
σ	2.374-6.960=-4.586
min	103.602-90.628=12.974
max	109.792-112.575=-2.784

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.686
max	66.687

*mean*	7301.000-7323.000=-22.000
σ	0.000
min	7301.000-7323.000=-22.000
max	7301.000-7323.000=-22.000

*mean*	163.969-161.798=2.171
σ	5.649-9.378=-3.729
min	150.596-140.275=10.321
max	167.475-168.443=-0.968

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.900-11656.901=-0.000
σ	4.304-4.304=0.000
min	11655.306-11655.306=0.001
max	11667.552

*mean*	4151.875-4157.625=-5.750
σ	1900.254-1906.379=-6.125
min	1554.000-1556.000=-2.000
max	7301.000-7323.000=-22.000

*mean*	6600.556-6280.822=319.735
σ	1289.593-1034.593=255.000
min	4916.425-4921.505=-5.081
max	8105.100-7985.012=120.088

op=vertical_lookup_list() on indexed

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

*mean*	7301.000-7323.000=-22.000
σ	0.000
min	7301.000-7323.000=-22.000
max	7301.000-7323.000=-22.000

*mean*	5291.249-5716.575=-425.326
σ	1245.122-1845.258=-600.136
min	4361.533-4332.851=28.682
max	7700.796-8843.386=-1142.589

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*	477.000-478.000=-1.000
σ	0.000
min	477.000-478.000=-1.000
max	477.000-478.000=-1.000

*mean*	373.935-386.289=-12.354
σ	14.952-12.928=2.024
min	341.937-355.505=-13.568
max	387.358-393.945=-6.587

op=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.001
min	357.321
max	357.325

*mean*	560.000
σ	0.000
min	560.000
max	560.000

*mean*	753.105-752.665=0.441
σ	23.125-61.276=-38.151
min	707.068-641.277=65.791
max	785.826-812.845=-27.020

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1024.327-1024.328=-0.001
σ	0.759-0.758=0.000
min	1023.851-1023.853=-0.001
max	1027.464-1027.465=-0.001

*mean*	1037.400-1055.300=-17.900
σ	303.161-320.272=-17.111
min	554.000-576.000=-22.000
max	1461.000-1532.000=-71.000

*mean*	1.582-1.567=0.015
σ	0.096-0.090=0.006
min	1.505-1.399=0.106
max	1.858-1.766=0.091

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.913
σ	0.020
min	0.903
max	0.949

*mean*	401.000-402.000=-1.000
σ	0.000
min	401.000-402.000=-1.000
max	401.000-402.000=-1.000

*mean*	0.341-0.306=0.035
σ	0.296-0.305=-0.009
min	0.149-0.143=0.006
max	0.860-0.847=0.013

name=error_case.art

*mean*	2.339
σ	0.012
min	2.333
max	2.361

*mean*	401.000-402.000=-1.000
σ	0.000
min	401.000-402.000=-1.000
max	401.000-402.000=-1.000

*mean*	0.422-0.476=-0.055
σ	0.197-0.322=-0.125
min	0.320-0.319=0.001
max	0.774-1.052=-0.278

name=heavy_item.art

*mean*	1.522
σ	0.002
min	1.521
max	1.525

*mean*	401.000-402.000=-1.000
σ	0.000
min	401.000-402.000=-1.000
max	401.000-402.000=-1.000

*mean*	0.221-0.227=-0.006
σ	0.028-0.025=0.004
min	0.205-0.205=0.000
max	0.271-0.269=0.001

name=nested_use.art

*mean*	2.357
σ	0.002
min	2.356
max	2.360

*mean*	401.000-402.000=-1.000
σ	0.000
min	401.000-402.000=-1.000
max	401.000-402.000=-1.000

*mean*	0.334-0.344=-0.010
σ	0.018-0.019=-0.002
min	0.317-0.328=-0.010
max	0.364-0.376=-0.012

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	964.840
σ	0.011
min	964.835
max	964.859

*mean*	432.600-431.800=0.800
σ	3.130-1.789=1.342
min	430.000-431.000=-1.000
max	436.000-435.000=1.000

*mean*	0.578-0.488=0.090
σ	0.044-0.043=0.001
min	0.526-0.428=0.098
max	0.616-0.542=0.074

name=cdr_enhanced_4k_loc.art

*mean*	885.820
σ	0.002
min	885.819
max	885.823

*mean*	436.000-442.000=-6.000
σ	0.000
min	436.000-442.000=-6.000
max	436.000-442.000=-6.000

*mean*	0.486-0.436=0.050
σ	0.055-0.038=0.017
min	0.389-0.389=0.001
max	0.520-0.495=0.025

Parser: Record Parsing

Factor

allocated MiB

peak allocated MiB

time (ms)

name=record_render_large_success.art

*mean*	7.709
σ	0.002
min	7.708
max	7.712

*mean*	436.000-442.000=-6.000
σ	0.000
min	436.000-442.000=-6.000
max	436.000-442.000=-6.000

*mean*	2.595-2.640=-0.046
σ	0.079-0.106=-0.027
min	2.467-2.461=0.006
max	2.891-2.898=-0.008

name=record_render_large_syntax_err.art

*mean*	7.657
σ	0.002
min	7.656
max	7.660

*mean*	436.000-442.000=-6.000
σ	0.000
min	436.000-442.000=-6.000
max	436.000-442.000=-6.000

*mean*	2.573-2.576=-0.003
σ	0.055-0.098=-0.043
min	2.462-2.412=0.050
max	2.743-3.016=-0.273

name=record_render_success.art

*mean*	2.289
σ	0.002
min	2.289
max	2.293

*mean*	436.000-442.000=-6.000
σ	0.000
min	436.000-442.000=-6.000
max	436.000-442.000=-6.000

*mean*	0.309-0.311=-0.002
σ	0.013-0.010=0.003
min	0.290-0.291=-0.001
max	0.363-0.361=0.002

name=record_render_syntax_err.art

*mean*	2.165
σ	0.002
min	2.164
max	2.168

*mean*	436.000-442.000=-6.000
σ	0.000
min	436.000-442.000=-6.000
max	436.000-442.000=-6.000

*mean*	0.293-0.295=-0.002
σ	0.009-0.038=-0.029
min	0.278-0.279=-0.001
max	0.339-0.658=-0.319

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	298.707-298.813=-0.106
σ	1.036-1.035=0.001
min	298.299-298.377=-0.079
max	301.649-301.751=-0.102

*mean*	445.100-446.900=-1.800
σ	18.520-18.466=0.054
min	418.000
max	471.000-472.000=-1.000

*mean*	0.617-0.606=0.011
σ	0.013-0.018=-0.005
min	0.587-0.570=0.018
max	0.636-0.620=0.016

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	239.536-239.532=0.004
σ	0.000-0.000=-0.000
min	239.536-239.532=0.004
max	239.536-239.532=0.004

*mean*	1733.625-1748.000=-14.375
σ	20.860-0.000=20.860
min	1682.000-1748.000=-66.000
max	1741.000-1748.000=-7.000

*mean*	217.660-217.485=0.175
σ	1.935-1.648=0.287
min	215.160-215.632=-0.472
max	220.869-220.195=0.674

phase=macro expansion

*mean*	6.133-6.130=0.004
σ	0.000
min	6.133-6.130=0.004
max	6.133-6.130=0.004

*mean*	1733.625-1748.000=-14.375
σ	20.860-0.000=20.860
min	1682.000-1748.000=-66.000
max	1741.000-1748.000=-7.000

*mean*	11.547-11.908=-0.361
σ	1.482-1.366=0.116
min	9.398-9.554=-0.155
max	12.687-13.076=-0.389

phase=parser

*mean*	1042.363-1042.362=0.001
σ	0.000-0.000=-0.000
min	1042.363-1042.361=0.001
max	1042.363-1042.362=0.001

*mean*	1733.625-1748.000=-14.375
σ	20.860-0.000=20.860
min	1682.000-1748.000=-66.000
max	1741.000-1748.000=-7.000

*mean*	667.807-676.964=-9.157
σ	73.768-95.845=-22.077
min	559.844-561.788=-1.944
max	724.734-827.066=-102.332

phase=processProdDef

*mean*	6169.657-6169.660=-0.003
σ	0.001-0.001=0.000
min	6169.657-6169.660=-0.003
max	6169.658-6169.661=-0.003

*mean*	1741.000-1748.000=-7.000
σ	0.000
min	1741.000-1748.000=-7.000
max	1741.000-1748.000=-7.000

*mean*	5298.032-5337.267=-39.235
σ	811.073-1696.287=-885.214
min	4316.417-3676.409=640.008
max	6665.889-7898.141=-1232.253

phase=renaming

*mean*	21.671-21.675=-0.004
σ	0.000
min	21.671-21.675=-0.004
max	21.671-21.675=-0.004

*mean*	1733.625-1748.000=-14.375
σ	20.860-0.000=20.860
min	1682.000-1748.000=-66.000
max	1741.000-1748.000=-7.000

*mean*	44.026-53.660=-9.634
σ	5.158-26.877=-21.719
min	34.656-34.815=-0.159
max	48.136-118.289=-70.153

phase=type checker

*mean*	990.442
σ	0.066
min	990.344
max	990.532

*mean*	1733.625-1748.000=-14.375
σ	20.860-0.000=20.860
min	1682.000-1748.000=-66.000
max	1741.000-1748.000=-7.000

*mean*	762.117-833.859=-71.742
σ	70.733-55.813=14.920
min	676.459-751.190=-74.730
max	897.936-922.268=-24.332

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	293.926-293.926=0.001
σ	0.046-0.046=0.000
min	293.861-293.861=0.000
max	293.972-293.971=0.001

*mean*	443.800-445.000=-1.200
σ	1.095-0.000=1.095
min	443.000-445.000=-2.000
max	445.000

*mean*	0.413-0.402=0.011
σ	0.008-0.005=0.004
min	0.404-0.399=0.005
max	0.423-0.410=0.013

iters=5

new-facts=1

prior-facts=6402

*mean*	1320.230-1320.239=-0.009
σ	0.066-0.064=0.002
min	1320.171-1320.183=-0.012
max	1320.320-1320.314=0.006

*mean*	1112.200-1068.600=43.600
σ	187.716-168.841=18.875
min	892.000-842.000=50.000
max	1374.000-1277.000=97.000

*mean*	2.056-2.066=-0.010
σ	0.130-0.267=-0.137
min	1.947-1.870=0.077
max	2.225-2.486=-0.261

iters=5

new-facts=6402

prior-facts=1

*mean*	1559.739-1559.746=-0.006
σ	4.097-4.057=0.040
min	1557.707-1557.747=-0.040
max	1567.062-1566.997=0.065

*mean*	625.400-619.000=6.400
σ	88.053-82.553=5.500
min	495.000-494.000=1.000
max	730.000-716.000=14.000

*mean*	2.294-2.278=0.016
σ	0.217-0.108=0.110
min	2.127-2.172=-0.045
max	2.665-2.447=0.218

iters=5

new-facts=6402

prior-facts=6402

*mean*	1882.275-1882.276=-0.002
σ	0.066-0.062=0.004
min	1882.186-1882.196=-0.010
max	1882.345-1882.345=0.000

*mean*	1756.800-1701.400=55.400
σ	208.938-247.427=-38.489
min	1505.000-1407.000=98.000
max	1963.000-2035.000=-72.000

*mean*	3.194-2.958=0.236
σ	0.204-0.054=0.150
min	2.966-2.911=0.055
max	3.483-3.052=0.431

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.842-1.768=0.075
σ	0.104-0.152=-0.047
min	1.663-1.569=0.094
max	1.923-1.919=0.004

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	453.536-453.537=-0.000
σ	585.529-585.528=0.000
min	160.771-160.771=-0.000
max	1331.829-1331.829=0.000

*mean*	102.250
σ	8.500
min	98.000
max	115.000

*mean*	443.000
σ	0.000
min	443.000
max	443.000

*mean*	0.551-0.563=-0.012
σ	0.549-0.579=-0.030
min	0.274-0.272=0.002
max	1.374-1.432=-0.057

policies=20

*mean*	1608.041-1608.044=-0.004
σ	0.432-0.420=0.011
min	1607.753-1607.757=-0.004
max	1608.681-1608.667=0.014

*mean*	980.000
σ	0.000
min	980.000
max	980.000

*mean*	449.000-451.000=-2.000
σ	10.677-10.832=-0.155
min	443.000
max	465.000-467.000=-2.000

*mean*	2.724-2.715=0.009
σ	0.020-0.007=0.014
min	2.694-2.706=-0.012
max	2.738-2.720=0.017

policies=200

*mean*	16088.517-16088.504=0.012
σ	0.136-0.158=-0.022
min	16088.315-16088.281=0.034
max	16088.612-16088.637=-0.025

*mean*	9800.000
σ	0.000
min	9800.000
max	9800.000

*mean*	499.250-500.000=-0.750
σ	5.679-6.055=-0.376
min	493.000-494.000=-1.000
max	505.000-507.000=-2.000

*mean*	27.420-27.379=0.041
σ	0.148-0.121=0.027
min	27.292-27.213=0.079
max	27.597-27.500=0.097