Compare commits

Aggregation: measureAggregations

Factor

allocated MiB

peak allocated MiB

time_s

cache=n

dps=1

iters=10

policies=100

*mean*	54.617-54.618=-0.001
σ	0.350-0.350=-0.001
min	54.474-54.487=-0.013
max	55.611-55.614=-0.003

*mean*	414.700-415.000=-0.300
σ	0.483-0.000=0.483
min	414.000-415.000=-1.000
max	415.000

*mean*	0.138-0.143=-0.005
σ	0.005-0.004=0.001
min	0.130-0.140=-0.010
max	0.146-0.150=-0.004

cache=y

dps=1

iters=10

policies=100

*mean*	43.785-43.786=-0.000
σ	0.006-0.006=0.000
min	43.774-43.779=-0.005
max	43.793-43.801=-0.008

*mean*	415.000
σ	0.000
min	415.000
max	415.000

*mean*	0.124-0.123=0.001
σ	0.004-0.006=-0.002
min	0.120-0.117=0.003
max	0.131-0.134=-0.002

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-36.616=-0.000
max	36.620-36.620=0.000

*mean*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	12.220-12.055=0.165
σ	0.274-0.137=0.137
min	11.733-11.813=-0.079
max	12.684-12.219=0.465

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*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	12.230-12.095=0.134
σ	0.499-0.721=-0.222
min	11.464-11.175=0.288
max	12.848-13.229=-0.381

op=table_records(), no indexes

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

*mean*	6041.000-7543.000=-1502.000
σ	0.000
min	6041.000-7543.000=-1502.000
max	6041.000-7543.000=-1502.000

*mean*	13.024-13.984=-0.960
σ	1.095-1.172=-0.077
min	11.143-12.364=-1.221
max	14.544-15.866=-1.322

op=table_records(), repeat

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

*mean*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	12.300-11.726=0.573
σ	1.764-2.076=-0.312
min	10.348-10.131=0.218
max	14.985-15.127=-0.142

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
max	27.607-27.609=-0.002

*mean*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	8.341-8.135=0.206
σ	0.408-0.405=0.003
min	7.896-7.523=0.373
max	8.799-8.552=0.247

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

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

*mean*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	6.389-6.036=0.352
σ	0.214-0.292=-0.077
min	6.073-5.683=0.390
max	6.632-6.511=0.122

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*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	5.485-5.272=0.212
σ	0.082-0.134=-0.052
min	5.407-5.037=0.370
max	5.617-5.407=0.210

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*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	5.303-5.169=0.134
σ	0.088-0.171=-0.083
min	5.156-4.987=0.169
max	5.431-5.541=-0.109

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

op=load_product(), no indexes

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

*mean*	6041.000-7543.000=-1502.000
σ	0.000
min	6041.000-7543.000=-1502.000
max	6041.000-7543.000=-1502.000

*mean*	1536.313-1045.233=491.081
σ	787.997-5.036=782.961
min	1032.390-1037.939=-5.549
max	2933.180-1053.934=1879.246

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.640-8744.640=-0.001

*mean*	3819.625-3767.125=52.500
σ	1647.380-1632.038=15.342
min	1980.000-1906.000=74.000
max	6041.000-5942.000=99.000

*mean*	4561.645-4700.212=-138.567
σ	1488.192-1653.118=-164.926
min	3537.848-3518.721=19.127
max	7543.589-7611.528=-67.939

CSV - unindexed operations

Factor

allocated MiB

peak allocated MiB

time (ms)

op=column_set() on unindexed, dense

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

*mean*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	81.547-81.012=0.535
σ	10.940-10.420=0.520
min	70.126-70.323=-0.197
max	96.506-100.593=-4.087

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*	6041.000-7543.000=-1502.000
σ	0.000
min	6041.000-7543.000=-1502.000
max	6041.000-7543.000=-1502.000

*mean*	96.726-236.079=-139.353
σ	9.106-383.081=-373.975
min	82.588-86.399=-3.811
max	107.232-1183.934=-1076.702

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

*mean*	6041.000-7543.000=-1502.000
σ	0.000
min	6041.000-7543.000=-1502.000
max	6041.000-7543.000=-1502.000

*mean*	220.991-153.043=67.948
σ	216.062-13.022=203.040
min	126.166-135.858=-9.692
max	754.772-167.964=586.809

CSV - warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

op=table_records()

