720c09b98418c2c6eb1dba02e502ef6197b725cc

Home / Branches / pablo/nex-166-remove-older-originpolicynanoid-and-remove-maybe-from / 720c09b98418c2c6eb1dba02e502ef6197b725cc

Aggregation: measureAggregations

Factorallocated MiBpeak allocated MiBtime_s
cache=n
dps=1
iters=10
policies=100
mean54.615
σ0.349
min54.483
max55.607
mean419.000
σ0.000
min419.000
max419.000
mean0.138
σ0.004
min0.133
max0.146
cache=y
dps=1
iters=10
policies=100
mean43.785
σ0.007
min43.778
max43.797
mean419.000
σ0.000
min419.000
max419.000
mean0.126
σ0.008
min0.118
max0.141

CSV - indexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on indexed
mean36.618
σ0.002
min36.615
max36.620
mean4260.375
σ1893.155
min1912.000
max7556.000
mean12.234
σ0.299
min11.754
max12.650
op=column_set() on indexed, repeat
mean36.617
σ0.002
min36.616
max36.620
mean4260.375
σ1893.155
min1912.000
max7556.000
mean12.301
σ0.649
min11.235
max12.874
op=table_records(), no indexes
mean41.929
σ0.001
min41.928
max41.932
mean7556.000
σ0.000
min7556.000
max7556.000
mean13.670
σ1.127
min12.124
max15.134
op=table_records(), repeat
mean41.928
σ0.002
min41.927
max41.931
mean4260.375
σ1893.155
min1912.000
max7556.000
mean11.157
σ1.172
min10.194
max13.512
op=vertical_lookup_list() on indexed, after table_records()
mean27.604
σ0.002
min27.603
max27.607
mean4260.375
σ1893.155
min1912.000
max7556.000
mean8.103
σ0.292
min7.798
max8.575
op=vertical_lookup_list() on indexed, after table_records(), repeat
mean26.401
σ0.002
min26.399
max26.403
mean4260.375
σ1893.155
min1912.000
max7556.000
mean6.321
σ0.272
min5.776
max6.630
op=vertical_lookup_row_list() on 2 indexed
mean25.666
σ0.002
min25.664
max25.670
mean4260.375
σ1893.155
min1912.000
max7556.000
mean5.292
σ0.138
min5.082
max5.479
op=vertical_lookup_row_list() on 3 (1 unindexed)
mean25.968
σ0.002
min25.967
max25.971
mean4260.375
σ1893.155
min1912.000
max7556.000
mean5.100
σ0.092
min4.910
max5.238

CSV - loading a lazy table

Factorallocated MiBpeak allocated MiBtime (ms)
op=load_product(), no indexes
mean2524.594
σ0.000
min2524.594
max2524.594
mean7556.000
σ0.000
min7556.000
max7556.000
mean1040.133
σ6.389
min1029.339
max1048.726
op=load_product(), with indexes
mean8744.559
σ0.033
min8744.545
max8744.640
mean3773.375
σ1632.670
min1912.000
max5951.000
mean4761.518
σ1656.942
min3556.383
max7610.215

CSV - unindexed operations

Factorallocated MiBpeak allocated MiBtime (ms)
op=column_set() on unindexed, dense
mean62.077
σ0.002
min62.076
max62.080
mean4260.375
σ1893.155
min1912.000
max7556.000
mean79.691
σ8.650
min71.236
max97.809
op=vertical_lookup_list() on unindexed missing Int
mean40.944
σ0.001
min40.944
max40.945
mean7556.000
σ0.000
min7556.000
max7556.000
mean232.839
σ381.085
min82.705
max1175.644
op=vertical_lookup_row_list() on unindexed small unique Int
mean66.686
σ0.000
min66.685
max66.686
mean7556.000
σ0.000
min7556.000
max7556.000
mean149.327
σ16.461
min130.374
max167.823

CSV - warmup

Factorallocated MiBpeak allocated MiBtime (ms)
op=table_records()
mean11656.833
σ4.317
min11655.305
max11667.517
mean4260.375
σ1893.155
min1912.000
max7556.000
mean6492.602
σ1242.482
min4961.981
max8242.575
op=vertical_lookup_list() on indexed
mean11560.068
σ0.001
min11560.066
max11560.069
mean7556.000
σ0.000
min7556.000
max7556.000
mean5038.500
σ894.507
min4438.597
max6772.300

CSV internal benchmark: pointedIndexFromKvs

