Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-54.616=0.000
σ	0.350-0.350=-0.000
min	54.480-54.483=-0.002
max	55.612-55.612=-0.000

*mean*	416.000-415.000=1.000
σ	0.000
min	416.000-415.000=1.000
max	416.000-415.000=1.000

*mean*	0.139-0.140=-0.001
σ	0.004-0.004=-0.000
min	0.133-0.136=-0.004
max	0.145-0.146=-0.001

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.786=-0.001
σ	0.006-0.007=-0.001
min	43.779-43.777=0.002
max	43.797-43.800=-0.003

*mean*	416.000-415.000=1.000
σ	0.000
min	416.000-415.000=1.000
max	416.000-415.000=1.000

*mean*	0.122-0.124=-0.001
σ	0.004-0.004=0.000
min	0.119-0.118=0.001
max	0.129-0.130=-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-36.620=-0.001

*mean*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	12.451-12.231=0.220
σ	0.389-0.326=0.062
min	11.862-11.860=0.002
max	13.092-12.914=0.179

op=column_set() on indexed, repeat

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

*mean*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	12.745-12.179=0.566
σ	0.484-0.608=-0.125
min	11.677-11.333=0.344
max	13.177-12.867=0.310

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.932-41.929=0.003

*mean*	6038.000-6039.000=-1.000
σ	0.000
min	6038.000-6039.000=-1.000
max	6038.000-6039.000=-1.000

*mean*	13.142-13.103=0.039
σ	1.236-1.098=0.139
min	10.590-10.745=-0.155
max	14.654-14.460=0.195

op=table_records(), repeat

*mean*	41.929-41.928=0.001
σ	0.003-0.002=0.001
min	41.927
max	41.935-41.931=0.004

*mean*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	11.973-12.186=-0.213
σ	1.493-1.731=-0.238
min	10.201-10.240=-0.039
max	13.767-14.440=-0.673

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.609-27.607=0.002

*mean*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	8.426-8.353=0.073
σ	0.356-0.301=0.055
min	8.018-7.961=0.057
max	8.874-8.690=0.183

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*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	6.518-6.477=0.041
σ	0.183-0.115=0.069
min	6.191-6.324=-0.133
max	6.789-6.601=0.189

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.668-25.670=-0.001

*mean*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	5.498-5.428=0.071
σ	0.094-0.069=0.026
min	5.303-5.337=-0.034
max	5.630-5.552=0.079

op=vertical_lookup_row_list() on 3 (1 unindexed)

*mean*	25.968
σ	0.002-0.002=0.000
min	25.967
max	25.971

*mean*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	5.369-5.236=0.133
σ	0.091-0.055=0.036
min	5.279-5.153=0.126
max	5.569-5.304=0.265

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.593=0.003
max	2524.598-2524.594=0.004

*mean*	6038.000-6039.000=-1.000
σ	0.000
min	6038.000-6039.000=-1.000
max	6038.000-6039.000=-1.000

*mean*	1527.045-1534.858=-7.813
σ	790.115-790.614=-0.500
min	1034.219-1035.167=-0.949
max	3084.406-2960.332=124.074

op=load_product(), with indexes

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

*mean*	3820.250-3818.500=1.750
σ	1649.005-1647.983=1.022
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	4364.415-4584.385=-219.970
σ	1402.928-1511.924=-108.996
min	3526.320-3516.131=10.190
max	7342.726-7650.294=-307.567

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
max	62.080-62.080=0.001

*mean*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	81.305-81.226=0.079
σ	10.923-11.656=-0.733
min	70.309-70.285=0.024
max	96.959-101.506=-4.547

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*	6038.000-6039.000=-1.000
σ	0.000
min	6038.000-6039.000=-1.000
max	6038.000-6039.000=-1.000

*mean*	96.003-95.464=0.538
σ	11.243-10.293=0.950
min	74.099-77.828=-3.729
max	108.465-108.228=0.237

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

*mean*	6038.000-6039.000=-1.000
σ	0.000
min	6038.000-6039.000=-1.000
max	6038.000-6039.000=-1.000

*mean*	219.998-221.070=-1.072
σ	221.864-221.026=0.838
min	110.048-117.099=-7.050
max	767.539-766.842=0.697

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*	4103.125-4099.375=3.750
σ	1568.741-1569.572=-0.831
min	1972.000-1978.000=-6.000
max	6038.000-6039.000=-1.000

*mean*	6084.511-6294.070=-209.559
σ	1321.863-1175.256=146.607
min	4909.019-4968.299=-59.280
max	8289.012-8066.610=222.402

op=vertical_lookup_list() on indexed

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

*mean*	6038.000-6039.000=-1.000
σ	0.000
min	6038.000-6039.000=-1.000
max	6038.000-6039.000=-1.000

*mean*	6543.081-6628.126=-85.045
σ	1478.538-1460.821=17.717
min	4394.615-4392.891=1.724
max	8269.748-7956.863=312.884

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.587-172.583=0.004
σ	0.022-0.024=-0.002
min	172.558
max	172.614-172.618=-0.005

*mean*	1972.000-1978.000=-6.000
σ	0.000
min	1972.000-1978.000=-6.000
max	1972.000-1978.000=-6.000

*mean*	372.189-355.878=16.311
σ	28.792-46.370=-17.577
min	329.210-266.143=63.067
max	415.936-401.865=14.071

op=pointedIndexFromKvs

rows=400000

*mean*	357.371-357.360=0.010
σ	0.047-0.042=0.004
min	357.321
max	357.427-357.409=0.018

*mean*	1972.000-1978.000=-6.000
σ	0.000
min	1972.000-1978.000=-6.000
max	1972.000-1978.000=-6.000

