Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.617=-0.000
σ	0.350-0.352=-0.002
min	54.487-54.483=0.004
max	55.613-55.618=-0.005

*mean*	420.000-417.000=3.000
σ	0.000
min	420.000-417.000=3.000
max	420.000-417.000=3.000

*mean*	0.141-0.140=0.001
σ	0.005-0.004=0.001
min	0.136-0.136=0.000
max	0.152-0.146=0.007

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.786=-0.001
σ	0.006-0.006=-0.000
min	43.779-43.776=0.003
max	43.799-43.799=0.000

*mean*	420.000-417.000=3.000
σ	0.000
min	420.000-417.000=3.000
max	420.000-417.000=3.000

*mean*	0.124-0.123=0.000
σ	0.005-0.004=0.000
min	0.119-0.119=0.000
max	0.130-0.131=-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.616-36.615=0.000
max	36.620

*mean*	4112.000-4111.750=0.250
σ	1577.972-1561.686=16.287
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	13.191-11.993=1.198
σ	1.788-0.307=1.482
min	12.228-11.556=0.672
max	17.592-12.468=5.124

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*	4112.000-4111.750=0.250
σ	1577.972-1561.686=16.287
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	12.910-12.514=0.396
σ	1.723-0.296=1.427
min	11.433-12.113=-0.680
max	16.799-13.024=3.776

op=table_records(), no indexes

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

*mean*	6032.000-6047.000=-15.000
σ	0.000
min	6032.000-6047.000=-15.000
max	6032.000-6047.000=-15.000

*mean*	13.722-13.001=0.721
σ	1.063-1.145=-0.083
min	11.606-10.876=0.730
max	14.925-14.411=0.514

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.932=-0.001

*mean*	4046.000-4111.750=-65.750
σ	1628.502-1561.686=66.816
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	12.955-12.346=0.609
σ	2.149-1.767=0.383
min	10.399-10.512=-0.113
max	14.931-14.618=0.312

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

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

*mean*	4046.000-4111.750=-65.750
σ	1628.502-1561.686=66.816
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	8.530-8.347=0.183
σ	0.391-0.374=0.017
min	7.995-7.700=0.294
max	9.070-8.891=0.179

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

*mean*	26.400
σ	0.002
min	26.399
max	26.403

*mean*	4046.000-4111.750=-65.750
σ	1628.502-1561.686=66.816
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	6.416-6.222=0.194
σ	0.171-0.198=-0.027
min	6.185-5.905=0.280
max	6.651-6.469=0.182

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.664=0.000
max	25.669

*mean*	4112.000-4111.750=0.250
σ	1577.972-1561.686=16.287
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	5.737-5.261=0.475
σ	0.555-0.130=0.425
min	5.385-5.076=0.309
max	7.090-5.467=1.623

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

*mean*	4112.000-4111.750=0.250
σ	1577.972-1561.686=16.287
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	5.599-5.089=0.511
σ	0.528-0.205=0.322
min	5.358-4.790=0.569
max	6.902-5.438=1.464

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.593-2524.593=0.000
σ	0.000-0.000=-0.000
min	2524.593-2524.593=0.000
max	2524.594

*mean*	6032.000-6047.000=-15.000
σ	0.000
min	6032.000-6047.000=-15.000
max	6032.000-6047.000=-15.000

*mean*	1437.378-1424.158=13.220
σ	625.108-636.682=-11.575
min	1027.584-1031.011=-3.427
max	2651.473-2775.619=-124.145

op=load_product(), with indexes

*mean*	8744.559-8744.559=-0.000
σ	0.033-0.033=0.000
min	8744.544-8744.544=-0.000
max	8744.640-8744.639=0.000

*mean*	3816.125-3837.500=-21.375
σ	1666.942-1633.742=33.200
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	4478.887-4191.663=287.224
σ	1363.206-1248.783=114.423
min	3550.577-3504.455=46.122
max	7502.152-7089.260=412.892

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.003=-0.001
min	62.076
max	62.081-62.084=-0.003

*mean*	4112.000-4111.750=0.250
σ	1577.972-1561.686=16.287
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	148.251-78.938=69.312
σ	190.410-8.910=181.501
min	71.361-70.238=1.123
max	618.733-90.073=528.660

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

*mean*	6032.000-6047.000=-15.000
σ	0.000
min	6032.000-6047.000=-15.000
max	6032.000-6047.000=-15.000

*mean*	96.547-98.425=-1.879
σ	10.002-10.502=-0.500
min	75.687-83.089=-7.401
max	107.244-110.173=-2.928

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

*mean*	6032.000-6047.000=-15.000
σ	0.000
min	6032.000-6047.000=-15.000
max	6032.000-6047.000=-15.000