Factorallocated MiBpeak allocated MiBtime (ms)
op=pointedIndexFromKvs
rows=200000
mean172.585
σ0.026
min172.558
max172.626
mean1912.000
σ0.000
min1912.000
max1912.000
mean377.357
σ25.068
min351.544
max415.279
op=pointedIndexFromKvs
rows=400000
mean357.359
σ0.036
min357.321
max357.397
mean1912.000
σ0.000
min1912.000
max1912.000
mean730.602
σ45.280
min648.778
max786.612

Marine Hull: transactPolicy

Factorallocated MiBpeak allocated MiBtime
datapoints=1
iterations=20
mean1008.188
σ0.876
min1007.688
max1011.816
mean1063.750
σ311.423
min570.000
max1519.000
mean1.522
σ0.071
min1.467
max1.732

Parser: Comma Sep

Factorallocated MiBpeak allocated MiBtime (ms)
name=ambiguous_item.art
mean0.883
σ0.002
min0.881
max0.886
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.422
σ0.139
min0.336
max0.668
name=error_case.art
mean2.333
σ0.003
min2.332
max2.337
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.889
σ0.092
min0.831
max1.050
name=heavy_item.art
mean1.521
σ0.002
min1.520
max1.524
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.545
σ0.048
min0.510
max0.625
name=nested_use.art
mean2.355
σ0.002
min2.355
max2.358
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.845
σ0.032
min0.826
max0.903

Parser: Real World

Factorallocated MiBpeak allocated MiBtime (sec)
name=aon_gpf25_7k_loc.art
mean963.551
σ0.037
min963.523
max963.614
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.791
σ0.051
min0.740
max0.866
name=cdr_enhanced_4k_loc.art
mean884.853
σ0.008
min884.847
max884.865
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.709
σ0.035
min0.675
max0.746

Parser: Record Parsing

Factorallocated MiBpeak allocated MiBtime (ms)
name=record_render_large_success.art
mean7.706
σ0.002
min7.705
max7.712
mean1519.000
σ0.000
min1519.000
max1519.000
mean4.265
σ0.096
min4.112
max4.706
name=record_render_large_syntax_err.art
mean7.655
σ0.002
min7.654
max7.658
mean1519.000
σ0.000
min1519.000
max1519.000
mean4.255
σ0.077
min4.121
max4.491
name=record_render_success.art
mean2.288
σ0.002
min2.287
max2.291
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.749
σ0.017
min0.714
max0.859
name=record_render_syntax_err.art
mean2.163
σ0.002
min2.163
max2.166
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.588
σ0.104
min0.495
max0.815

SoV import

Factorallocated MiBpeak allocated MiBtime_s
iters=10
rows=1000
mean297.537
σ0.208
min297.349
max298.091
mean1912.000
σ0.000
min1912.000
max1912.000
mean0.573
σ0.043
min0.516
max0.627

Workflow: transactPolicy

Factorallocated MiBpeak allocated MiBtime
iters=5
new-facts=1
prior-facts=1
mean289.774
σ0.032
min289.735
max289.807
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.401
σ0.012
min0.395
max0.422
iters=5
new-facts=1
prior-facts=6402
mean1299.652
σ0.071
min1299.572
max1299.721
mean1519.000
σ0.000
min1519.000
max1519.000
mean2.071
σ0.066
min2.006
max2.175
iters=5
new-facts=6402
prior-facts=1
mean1542.674
σ4.024
min1540.713
max1549.866
mean1519.000
σ0.000
min1519.000
max1519.000
mean2.410
σ0.136
min2.281
max2.614
iters=5
new-facts=6402
prior-facts=6402
mean1861.637
σ0.065
min1861.544
max1861.702
mean1751.200
σ170.137
min1519.000
max1912.000
mean3.162
σ0.386
min2.880
max3.790

newProductH/cdr_auton/broker

Factortime_s
iterations=5
mean1.630
σ0.220
min1.319
max1.875

policy addition benchmark

Factorallocated MiBdb queriespeak allocated MiBtime
policies=2
mean446.146
σ577.064
min157.613
max1311.743
mean96.250
σ8.500
min92.000
max109.000
mean1519.000
σ0.000
min1519.000
max1519.000
mean0.517
σ0.509
min0.262
max1.280
policies=20
mean1576.401
σ0.347
min1576.165
max1576.916
mean920.000
σ0.000
min920.000
max920.000
mean1519.000
σ0.000
min1519.000
max1519.000
mean2.620
σ0.011
min2.611
max2.635
policies=200
mean15772.278
σ0.160
min15772.071
max15772.461
mean9200.000
σ0.000
min9200.000
max9200.000
mean1519.000
σ0.000
min1519.000
max1519.000
mean26.489
σ0.044
min26.432
max26.538