Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.616-54.615=0.001
σ	0.349-0.349=0.000
min	54.483-54.483=-0.000
max	55.609-55.607=0.002

*mean*	417.700-419.000=-1.300
σ	0.483-0.000=0.483
min	417.000-419.000=-2.000
max	418.000-419.000=-1.000

*mean*	0.140-0.138=0.001
σ	0.005-0.004=0.000
min	0.136-0.133=0.002
max	0.149-0.146=0.003

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.785=0.000
σ	0.006-0.007=-0.000
min	43.777-43.778=-0.001
max	43.800-43.797=0.003

*mean*	418.000-419.000=-1.000
σ	0.000
min	418.000-419.000=-1.000
max	418.000-419.000=-1.000

*mean*	0.123-0.126=-0.002
σ	0.005-0.008=-0.002
min	0.119-0.118=0.002
max	0.135-0.141=-0.007

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

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	12.612-12.234=0.378
σ	0.309-0.299=0.010
min	12.187-11.754=0.432
max	13.250-12.650=0.600

op=column_set() on indexed, repeat

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

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	12.435-12.301=0.134
σ	0.620-0.649=-0.029
min	11.501-11.235=0.266
max	13.066-12.874=0.193

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*	7545.000-7556.000=-11.000
σ	0.000
min	7545.000-7556.000=-11.000
max	7545.000-7556.000=-11.000

*mean*	13.413-13.670=-0.256
σ	1.349-1.127=0.223
min	10.777-12.124=-1.346
max	14.853-15.134=-0.282

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.931-41.931=-0.000

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	12.027-11.157=0.870
σ	1.808-1.172=0.636
min	10.286-10.194=0.092
max	14.652-13.512=1.139

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

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

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	8.307-8.103=0.204
σ	0.685-0.292=0.393
min	7.441-7.798=-0.358
max	9.794-8.575=1.219

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

*mean*	26.400-26.401=-0.001
σ	0.002-0.002=-0.000
min	26.399
max	26.403-26.403=-0.000

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	6.471-6.321=0.150
σ	0.598-0.272=0.326
min	6.098-5.776=0.322
max	7.878-6.630=1.248

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

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	5.425-5.292=0.132
σ	0.221-0.138=0.083
min	5.137-5.082=0.055
max	5.896-5.479=0.416

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*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	5.141-5.100=0.041
σ	0.076-0.092=-0.016
min	5.062-4.910=0.152
max	5.268-5.238=0.030

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

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

*mean*	7545.000-7556.000=-11.000
σ	0.000
min	7545.000-7556.000=-11.000
max	7545.000-7556.000=-11.000

*mean*	1057.556-1040.133=17.424
σ	8.899-6.389=2.510
min	1046.807-1029.339=17.468
max	1068.272-1048.726=19.546

op=load_product(), with indexes

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

*mean*	3775.500-3773.375=2.125
σ	1626.165-1632.670=-6.505
min	1929.000-1912.000=17.000
max	5948.000-5951.000=-3.000

*mean*	4354.247-4761.518=-407.271
σ	1314.454-1656.942=-342.488
min	3548.040-3556.383=-8.343
max	7059.705-7610.215=-550.510

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

*mean*	62.078-62.077=0.000
σ	0.002-0.002=0.000
min	62.076
max	62.080

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	84.028-79.691=4.337
σ	9.211-8.650=0.561
min	72.587-71.236=1.351
max	98.079-97.809=0.270

op=vertical_lookup_list() on unindexed missing Int

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

*mean*	7545.000-7556.000=-11.000
σ	0.000
min	7545.000-7556.000=-11.000
max	7545.000-7556.000=-11.000

*mean*	96.581-232.839=-136.258
σ	10.784-381.085=-370.301
min	76.125-82.705=-6.580
max	107.405-1175.644=-1068.239

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*	7545.000-7556.000=-11.000
σ	0.000
min	7545.000-7556.000=-11.000
max	7545.000-7556.000=-11.000

*mean*	149.153-149.327=-0.174
σ	15.283-16.461=-1.178
min	121.994-130.374=-8.380
max	166.217-167.823=-1.606

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

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

*mean*	4259.000-4260.375=-1.375
σ	1887.701-1893.155=-5.454
min	1929.000-1912.000=17.000
max	7545.000-7556.000=-11.000

*mean*	6295.913-6492.602=-196.689
σ	1023.260-1242.482=-219.222
min	4965.987-4961.981=4.006
max	8022.755-8242.575=-219.820

op=vertical_lookup_list() on indexed

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

*mean*	7545.000-7556.000=-11.000
σ	0.000
min	7545.000-7556.000=-11.000
max	7545.000-7556.000=-11.000

*mean*	5373.386-5038.500=334.886
σ	1219.751-894.507=325.244
min	4399.930-4438.597=-38.667
max	7192.033-6772.300=419.733

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.589-172.585=0.004
σ	0.021-0.026=-0.005
min	172.558
max	172.613-172.626=-0.013

*mean*	1929.000-1912.000=17.000
σ	0.000
min	1929.000-1912.000=17.000
max	1929.000-1912.000=17.000

*mean*	358.778-377.357=-18.579
σ	47.360-25.068=22.292
min	269.754-351.544=-81.790
max	405.477-415.279=-9.801

op=pointedIndexFromKvs

rows=400000

*mean*	357.361-357.359=0.002
σ	0.037-0.036=0.001
min	357.321
max	357.400-357.397=0.003

*mean*	1929.000-1912.000=17.000
σ	0.000
min	1929.000-1912.000=17.000
max	1929.000-1912.000=17.000