*mean*	231.903-225.422=6.481
σ	247.667-235.403=12.264
min	112.011-119.686=-7.674
max	843.605-806.864=36.741

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

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

*mean*	4046.000-4111.750=-65.750
σ	1628.502-1561.686=66.816
min	1915.000-2029.000=-114.000
max	6032.000-6047.000=-15.000

*mean*	6248.247-5917.013=331.233
σ	1245.688-1194.834=50.853
min	4909.141-4867.045=42.096
max	8282.019-8216.295=65.724

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*	6032.000-6047.000=-15.000
σ	0.000
min	6032.000-6047.000=-15.000
max	6032.000-6047.000=-15.000

*mean*	6710.566-6368.396=342.170
σ	1216.705-1161.424=55.281
min	4403.511-4379.456=24.055
max	8101.423-7928.250=173.174

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.583-172.588=-0.004
σ	0.026-0.030=-0.004
min	172.558-172.560=-0.002
max	172.630-172.630=0.000

*mean*	1915.000-2029.000=-114.000
σ	0.000
min	1915.000-2029.000=-114.000
max	1915.000-2029.000=-114.000

*mean*	357.309-371.119=-13.809
σ	42.655-69.006=-26.351
min	269.836-262.853=6.983
max	407.123-501.187=-94.064

op=pointedIndexFromKvs

rows=400000

*mean*	357.362-357.367=-0.005
σ	0.040-0.046=-0.005
min	357.321
max	357.412-357.426=-0.015

*mean*	1915.000-2029.000=-114.000
σ	0.000
min	1915.000-2029.000=-114.000
max	1915.000-2029.000=-114.000

*mean*	771.261-770.310=0.952
σ	54.326-20.418=33.908
min	642.851-748.528=-105.677
max	808.220-799.623=8.597

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.185-1008.187=-0.002
σ	0.874-0.875=-0.001
min	1007.685-1007.689=-0.004
max	1011.803-1011.811=-0.008

*mean*	1048.900-1038.600=10.300
σ	307.178-303.828=3.351
min	562.000-547.000=15.000
max	1481.000-1464.000=17.000

*mean*	1.550-1.521=0.030
σ	0.092-0.067=0.025
min	1.453-1.447=0.005
max	1.823-1.709=0.114

Parser: Comma Sep

Factor

allocated MiB

peak allocated MiB

time (ms)

name=ambiguous_item.art

*mean*	0.883-0.883=-0.000
σ	0.002-0.002=0.000
min	0.881
max	0.886

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.408-0.419=-0.010
σ	0.133-0.133=0.000
min	0.330-0.342=-0.012
max	0.644-0.656=-0.012

name=error_case.art

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

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.883-0.879=0.004
σ	0.085-0.076=0.009
min	0.827-0.827=-0.000
max	1.030-1.012=0.019

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.532-0.537=-0.005
σ	0.053-0.047=0.007
min	0.491-0.497=-0.006
max	0.620-0.609=0.012

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.828-0.834=-0.006
σ	0.043-0.041=0.002
min	0.791-0.796=-0.005
max	0.900-0.901=-0.001

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.541-963.541=0.000
σ	0.028-0.028=0.000
min	963.523
max	963.589-963.589=0.000

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.825-0.808=0.016
σ	0.054-0.040=0.013
min	0.750-0.754=-0.004
max	0.871-0.859=0.011

name=cdr_enhanced_4k_loc.art

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

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.739-0.732=0.007
σ	0.017-0.029=-0.012
min	0.709-0.680=0.029
max	0.750-0.749=0.002

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.712-7.712=0.000

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	4.246-4.328=-0.081
σ	0.098-0.096=0.002
min	4.087-4.160=-0.074
max	4.652-4.578=0.074

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	4.244-4.281=-0.037
σ	0.077-0.124=-0.048
min	4.089-4.091=-0.002
max	4.570-5.135=-0.565

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.743-0.757=-0.015
σ	0.019-0.019=0.001
min	0.706-0.725=-0.019
max	0.859-0.867=-0.008

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1481.000-1464.000=17.000
σ	0.000
min	1481.000-1464.000=17.000
max	1481.000-1464.000=17.000

*mean*	0.700-0.718=-0.018
σ	0.015-0.013=0.001
min	0.674-0.692=-0.018
max	0.786-0.761=0.024

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.413-297.419=-0.007
σ	0.287-0.259=0.028
min	297.173-297.228=-0.055
max	298.197-298.130=0.067

*mean*	1915.000-2029.000=-114.000
σ	0.000
min	1915.000-2029.000=-114.000
max	1915.000-2029.000=-114.000

