Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.618-54.616=0.002
σ	0.351-0.352=-0.001
min	54.483-54.478=0.004
max	55.616-55.616=0.000

*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.138-0.138=-0.000
σ	0.005-0.006=-0.001
min	0.132-0.130=0.003
max	0.146-0.147=-0.001

cache=y

dps=1

iters=10

policies=100

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

*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.000
σ	0.004-0.003=0.001
min	0.119-0.120=-0.001
max	0.130-0.128=0.001

CSV - indexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on indexed

*mean*	36.618-36.618=-0.001
σ	0.002-0.003=-0.001
min	36.615
max	36.620-36.623=-0.003

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	12.019-12.417=-0.398
σ	0.399-0.177=0.223
min	11.613-12.116=-0.503
max	12.741-12.612=0.129

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

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	11.217-12.192=-0.975
σ	0.150-0.641=-0.491
min	10.996-11.372=-0.376
max	11.485-13.094=-1.609

op=table_records(), no indexes

*mean*	41.928-41.928=-0.000
σ	0.000-0.000=-0.000
min	41.928
max	41.929-41.929=-0.000

*mean*	6041.000-6051.000=-10.000
σ	0.000
min	6041.000-6051.000=-10.000
max	6041.000-6051.000=-10.000

*mean*	13.234-13.366=-0.132
σ	1.130-1.117=0.013
min	11.060-11.252=-0.192
max	14.906-14.925=-0.019

op=table_records(), repeat

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

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	12.236-12.747=-0.511
σ	1.859-2.055=-0.196
min	10.271-10.311=-0.040
max	14.411-15.230=-0.819

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.607-27.607=-0.000

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	8.114-8.846=-0.732
σ	0.281-1.280=-0.999
min	7.760-7.805=-0.045
max	8.557-11.875=-3.318

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*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	6.051-6.933=-0.882
σ	0.358-1.027=-0.670
min	5.537-6.235=-0.698
max	6.653-9.413=-2.760

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.670-25.670=0.000

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	5.187-5.519=-0.333
σ	0.177-0.066=0.110
min	4.974-5.381=-0.407
max	5.481-5.582=-0.100

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

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	4.987-5.294=-0.307
σ	0.153-0.236=-0.083
min	4.760-4.725=0.035
max	5.213-5.458=-0.245

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

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

*mean*	6041.000-6051.000=-10.000
σ	0.000
min	6041.000-6051.000=-10.000
max	6041.000-6051.000=-10.000

*mean*	1440.812-1472.355=-31.543
σ	625.391-675.656=-50.266
min	1045.781-1028.058=17.722
max	2704.363-2607.703=96.660

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.641-8744.641=0.001

*mean*	3797.750-3824.375=-26.625
σ	1676.607-1653.325=23.282
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	4624.437-4394.566=229.872
σ	1476.191-1215.926=260.265
min	3555.135-3518.673=36.462
max	7280.586-6739.720=540.866

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

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	80.618-83.394=-2.776
σ	11.292-17.512=-6.220
min	69.711-70.615=-0.904
max	101.029-121.708=-20.680

op=vertical_lookup_list() on unindexed missing Int

*mean*	40.944-40.944=0.000
σ	0.002-0.001=0.001
min	40.943-40.944=-0.000
max	40.949-40.945=0.004

*mean*	6041.000-6051.000=-10.000
σ	0.000
min	6041.000-6051.000=-10.000
max	6041.000-6051.000=-10.000

*mean*	97.087-94.048=3.039
σ	9.054-10.976=-1.922
min	84.252-73.697=10.555
max	108.390-106.777=1.613

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

*mean*	6041.000-6051.000=-10.000
σ	0.000
min	6041.000-6051.000=-10.000
max	6041.000-6051.000=-10.000

*mean*	228.993-227.037=1.956
σ	235.166-241.336=-6.170
min	127.583-110.584=16.999
max	810.060-822.790=-12.731

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

*mean*	4089.375-4107.250=-17.875
σ	1586.689-1571.951=14.738
min	1890.000-1973.000=-83.000
max	6041.000-6051.000=-10.000

*mean*	6349.986-6187.664=162.322
σ	1228.679-1293.909=-65.230
min	4965.952-4904.547=61.404
max	8421.462-7861.776=559.686

op=vertical_lookup_list() on indexed

*mean*	11560.069-11560.069=0.000
σ	0.001-0.001=-0.000
min	11560.066-11560.066=0.001
max	11560.069

*mean*	6041.000-6051.000=-10.000
σ	0.000
min	6041.000-6051.000=-10.000
max	6041.000-6051.000=-10.000

*mean*	6734.869-6429.007=305.862
σ	1478.364-1168.088=310.276
min	4431.636-4398.251=33.386
max	8227.745-7804.055=423.690

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.585-172.583=0.002
σ	0.022-0.024=-0.002
min	172.558
max	172.621-172.619=0.002

*mean*	1890.000-1973.000=-83.000
σ	0.000
min	1890.000-1973.000=-83.000
max	1890.000-1973.000=-83.000

*mean*	353.839-352.560=1.279
σ	29.934-52.832=-22.898
min	291.427-261.727=29.701
max	391.767-409.684=-17.917

op=pointedIndexFromKvs

rows=400000

*mean*	357.358-357.362=-0.003
σ	0.035-0.040=-0.005
min	357.321
max	357.406-357.405=0.001

*mean*	1890.000-1973.000=-83.000
σ	0.000
min	1890.000-1973.000=-83.000
max	1890.000-1973.000=-83.000