*mean*	730.855-776.186=-45.331
σ	57.986-62.682=-4.697
min	615.714-624.708=-8.994
max	787.210-825.016=-37.805

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.186-1008.184=0.003
σ	0.876-0.882=-0.006
min	1007.686-1007.690=-0.004
max	1011.809-1011.840=-0.031

*mean*	1043.600-1035.050=8.550
σ	296.626-296.524=0.102
min	546.000-543.000=3.000
max	1448.000-1433.000=15.000

*mean*	1.533-1.538=-0.005
σ	0.071-0.082=-0.011
min	1.466-1.472=-0.006
max	1.770-1.756=0.014

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*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.420-0.416=0.005
σ	0.144-0.139=0.006
min	0.333-0.329=0.004
max	0.676-0.660=0.016

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.893-0.886=0.007
σ	0.090-0.086=0.004
min	0.827-0.828=-0.001
max	1.051-1.035=0.016

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.550-0.550=-0.000
σ	0.050-0.046=0.004
min	0.519-0.519=-0.000
max	0.637-0.630=0.008

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.846-0.849=-0.003
σ	0.043-0.040=0.003
min	0.809-0.810=-0.002
max	0.918-0.912=0.006

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.543-963.543=-0.000
σ	0.025-0.026=-0.000
min	963.523
max	963.585-963.585=-0.000

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.813-0.825=-0.012
σ	0.041-0.043=-0.001
min	0.766-0.754=0.011
max	0.864-0.854=0.011

name=cdr_enhanced_4k_loc.art

*mean*	884.854-884.853=0.000
σ	0.006-0.008=-0.002
min	884.847
max	884.861-884.867=-0.006

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.701-0.679=0.022
σ	0.040-0.047=-0.007
min	0.661-0.609=0.052
max	0.745-0.737=0.008

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

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	4.257-4.250=0.007
σ	0.078-0.081=-0.002
min	4.140-4.100=0.040
max	4.636-4.530=0.106

name=record_render_large_syntax_err.art

*mean*	7.655-7.655=-0.000
σ	0.002-0.002=0.000
min	7.654
max	7.661-7.659=0.002

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	4.275-4.235=0.041
σ	0.081-0.075=0.006
min	4.109-4.117=-0.008
max	4.535-4.539=-0.003

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.670-0.749=-0.079
σ	0.106-0.016=0.090
min	0.518-0.721=-0.203
max	0.845-0.858=-0.012

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.514-0.708=-0.194
σ	0.034-0.014=0.021
min	0.489-0.678=-0.189
max	0.777-0.781=-0.003

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.427-297.529=-0.102
σ	0.221-0.248=-0.027
min	297.304-297.383=-0.078
max	298.049-298.228=-0.179

*mean*	1972.000-1978.000=-6.000
σ	0.000
min	1972.000-1978.000=-6.000
max	1972.000-1978.000=-6.000

*mean*	0.570-0.580=-0.010
σ	0.035-0.032=0.003
min	0.519-0.505=0.014
max	0.609-0.606=0.003

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.772-289.773=-0.002
σ	0.037-0.037=-0.001
min	289.722-289.726=-0.004
max	289.807-289.812=-0.005

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.397-0.406=-0.008
σ	0.002-0.010=-0.008
min	0.394-0.398=-0.004
max	0.401-0.422=-0.021

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.637-1299.646=-0.009
σ	0.061-0.064=-0.003
min	1299.576-1299.573=0.002
max	1299.703-1299.726=-0.023

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	2.051-2.090=-0.039
σ	0.059-0.092=-0.033
min	1.987-1.936=0.051
max	2.123-2.176=-0.053

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.616-1542.680=-0.064
σ	4.015-4.063=-0.048
min	1540.614-1540.705=-0.091
max	1549.792-1549.943=-0.151

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	2.295-2.469=-0.174
σ	0.196-0.280=-0.084
min	2.121-2.132=-0.011
max	2.610-2.901=-0.291

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.626-1861.638=-0.012
σ	0.074-0.058=0.016
min	1861.515-1861.551=-0.035
max	1861.692-1861.692=0.001

*mean*	1719.400-1763.800=-44.400
σ	171.157-226.028=-54.871
min	1526.000-1467.000=59.000
max	1972.000-1978.000=-6.000

*mean*	2.963-3.239=-0.276
σ	0.159-0.245=-0.086
min	2.825-2.896=-0.071
max	3.194-3.493=-0.299

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.758-1.754=0.004
σ	0.126-0.210=-0.083
min	1.576-1.448=0.127
max	1.894-2.023=-0.129

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.185-446.183=0.001
σ	577.140-577.137=0.003
min	157.614-157.613=0.001
max	1311.895-1311.889=0.005

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	0.558-0.535=0.023
σ	0.594-0.536=0.058
min	0.260-0.264=-0.004
max	1.449-1.339=0.110

policies=20

*mean*	1576.413-1576.402=0.011
σ	0.352-0.339=0.013
min	1576.177-1576.172=0.005
max	1576.937-1576.906=0.031

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	2.626-2.612=0.014
σ	0.014-0.013=0.002
min	2.614-2.597=0.017
max	2.645-2.627=0.018

policies=200

*mean*	15772.227-15772.288=-0.061
σ	0.094-0.160=-0.066
min	15772.136-15772.086=0.050
max	15772.353-15772.469=-0.116

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1448.000-1433.000=15.000
σ	0.000
min	1448.000-1433.000=15.000
max	1448.000-1433.000=15.000

*mean*	26.523-26.470=0.053
σ	0.082-0.049=0.034
min	26.410-26.430=-0.020
max	26.589-26.538=0.050