*mean*	0.607-0.555=0.052
σ	0.036-0.032=0.004
min	0.569-0.503=0.067
max	0.694-0.587=0.107

Timed compile per phase

Factor

allocated MiB

peak allocated MiB

time (ms)

phase=buildDeclTree

*mean*	221.996-219.065=2.931
σ	0.000-0.000=0.000
min	221.996-219.065=2.931
max	221.996-219.065=2.931

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	206.686-197.168=9.519
σ	1.766-2.133=-0.367
min	204.391-193.214=11.177
max	208.674-199.949=8.725

phase=macro expansion

*mean*	6.127-1.295=4.832
σ	0.000
min	6.127-1.295=4.832
max	6.127-1.295=4.832

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	10.758-0.984=9.774
σ	2.099-0.231=1.868
min	7.534-0.634=6.900
max	13.800-1.200=12.600

phase=parser

*mean*	1041.086-1023.358=17.727
σ	0.000-0.000=-0.000
min	1041.086-1023.358=17.728
max	1041.086-1023.359=17.727

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	636.292-590.843=45.449
σ	105.698-111.450=-5.752
min	421.881-351.993=69.888
max	728.774-679.165=49.609

phase=processProdDef

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

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	6563.675-5788.237=775.438
σ	977.444-1249.935=-272.491
min	4343.988-4269.816=74.172
max	7272.435-7448.934=-176.499

phase=renaming

*mean*	21.666-24.522=-2.856
σ	0.000
min	21.666-24.522=-2.856
max	21.666-24.522=-2.856

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	41.386-40.623=0.762
σ	8.321-7.521=0.800
min	26.374-23.862=2.512
max	51.814-46.339=5.475

phase=type checker

*mean*	958.665-974.792=-16.126
σ	0.055-0.047=0.008
min	958.579-974.722=-16.142
max	958.736-974.878=-16.142

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	792.979-765.170=27.809
σ	111.448-100.430=11.018
min	632.669-688.284=-55.615
max	970.706-994.923=-24.217

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.764-289.765=-0.000
σ	0.036-0.034=0.002
min	289.716-289.718=-0.001
max	289.802-289.800=0.002

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	0.390-0.389=0.000
σ	0.001-0.005=-0.003
min	0.389-0.386=0.003
max	0.392-0.398=-0.005

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.601-1299.618=-0.017
σ	0.122-0.096=0.026
min	1299.501-1299.512=-0.010
max	1299.807-1299.775=0.033

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	1.935-1.935=0.000
σ	0.169-0.177=-0.008
min	1.815-1.796=0.020
max	2.196-2.157=0.039

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.630-1542.638=-0.008
σ	3.998-4.027=-0.028
min	1540.660-1540.621=0.039
max	1549.776-1549.835=-0.059

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	2.239-2.303=-0.064
σ	0.094-0.237=-0.143
min	2.131-2.056=0.075
max	2.372-2.649=-0.277

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.629-1861.637=-0.008
σ	0.047-0.046=0.001
min	1861.579-1861.594=-0.015
max	1861.690-1861.702=-0.012

*mean*	1856.200-1821.200=35.000
σ	53.677-123.524=-69.847
min	1817.000-1745.000=72.000
max	1915.000-2029.000=-114.000

*mean*	3.114-2.905=0.209
σ	0.332-0.069=0.262
min	2.862-2.830=0.032
max	3.693-2.981=0.712

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.806-1.799=0.007
σ	0.109-0.081=0.027
min	1.628-1.659=-0.031
max	1.898-1.865=0.033

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.183-446.183=-0.000
σ	577.141-577.140=0.001
min	157.610-157.610=0.000
max	1311.895-1311.893=0.002

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	0.553-0.469=0.084
σ	0.577-0.388=0.189
min	0.258-0.273=-0.015
max	1.419-1.051=0.368

policies=20

*mean*	1576.410-1576.421=-0.011
σ	0.346-0.403=-0.057
min	1576.174-1576.155=0.019
max	1576.924-1577.021=-0.096

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	2.619-2.703=-0.084
σ	0.020-0.007=0.013
min	2.590-2.694=-0.104
max	2.636-2.709=-0.073

policies=200

*mean*	15772.234-15772.225=0.009
σ	0.141-0.246=-0.105
min	15772.109-15771.998=0.112
max	15772.428-15772.551=-0.123

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1817.000-1745.000=72.000
σ	0.000
min	1817.000-1745.000=72.000
max	1817.000-1745.000=72.000

*mean*	26.634-26.791=-0.156
σ	0.217-0.375=-0.157
min	26.432-26.299=0.133
max	26.855-27.167=-0.312