*mean*	11656.832-11656.833=-0.001
σ	4.317-4.317=0.000
min	11655.305
max	11667.517-11667.517=-0.000

*mean*	4099.500-4255.000=-155.500
σ	1568.832-1890.468=-321.637
min	1980.000-1906.000=74.000
max	6041.000-7543.000=-1502.000

*mean*	6393.343-6270.979=122.363
σ	1301.605-1013.191=288.414
min	4908.939-4944.491=-35.552
max	8370.281-7500.995=869.285

op=vertical_lookup_list() on indexed

*mean*	11560.069-11560.065=0.003
σ	0.001-0.001=-0.001
min	11560.067-11560.064=0.003
max	11560.069-11560.069=0.001

*mean*	6041.000-7543.000=-1502.000
σ	0.000
min	6041.000-7543.000=-1502.000
max	6041.000-7543.000=-1502.000

*mean*	6610.741-5357.525=1253.215
σ	1285.596-1341.719=-56.124
min	4429.995-4352.236=77.759
max	8020.944-7443.930=577.013

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

op=pointedIndexFromKvs

rows=200000

*mean*	172.582-172.584=-0.003
σ	0.027-0.026=0.000
min	172.558
max	172.626-172.626=-0.000

*mean*	1980.000-1906.000=74.000
σ	0.000
min	1980.000-1906.000=74.000
max	1980.000-1906.000=74.000

*mean*	343.833-363.098=-19.265
σ	30.640-44.801=-14.161
min	297.992-265.273=32.720
max	394.499-407.409=-12.910

op=pointedIndexFromKvs

rows=400000

*mean*	357.365-357.358=0.007
σ	0.042-0.035=0.007
min	357.321
max	357.420-357.393=0.027

*mean*	1980.000-1906.000=74.000
σ	0.000
min	1980.000-1906.000=74.000
max	1980.000-1906.000=74.000

*mean*	759.616-743.354=16.262
σ	53.930-67.078=-13.149
min	629.715-637.480=-7.765
max	801.518-799.626=1.891

Marine Hull: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

datapoints=1

iterations=20

*mean*	1008.185-1008.185=-0.001
σ	0.905-0.918=-0.012
min	1007.715-1007.713=0.002
max	1011.953-1012.008=-0.055

*mean*	1040.800-1039.000=1.800
σ	306.732-293.507=13.225
min	555.000-543.000=12.000
max	1472.000-1436.000=36.000

*mean*	1.577-1.527=0.050
σ	0.151-0.113=0.038
min	1.456-1.327=0.129
max	2.026-1.872=0.154

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*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.416-0.442=-0.027
σ	0.134-0.169=-0.035
min	0.334-0.337=-0.003
max	0.654-0.742=-0.088

name=error_case.art

*mean*	2.333
σ	0.003
min	2.332
max	2.337

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.894-0.935=-0.041
σ	0.086-0.172=-0.085
min	0.833-0.837=-0.004
max	1.044-1.240=-0.197

name=heavy_item.art

*mean*	1.521
σ	0.002
min	1.520
max	1.524

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.561-0.562=-0.001
σ	0.036-0.043=-0.007
min	0.537-0.531=0.006
max	0.622-0.635=-0.013

name=nested_use.art

*mean*	2.355
σ	0.002
min	2.355
max	2.358

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.842-0.852=-0.010
σ	0.049-0.044=0.005
min	0.803-0.817=-0.014
max	0.923-0.925=-0.001

Parser: Real World

Factor

allocated MiB

peak allocated MiB

time (sec)

name=aon_gpf25_7k_loc.art

*mean*	963.541-963.543=-0.002
σ	0.032-0.026=0.006
min	963.523
max	963.597-963.586=0.011

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.804-0.781=0.023
σ	0.046-0.053=-0.007
min	0.741-0.694=0.048
max	0.864-0.824=0.040

name=cdr_enhanced_4k_loc.art

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

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.731-0.732=-0.001
σ	0.029-0.022=0.007
min	0.679-0.692=-0.013
max	0.748-0.745=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.713-7.711=0.003

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	3.626-4.227=-0.600
σ	0.083-0.082=0.001
min	3.443-4.065=-0.622
max	3.961-4.521=-0.560

name=record_render_large_syntax_err.art

*mean*	7.655
σ	0.002
min	7.654
max	7.658

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	3.547-4.207=-0.660
σ	0.071-0.061=0.010
min	3.405-4.099=-0.694
max	3.852-4.399=-0.547