*mean*	755.574-783.061=-27.487
σ	58.611-24.291=34.320
min	620.056-732.768=-112.712
max	796.550-806.227=-9.676

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.181-1008.185=-0.004
σ	0.923-0.886=0.036
min	1007.716-1007.685=0.030
max	1012.019-1011.865=0.154

*mean*	1038.750-1052.650=-13.900
σ	307.942-313.439=-5.497
min	542.000-568.000=-26.000
max	1471.000-1515.000=-44.000

*mean*	1.592-1.551=0.042
σ	0.146-0.083=0.063
min	1.427-1.419=0.008
max	1.926-1.770=0.156

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*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.439-0.440=-0.001
σ	0.184-0.174=0.010
min	0.333-0.336=-0.003
max	0.767-0.750=0.017

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.924-0.929=-0.005
σ	0.163-0.175=-0.012
min	0.838-0.819=0.019
max	1.214-1.238=-0.025

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.542-0.540=0.002
σ	0.049-0.049=0.000
min	0.499-0.502=-0.003
max	0.625-0.623=0.002

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.834-0.841=-0.007
σ	0.041-0.044=-0.002
min	0.790-0.798=-0.007
max	0.898-0.904=-0.005

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.551-963.549=0.003
σ	0.037-0.030=0.007
min	963.527-963.528=-0.001
max	963.617-963.602=0.015

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.809-0.759=0.050
σ	0.054-0.083=-0.029
min	0.728-0.656=0.072
max	0.863-0.853=0.010

name=cdr_enhanced_4k_loc.art

*mean*	884.853-884.854=-0.000
σ	0.009-0.007=0.002
min	884.847
max	884.867-884.863=0.004

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.728-0.717=0.011
σ	0.021-0.037=-0.017
min	0.706-0.658=0.048
max	0.747-0.743=0.003

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*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	3.565-4.276=-0.711
σ	0.118-0.099=0.019
min	3.410-4.138=-0.728
max	4.028-4.706=-0.678

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.658-7.659=-0.001

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	3.509-4.259=-0.749
σ	0.066-0.085=-0.018
min	3.419-4.084=-0.665
max	3.747-4.496=-0.748

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.753-0.750=0.004
σ	0.017-0.018=-0.001
min	0.721-0.717=0.003
max	0.858-0.841=0.017

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.715-0.717=-0.002
σ	0.015-0.019=-0.004
min	0.692-0.628=0.065
max	0.802-0.810=-0.008

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.494-297.479=0.016
σ	0.203-0.188=0.014
min	297.320-297.342=-0.022
max	298.021-297.993=0.028

*mean*	1890.000-1973.000=-83.000
σ	0.000
min	1890.000-1973.000=-83.000
max	1890.000-1973.000=-83.000

*mean*	0.599-0.588=0.011
σ	0.018-0.026=-0.008
min	0.574-0.548=0.025
max	0.625-0.633=-0.008

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.769-289.767=0.002
σ	0.032-0.040=-0.008
min	289.728-289.722=0.006
max	289.803-289.810=-0.008

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.398-0.400=-0.002
σ	0.015-0.011=0.004
min	0.378-0.394=-0.016
max	0.421-0.419=0.002

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.664-1299.647=0.017
σ	0.087-0.075=0.012
min	1299.560-1299.555=0.005
max	1299.779-1299.720=0.059

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	2.078-2.089=-0.012
σ	0.068-0.062=0.007
min	2.003-2.012=-0.008
max	2.161-2.162=-0.001

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.610-1542.630=-0.020
σ	4.040-4.015=0.024
min	1540.603-1540.597=0.005
max	1549.828-1549.804=0.024

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	2.233-2.279=-0.047
σ	0.123-0.200=-0.078
min	2.119-2.099=0.020
max	2.415-2.597=-0.182

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.623-1861.632=-0.009
σ	0.082-0.077=0.005
min	1861.495-1861.515=-0.020
max	1861.701-1861.715=-0.015

*mean*	1735.200-1773.800=-38.600
σ	165.380-206.478=-41.098
min	1501.000-1515.000=-14.000
max	1890.000-1973.000=-83.000

*mean*	3.077-3.272=-0.196
σ	0.246-0.413=-0.167
min	2.866-2.850=0.016
max	3.478-3.752=-0.273

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.578-1.643=-0.065
σ	0.140-0.201=-0.061
min	1.428-1.338=0.091
max	1.742-1.830=-0.088

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.186-446.185=0.001
σ	577.140-577.139=0.000
min	157.615-157.613=0.001
max	1311.896-1311.894=0.002

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	0.536-0.540=-0.003
σ	0.539-0.553=-0.013
min	0.263-0.262=0.001
max	1.346-1.369=-0.023

policies=20

*mean*	1576.417-1576.414=0.003
σ	0.345-0.350=-0.005
min	1576.186-1576.175=0.011
max	1576.930-1576.934=-0.004

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	2.621-2.616=0.005
σ	0.004-0.022=-0.019
min	2.618-2.587=0.031
max	2.626-2.640=-0.014

policies=200

*mean*	15772.208-15772.219=-0.012
σ	0.120-0.078=0.041
min	15772.088-15772.121=-0.033
max	15772.346-15772.313=0.033

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1471.000-1515.000=-44.000
σ	0.000
min	1471.000-1515.000=-44.000
max	1471.000-1515.000=-44.000

*mean*	26.499-26.482=0.016
σ	0.078-0.038=0.041
min	26.406-26.440=-0.034
max	26.597-26.528=0.069