Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.616=0.001
σ	0.352-0.349=0.003
min	54.483-54.483=-0.000
max	55.620-55.609=0.011

*mean*	415.000-417.700=-2.700
σ	0.000-0.483=-0.483
min	415.000-417.000=-2.000
max	415.000-418.000=-3.000

*mean*	0.138-0.140=-0.002
σ	0.005-0.005=0.000
min	0.132-0.136=-0.003
max	0.147-0.149=-0.002

cache=y

dps=1

iters=10

policies=100

*mean*	43.786-43.785=0.001
σ	0.007-0.006=0.000
min	43.776-43.777=-0.001
max	43.796-43.800=-0.004

*mean*	415.000-418.000=-3.000
σ	0.000
min	415.000-418.000=-3.000
max	415.000-418.000=-3.000

*mean*	0.122-0.123=-0.002
σ	0.005-0.005=-0.001
min	0.118-0.119=-0.002
max	0.130-0.135=-0.005

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-36.620=-0.001

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	12.111-12.612=-0.501
σ	0.229-0.309=-0.080
min	11.779-12.187=-0.408
max	12.487-13.250=-0.763

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.619-36.620=-0.000

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	11.325-12.435=-1.110
σ	0.182-0.620=-0.437
min	11.080-11.501=-0.421
max	11.527-13.066=-1.539

op=table_records(), no indexes

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

*mean*	7544.000-7545.000=-1.000
σ	0.000
min	7544.000-7545.000=-1.000
max	7544.000-7545.000=-1.000

*mean*	14.050-13.413=0.636
σ	1.052-1.349=-0.298
min	12.608-10.777=1.831
max	15.404-14.853=0.551

op=table_records(), repeat

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

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	11.712-12.027=-0.315
σ	1.730-1.808=-0.078
min	10.205-10.286=-0.081
max	14.270-14.652=-0.381

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

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

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	8.120-8.307=-0.187
σ	0.350-0.685=-0.335
min	7.437-7.441=-0.003
max	8.475-9.794=-1.319

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

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	6.249-6.471=-0.222
σ	0.212-0.598=-0.387
min	5.910-6.098=-0.188
max	6.456-7.878=-1.423

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

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	5.223-5.425=-0.202
σ	0.150-0.221=-0.071
min	5.063-5.137=-0.074
max	5.555-5.896=-0.340

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

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	5.008-5.141=-0.133
σ	0.155-0.076=0.079
min	4.686-5.062=-0.376
max	5.160-5.268=-0.108

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

*mean*	2524.597-2524.594=0.003
σ	0.000-0.000=0.000
min	2524.597-2524.594=0.003
max	2524.597-2524.594=0.003

*mean*	7544.000-7545.000=-1.000
σ	0.000
min	7544.000-7545.000=-1.000
max	7544.000-7545.000=-1.000

*mean*	1038.578-1057.556=-18.979
σ	4.107-8.899=-4.792
min	1034.199-1046.807=-12.608
max	1045.913-1068.272=-22.359

op=load_product(), with indexes

*mean*	8744.558-8744.559=-0.001
σ	0.033-0.033=0.000
min	8744.544-8744.544=-0.000
max	8744.641-8744.640=0.000

*mean*	3765.250-3775.500=-10.250
σ	1634.057-1626.165=7.892
min	1897.000-1929.000=-32.000
max	5940.000-5948.000=-8.000

*mean*	4722.740-4354.247=368.493
σ	1450.687-1314.454=136.233
min	3510.100-3548.040=-37.940
max	7200.345-7059.705=140.640

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.003-0.002=0.001
min	62.076
max	62.084-62.080=0.004

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	79.982-84.028=-4.046
σ	8.777-9.211=-0.434
min	69.799-72.587=-2.788
max	93.960-98.079=-4.119

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*	7544.000-7545.000=-1.000
σ	0.000
min	7544.000-7545.000=-1.000
max	7544.000-7545.000=-1.000

