Compare commits

CSV - column_set() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on indexed

rows=200000

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	13.376
σ	0.458
min	12.653
max	13.982

iterations=10

operation_display=column_set() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=column_set.indexed.4

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	13.240
σ	0.326
min	12.550
max	13.672

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.783
σ	0.002
min	36.781
max	36.785

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	13.009
σ	0.547
min	12.223
max	13.891

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=column_set.indexed.repeat.4

*mean*	36.783
σ	0.003
min	36.781
max	36.788

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	92.028
σ	205.651
min	12.215
max	663.999

CSV - column_set() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.241
σ	0.000
min	62.241
max	62.241

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	106.990
σ	14.383
min	79.469
max	118.602

iterations=10

operation_display=column_set() on unindexed, dense, repeat

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=column_set.unindexed.dense.repeat.1

*mean*	62.241
σ	0.000
min	62.241
max	62.242

*mean*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	102.447
σ	14.949
min	74.469
max	120.625

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.832
σ	0.002
min	70.830
max	70.834

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	139.831
σ	5.166
min	131.539
max	148.728

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=column_set.unindexed.sparse.repeat.3

*mean*	70.832
σ	0.002
min	70.830
max	70.834

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	137.802
σ	6.449
min	122.263
max	145.754

CSV - column_set(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	15109.841
σ	3.993
min	15108.577
max	15121.206

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	10337.854
σ	1966.407
min	6610.779
max	12033.518

iterations=10

operation_display=column_set() on unindexed, dense

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=column_set.unindexed.dense.1

*mean*	15109.841
σ	3.993
min	15108.577
max	15121.205

*mean*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	9497.259
σ	1930.396
min	6742.339
max	11727.827

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.904
σ	0.005
min	14060.899
max	14060.910

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	6838.172
σ	1454.580
min	5462.941
max	8935.807

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

scenario_id=no_indexes/benchmark3

step_id=column_set.unindexed.sparse.3

*mean*	14060.903
σ	0.004
min	14060.899
max	14060.912

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	6634.859
σ	1660.548
min	5478.495
max	10260.077

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product()

rows=200000

*mean*	8744.667
σ	0.418
min	8744.531
max	8745.856

*mean*	4688.300
σ	2487.452
min	1051.000
max	8381.000

*mean*	4951.119
σ	1538.749
min	3497.933
max	7292.302

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=load_product.1

*mean*	8744.667
σ	0.417
min	8744.531
max	8745.854

*mean*	4844.000
σ	2511.652
min	1043.000
max	8619.000

*mean*	4531.465
σ	1320.007
min	3503.270
max	6734.436

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=load_product.2

*mean*	8744.534
σ	0.003
min	8744.530
max	8744.539

*mean*	8619.000
σ	0.000
min	8619.000
max	8619.000

*mean*	4213.319
σ	1143.837
min	3500.468
max	6226.504

iterations=10

operation_display=load_product()

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=load_product.4.mixed_indexes

*mean*	8744.535
σ	0.003
min	8744.531
max	8744.540

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	4870.190
σ	1442.789
min	3507.968
max	7128.090

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.584

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	1091.560
σ	144.192
min	1034.767
max	1501.659

iterations=10

operation_display=load_product(), no indexes

rows=200000

scenario_id=no_indexes/benchmark3

step_id=load_product.3.no_indexes

*mean*	2524.583
σ	0.004
min	2524.579
max	2524.591

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	1423.374
σ	833.068
min	1021.510
max	3366.740

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	42.069
σ	0.002
min	42.066
max	42.072

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	14.443
σ	1.338
min	11.146
max	15.529

iterations=10

operation_display=table_records()

rows=200000

scenario_id=no_indexes/benchmark3

step_id=table_records.3

*mean*	42.069
σ	0.002
min	42.066
max	42.071

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	14.085
σ	1.758
min	11.118
max	16.261

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	42.067
σ	0.002
min	42.066
max	42.070

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	12.917
σ	1.891
min	11.308
max	15.826

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=table_records.repeat.2

*mean*	42.068
σ	0.002
min	42.066
max	42.071

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	13.233
σ	1.564
min	11.740
max	16.543

iterations=10

operation_display=table_records(), repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=table_records.repeat.3

*mean*	42.069
σ	0.002
min	42.066
max	42.071

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	12.669
σ	1.525
min	10.752
max	15.342

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.407
σ	0.003
min	15088.403
max	15088.411

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	9611.924
σ	2057.889
min	6640.943
max	11646.023

iterations=10

operation_display=table_records()

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=table_records.2

*mean*	15088.408
σ	0.003
min	15088.403
max	15088.413

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	9394.319
σ	1998.389
min	6604.096
max	11476.951

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.567
σ	0.002
min	26.565
max	26.569

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	7.292
σ	0.350
min	6.594
max	7.789

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=vertical_lookup_list.indexed.repeat.1

*mean*	26.567
σ	0.002
min	26.565
max	26.569

*mean*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	7.387
σ	0.401
min	6.613
max	7.817

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_list.indexed.repeat.2

*mean*	26.567
σ	0.002
min	26.565
max	26.569

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	6.896
σ	0.889
min	6.094
max	8.985

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=vertical_lookup_list.indexed.repeat.4

*mean*	26.567
σ	0.003
min	26.565
max	26.572

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	8.292
σ	0.298
min	7.732
max	8.575

CSV - vertical_lookup_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	41.112
σ	0.002
min	41.109
max	41.116

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	204.494
σ	330.404
min	86.903
max	1144.653

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.missing_int.3

*mean*	41.111
σ	0.002
min	41.110
max	41.114

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	95.035
σ	17.050
min	64.817
max	108.296

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	41.112
σ	0.002
min	41.109
max	41.114

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	98.172
σ	8.729
min	81.567
max	106.874

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.missing_int.repeat.3

*mean*	41.112
σ	0.002
min	41.109
max	41.114

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	94.218
σ	18.074
min	64.363
max	109.670

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	41.116
σ	0.002
min	41.115
max	41.120

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	100.449
σ	6.611
min	87.241
max	105.997

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.tail_unique_int.repeat.3

*mean*	41.117
σ	0.002
min	41.115
max	41.120

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	194.064
σ	303.501
min	72.054
max	1056.997

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	27.771
σ	0.003
min	27.769
max	27.778

*mean*	5086.500
σ	2509.664
min	1297.000
max	8381.000

*mean*	9.948
σ	0.652
min	8.829
max	10.568

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark1

step_id=vertical_lookup_list.indexed.1

*mean*	27.771
σ	0.003
min	27.769
max	27.778

*mean*	5218.400
σ	2577.148
min	1268.000
max	8619.000

*mean*	9.759
σ	0.718
min	8.714
max	10.499

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_list.indexed.2

*mean*	27.771
σ	0.002
min	27.769
max	27.773

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	9.157
σ	0.802
min	8.443
max	11.052

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	41.117
σ	0.002
min	41.114
max	41.119

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	100.917
σ	6.958
min	86.917
max	106.360

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_list.unindexed.tail_unique_int.3

*mean*	41.117
σ	0.002
min	41.114
max	41.122

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	167.321
σ	207.315
min	76.031
max	756.651

CSV - vertical_lookup_list(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	15074.110
σ	0.003
min	15074.106
max	15074.114

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	9323.317
σ	1967.760
min	6560.235
max	12186.100

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

scenario_id=mixed_indexes/benchmark4

step_id=vertical_lookup_list.indexed.4

*mean*	15074.109
σ	0.002
min	15074.106
max	15074.113

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	10263.945
σ	2139.286
min	6553.331
max	12353.869

CSV - vertical_lookup_row_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.801
σ	0.002
min	25.798
max	25.804

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.297
σ	0.102
min	5.138
max	5.423

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.two_indexed.2

*mean*	25.801
σ	0.003
min	25.798
max	25.806

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.431
σ	0.612
min	5.053
max	7.100

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.796
σ	0.002
min	25.793
max	25.798

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.224
σ	0.169
min	4.939
max	5.412

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.two_indexed.repeat.2

*mean*	25.795
σ	0.002
min	25.793
max	25.797

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.392
σ	0.622
min	4.951
max	7.095

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	26.100
σ	0.002
min	26.097
max	26.102

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.280
σ	0.145
min	4.972
max	5.441

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.three_one_unindexed.2

*mean*	26.101
σ	0.003
min	26.097
max	26.106

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.460
σ	0.586
min	5.028
max	7.054

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	26.099
σ	0.002
min	26.097
max	26.101

*mean*	8523.300
σ	449.992
min	8381.000
max	9804.000

*mean*	5.326
σ	0.161
min	4.968
max	5.586

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

scenario_id=mixed_indexes/benchmark2

step_id=vertical_lookup_row_list.three_one_unindexed.repeat.2

*mean*	26.099
σ	0.002
min	26.097
max	26.101

*mean*	8714.500
σ	301.998
min	8619.000
max	9574.000

*mean*	5.380
σ	0.580
min	4.902
max	6.957

CSV - vertical_lookup_row_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.839
σ	0.002
min	66.837
max	66.841

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	150.105
σ	14.672
min	118.053
max	163.336

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_row_list.unindexed.small_unique_int.3

*mean*	66.839
σ	0.002
min	66.837
max	66.841

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	144.012
σ	24.091
min	105.871
max	165.032

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.839
σ	0.002
min	66.837
max	66.843

*mean*	9804.000
σ	0.000
min	9804.000
max	9804.000

*mean*	203.688
σ	169.573
min	119.935
max	684.620

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

scenario_id=no_indexes/benchmark3

step_id=vertical_lookup_row_list.unindexed.small_unique_int.repeat.3

*mean*	66.839
σ	0.002
min	66.837
max	66.841

*mean*	9574.000
σ	0.000
min	9574.000
max	9574.000

*mean*	144.580
σ	23.999
min	107.133
max	167.556

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

benchmark=pointed_index_from_kvs

iterations=10

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	555.000
σ	4.830
min	548.000
max	558.000

*mean*	769.093
σ	57.009
min	632.951
max	827.347

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	557.600
σ	4.427
min	545.000
max	559.000

*mean*	757.670
σ	60.162
min	637.075
max	805.263