*mean*	773.133-730.602=42.531
σ	49.469-45.280=4.189
min	654.887-648.778=6.109
max	805.537-786.612=18.925

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.185-1008.188=-0.003
σ	0.880-0.876=0.004
min	1007.685-1007.688=-0.003
max	1011.835-1011.816=0.019

*mean*	1042.350-1063.750=-21.400
σ	305.136-311.423=-6.287
min	548.000-570.000=-22.000
max	1468.000-1519.000=-51.000

*mean*	1.537-1.522=0.015
σ	0.090-0.071=0.019
min	1.451-1.467=-0.016
max	1.782-1.732=0.051

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*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.419-0.422=-0.002
σ	0.136-0.139=-0.003
min	0.336-0.336=-0.001
max	0.660-0.668=-0.008

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.880-0.889=-0.010
σ	0.100-0.092=0.008
min	0.822-0.831=-0.008
max	1.056-1.050=0.006

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.539-0.545=-0.006
σ	0.061-0.048=0.013
min	0.492-0.510=-0.018
max	0.642-0.625=0.018

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.838-0.845=-0.008
σ	0.040-0.032=0.008
min	0.808-0.826=-0.017
max	0.900-0.903=-0.002

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.542-963.551=-0.009
σ	0.032-0.037=-0.004
min	963.523
max	963.598-963.614=-0.016

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.815-0.791=0.024
σ	0.050-0.051=-0.001
min	0.736-0.740=-0.004
max	0.860-0.866=-0.006

name=cdr_enhanced_4k_loc.art

*mean*	884.853-884.853=0.000
σ	0.006-0.008=-0.002
min	884.847
max	884.860-884.865=-0.006

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.724-0.709=0.015
σ	0.035-0.035=0.001
min	0.672-0.675=-0.003
max	0.754-0.746=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.712=-0.002

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	4.235-4.265=-0.030
σ	0.073-0.096=-0.023
min	4.125-4.112=0.014
max	4.484-4.706=-0.222

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	4.259-4.255=0.004
σ	0.127-0.077=0.050
min	4.081-4.121=-0.040
max	5.039-4.491=0.548

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.756-0.749=0.008
σ	0.017-0.017=0.001
min	0.724-0.714=0.011
max	0.859-0.859=-0.001

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.703-0.588=0.114
σ	0.055-0.104=-0.049
min	0.505-0.495=0.010
max	0.812-0.815=-0.003

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.503-297.537=-0.033
σ	0.219-0.208=0.011
min	297.347-297.349=-0.002
max	298.103-298.091=0.012

*mean*	1929.000-1912.000=17.000
σ	0.000
min	1929.000-1912.000=17.000
max	1929.000-1912.000=17.000

*mean*	0.601-0.573=0.029
σ	0.047-0.043=0.004
min	0.518-0.516=0.003
max	0.704-0.627=0.077

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.776-289.774=0.002
σ	0.034-0.032=0.003
min	289.726-289.735=-0.009
max	289.810-289.807=0.003

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.401-0.401=-0.001
σ	0.009-0.012=-0.003
min	0.396-0.395=0.001
max	0.416-0.422=-0.005

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.681-1299.652=0.030
σ	0.084-0.071=0.013
min	1299.606-1299.572=0.034
max	1299.811-1299.721=0.090

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	2.077-2.071=0.006
σ	0.091-0.066=0.025
min	1.988-2.006=-0.018
max	2.223-2.175=0.048

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.627-1542.674=-0.046
σ	4.040-4.024=0.016
min	1540.629-1540.713=-0.084
max	1549.846-1549.866=-0.020

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	2.303-2.410=-0.106
σ	0.170-0.136=0.035
min	2.043-2.281=-0.238
max	2.499-2.614=-0.115

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.624-1861.637=-0.013
σ	0.081-0.065=0.016
min	1861.507-1861.544=-0.037
max	1861.711-1861.702=0.009

*mean*	1749.400-1751.200=-1.800
σ	194.083-170.137=23.946
min	1477.000-1519.000=-42.000
max	1929.000-1912.000=17.000

*mean*	2.998-3.162=-0.164
σ	0.151-0.386=-0.235
min	2.880-2.880=0.000
max	3.247-3.790=-0.543

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.846-1.630=0.216
σ	0.200-0.220=-0.020
min	1.516-1.319=0.197
max	2.042-1.875=0.167

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.147-446.146=0.001
σ	577.065-577.064=0.001
min	157.614-157.613=0.002
max	1311.745-1311.743=0.002

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	0.542-0.517=0.025
σ	0.552-0.509=0.043
min	0.263-0.262=0.001
max	1.370-1.280=0.090

policies=20

*mean*	1576.425-1576.401=0.024
σ	0.350-0.347=0.004
min	1576.189-1576.165=0.023
max	1576.946-1576.916=0.030

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	2.623-2.620=0.003
σ	0.008-0.011=-0.003
min	2.615-2.611=0.004
max	2.633-2.635=-0.002

policies=200

*mean*	15772.229-15772.278=-0.050
σ	0.158-0.160=-0.002
min	15772.113-15772.071=0.042
max	15772.461-15772.461=-0.000

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1468.000-1519.000=-51.000
σ	0.000
min	1468.000-1519.000=-51.000
max	1468.000-1519.000=-51.000

*mean*	26.449-26.489=-0.041
σ	0.052-0.044=0.007
min	26.373-26.432=-0.059
max	26.487-26.538=-0.052