name=record_render_success.art

*mean*	2.288
σ	0.002
min	2.287
max	2.291

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.756-0.764=-0.008
σ	0.019-0.016=0.003
min	0.721-0.737=-0.016
max	0.858-0.856=0.002

name=record_render_syntax_err.art

*mean*	2.163
σ	0.002
min	2.163
max	2.166

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.715-0.721=-0.006
σ	0.013-0.018=-0.005
min	0.689-0.691=-0.002
max	0.760-0.805=-0.045

SoV import

Factor

allocated MiB

peak allocated MiB

time_s

iters=10

rows=1000

*mean*	297.440-297.521=-0.081
σ	0.233-0.148=0.085
min	297.278-297.255=0.023
max	298.086-297.844=0.242

*mean*	1980.000-1906.000=74.000
σ	0.000
min	1980.000-1906.000=74.000
max	1980.000-1906.000=74.000

*mean*	0.568-0.563=0.005
σ	0.043-0.050=-0.007
min	0.513-0.507=0.006
max	0.622-0.627=-0.005

Workflow: transactPolicy

Factor

allocated MiB

peak allocated MiB

time

iters=5

new-facts=1

prior-facts=1

*mean*	289.765-289.774=-0.010
σ	0.045-0.037=0.008
min	289.720-289.725=-0.005
max	289.815-289.813=0.002

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.408-0.405=0.003
σ	0.012-0.014=-0.002
min	0.393-0.394=-0.000
max	0.419-0.426=-0.007

iters=5

new-facts=1

prior-facts=6402

*mean*	1299.690-1299.600=0.091
σ	0.092-0.086=0.006
min	1299.586-1299.492=0.094
max	1299.823-1299.711=0.112

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	2.268-1.875=0.393
σ	0.081-0.070=0.011
min	2.167-1.803=0.363
max	2.331-1.958=0.372

iters=5

new-facts=6402

prior-facts=1

*mean*	1542.658-1542.601=0.057
σ	4.013-4.042=-0.029
min	1540.697-1540.582=0.115
max	1549.832-1549.825=0.007

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	2.284-2.244=0.040
σ	0.125-0.168=-0.043
min	2.145-2.124=0.021
max	2.469-2.537=-0.068

iters=5

new-facts=6402

prior-facts=6402

*mean*	1861.630-1861.632=-0.002
σ	0.059-0.055=0.003
min	1861.554-1861.580=-0.026
max	1861.698-1861.714=-0.015

*mean*	1766.400-1741.200=25.200
σ	224.654-176.164=48.490
min	1472.000-1495.000=-23.000
max	1980.000-1906.000=74.000

*mean*	3.246-2.941=0.304
σ	0.363-0.215=0.148
min	2.855-2.742=0.113
max	3.692-3.306=0.386

newProductH/cdr_auton/broker

Factor

time_s

iterations=5

*mean*	1.840-1.785=0.055
σ	0.025-0.221=-0.196
min	1.811-1.398=0.414
max	1.870-1.939=-0.069

policy addition benchmark

Factor

allocated MiB

db queries

peak allocated MiB

time

policies=2

*mean*	446.185-446.184=0.002
σ	577.140-577.140=-0.000
min	157.614-157.611=0.003
max	1311.895-1311.894=0.001

*mean*	96.250
σ	8.500
min	92.000
max	109.000

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	0.539-0.539=0.001
σ	0.543-0.557=-0.015
min	0.266-0.258=0.008
max	1.353-1.374=-0.022

policies=20

*mean*	1576.406-1576.419=-0.013
σ	0.334-0.345=-0.011
min	1576.183-1576.185=-0.001
max	1576.903-1576.931=-0.028

*mean*	920.000
σ	0.000
min	920.000
max	920.000

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	2.620-2.613=0.008
σ	0.016-0.033=-0.017
min	2.599-2.579=0.019
max	2.635-2.658=-0.023

policies=200

*mean*	15772.240-15772.192=0.048
σ	0.170-0.105=0.065
min	15772.074-15772.092=-0.018
max	15772.476-15772.291=0.184

*mean*	9200.000
σ	0.000
min	9200.000
max	9200.000

*mean*	1472.000-1436.000=36.000
σ	0.000
min	1472.000-1436.000=36.000
max	1472.000-1436.000=36.000

*mean*	26.425-26.310=0.116
σ	0.127-0.104=0.023
min	26.274-26.224=0.050
max	26.585-26.455=0.130