*mean*	245.976-96.581=149.395
σ	410.548-10.784=399.764
min	85.860-76.125=9.735
max	1261.842-107.405=1154.437

op=vertical_lookup_row_list() on unindexed small unique Int

*mean*	66.686-66.686=0.000
σ	0.001-0.000=0.001
min	66.685-66.685=-0.000
max	66.689-66.686=0.003

*mean*	7544.000-7545.000=-1.000
σ	0.000
min	7544.000-7545.000=-1.000
max	7544.000-7545.000=-1.000

*mean*	150.723-149.153=1.570
σ	14.298-15.283=-0.985
min	132.397-121.994=10.402
max	167.540-166.217=1.323

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.833-11656.833=-0.000
σ	4.317-4.318=-0.001
min	11655.305-11655.305=-0.000
max	11667.517-11667.520=-0.003

*mean*	4254.375-4259.000=-4.625
σ	1892.385-1887.701=4.685
min	1897.000-1929.000=-32.000
max	7544.000-7545.000=-1.000

*mean*	6479.039-6295.913=183.126
σ	1320.729-1023.260=297.469
min	4853.513-4965.987=-112.474
max	8336.561-8022.755=313.806

op=vertical_lookup_list() on indexed

*mean*	11560.065-11560.068=-0.003
σ	0.001-0.001=-0.000
min	11560.064-11560.066=-0.002
max	11560.066-11560.069=-0.003

*mean*	7544.000-7545.000=-1.000
σ	0.000
min	7544.000-7545.000=-1.000
max	7544.000-7545.000=-1.000

*mean*	5408.848-5373.386=35.462
σ	1304.723-1219.751=84.971
min	4369.897-4399.930=-30.033
max	7438.593-7192.033=246.560

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.583-172.589=-0.006
σ	0.026-0.021=0.005
min	172.558
max	172.625-172.613=0.012

*mean*	1897.000-1929.000=-32.000
σ	0.000
min	1897.000-1929.000=-32.000
max	1897.000-1929.000=-32.000

*mean*	358.079-358.778=-0.699
σ	26.380-47.360=-20.980
min	313.883-269.754=44.129
max	392.420-405.477=-13.057

op=pointedIndexFromKvs

rows=400000

*mean*	357.368-357.361=0.007
σ	0.047-0.037=0.010
min	357.321
max	357.431-357.400=0.031

*mean*	1897.000-1929.000=-32.000
σ	0.000
min	1897.000-1929.000=-32.000
max	1897.000-1929.000=-32.000

*mean*	756.294-773.133=-16.839
σ	72.865-49.469=23.395
min	579.832-654.887=-75.055
max	798.263-805.537=-7.274

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.187-1008.185=0.002
σ	0.880-0.880=-0.000
min	1007.686-1007.685=0.001
max	1011.832-1011.835=-0.003

*mean*	1037.850-1042.350=-4.500
σ	308.148-305.136=3.012
min	541.000-548.000=-7.000
max	1470.000-1468.000=2.000

*mean*	1.537-1.537=-0.001
σ	0.103-0.090=0.013
min	1.406-1.451=-0.045
max	1.831-1.782=0.049

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*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.430-0.419=0.011
σ	0.127-0.136=-0.008
min	0.345-0.336=0.010
max	0.648-0.660=-0.012

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.882-0.880=0.002
σ	0.089-0.100=-0.011
min	0.813-0.822=-0.009
max	1.036-1.056=-0.021

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.543-0.539=0.004
σ	0.046-0.061=-0.014
min	0.500-0.492=0.008
max	0.618-0.642=-0.024

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.851-0.838=0.013
σ	0.038-0.040=-0.002
min	0.814-0.808=0.005
max	0.913-0.900=0.013

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.544-963.542=0.002
σ	0.026-0.032=-0.007
min	963.523
max	963.585-963.598=-0.013

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.826-0.815=0.011
σ	0.022-0.050=-0.028
min	0.812-0.736=0.077
max	0.865-0.860=0.005

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.853=0.000
σ	0.007-0.006=0.000
min	884.847
max	884.861-884.860=0.001

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.744-0.724=0.020
σ	0.014-0.035=-0.021
min	0.728-0.672=0.056
max	0.765-0.754=0.011

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.711-7.711=0.001

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	4.233-4.235=-0.002
σ	0.087-0.073=0.014
min	4.116-4.125=-0.009
max	4.631-4.484=0.147

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	4.230-4.259=-0.029
σ	0.074-0.127=-0.053
min	4.100-4.081=0.020
max	4.515-5.039=-0.524

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.755-0.756=-0.001
σ	0.016-0.017=-0.001
min	0.728-0.724=0.003
max	0.843-0.859=-0.016

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.719-0.703=0.017
σ	0.015-0.055=-0.040
min	0.688-0.505=0.183
max	0.802-0.812=-0.010

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.433-297.503=-0.070
σ	0.160-0.219=-0.059
min	297.254-297.347=-0.093
max	297.834-298.103=-0.269

*mean*	1897.000-1929.000=-32.000
σ	0.000
min	1897.000-1929.000=-32.000
max	1897.000-1929.000=-32.000

*mean*	0.565-0.601=-0.036
σ	0.048-0.047=0.001
min	0.502-0.518=-0.016
max	0.646-0.704=-0.058

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.776-289.776=0.001
σ	0.037-0.034=0.003
min	289.725-289.726=-0.001
max	289.811-289.810=0.000

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.400-0.401=-0.001
σ	0.012-0.009=0.003
min	0.394-0.396=-0.002
max	0.421-0.416=0.005

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.626-1299.681=-0.055
σ	0.107-0.084=0.023
min	1299.512-1299.606=-0.094
max	1299.754-1299.811=-0.057

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	1.965-2.077=-0.112
σ	0.116-0.091=0.025
min	1.827-1.988=-0.161
max	2.138-2.223=-0.085

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.596-1542.627=-0.031
σ	4.026-4.040=-0.014
min	1540.595-1540.629=-0.034
max	1549.789-1549.846=-0.058

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	2.216-2.303=-0.088
σ	0.165-0.170=-0.005
min	2.039-2.043=-0.004
max	2.416-2.499=-0.083

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.637-1861.624=0.013
σ	0.048-0.081=-0.033
min	1861.592-1861.507=0.085
max	1861.713-1861.711=0.002

*mean*	1733.600-1749.400=-15.800
σ	177.032-194.083=-17.051
min	1482.000-1477.000=5.000
max	1897.000-1929.000=-32.000

*mean*	2.998-2.998=0.000
σ	0.302-0.151=0.151
min	2.751-2.880=-0.129
max	3.520-3.247=0.272

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.741-1.846=-0.106
σ	0.162-0.200=-0.038
min	1.493-1.516=-0.023
max	1.938-2.042=-0.104

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.185-446.147=0.037
σ	577.140-577.065=0.075
min	157.613-157.614=-0.001
max	1311.894-1311.745=0.149

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	0.546-0.542=0.004
σ	0.566-0.552=0.014
min	0.261-0.263=-0.001
max	1.396-1.370=0.026

policies=20

*mean*	1576.407-1576.425=-0.018
σ	0.342-0.350=-0.008
min	1576.175-1576.189=-0.013
max	1576.916-1576.946=-0.030

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	2.609-2.623=-0.014
σ	0.011-0.008=0.003
min	2.599-2.615=-0.017
max	2.622-2.633=-0.011

policies=200

*mean*	15772.215-15772.229=-0.014
σ	0.080-0.158=-0.078
min	15772.103-15772.113=-0.010
max	15772.293-15772.461=-0.169

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1470.000-1468.000=2.000
σ	0.000
min	1470.000-1468.000=2.000
max	1470.000-1468.000=2.000

*mean*	26.330-26.449=-0.119
σ	0.054-0.052=0.003
min	26.271-26.373=-0.103
max	26.402-26.487=-0.085