67-continue-tpch-support--perf--debug-info-schema-join - Branch - jzombie/rust-llkv

Improve `information_schema` support

#178Merged

Comparing

67-continue-tpch-support--perf--debug-info-schema-join

(

86d3b67

) with

main

(

e83e855

)

-37%

Improvements: 5

Regressions: 2

Untouched: 68

Skipped: 2

Unknown Walltime execution environment detected

Using the Walltime instrument on standard Hosted Runners will lead to inconsistent data. For the most accurate results, we recommend using CodSpeed Macro Runners: bare-metal machines fine-tuned for performance measurement consistency.

Benchmarks

Skipped (2)

Failed

unsorted_sum_u64

criterion::scan_builder_1M

Regression

-37%

712.8 µs1,137.9 µs

hash_join_no_matches[1000000]

criterion::hash_join_no_matches::1000000

Regression

-15%

215.4 ms253.9 ms

Improved

ingest_mixed_1M[batches=16]

criterion::ingest_mixed_1M::batches=16

+24%

524.4 ms423.7 ms

lowfrag/range/without_index

criterion::index_matrix_1M::lowfrag_range_without_index

+19%

4.6 ms3.8 ms

hash_join_no_matches[100000]

criterion::hash_join_no_matches::100000

+17%

14.5 ms12.4 ms

ingest_mixed_1M[batches=64]

criterion::ingest_mixed_1M::batches=64

+11%

883.9 ms796.1 ms

scan_stream_expr_divide_two

criterion::llkv_table_math_1M

+10%

1.1 ms1 ms

Passed

scan_stream_expr_multiply_two

criterion::llkv_table_math_1M

+10%

1.1 ms1 ms

multi_column_batched

criterion::gather_rows

+9%

1.9 ms1.8 ms

delete1000_full

criterion::slturl_cases

+9%

405.2 ms371 ms

multi_column_sequential

criterion::gather_rows

+9%

1.9 ms1.8 ms

scan_stream_expr_add_one

criterion::llkv_table_math_1M

+8%

1,081.5 µs1,000 µs

select4_full

criterion::slturl_cases

+8%

9.4 s8.7 s

hash_join_anti_join[100000]

criterion::hash_join_anti_join::100000

+7%

4.6 ms4.3 ms

multi_column_batched_with_nulls

criterion::gather_rows

+7%

693.9 µs649 µs

sum_i32_scan_only

criterion::column_store_sum_1M

+7%

52.2 µs48.9 µs

single_column

criterion::gather_rows

+7%

629.5 µs589.9 µs

hash_join_semi_join[10000]

criterion::hash_join_semi_join::10000

+5%

257.8 µs245 µs

lowfrag/full/without_index

criterion::index_matrix_1M::lowfrag_full_without_index

+5%

15.3 ms14.5 ms

lowfrag/full/with_index

criterion::index_matrix_1M::lowfrag_full_with_index

+5%

21.6 ms20.5 ms

scan_sorted_stream_join

criterion::random_probe_u64

+5%

22.2 ms21.2 ms

scan_stream_sum_u64

criterion::llkv_table_math_1M

+5%

108.3 µs103.6 µs

sum_u64_fragmented_scan_only

criterion::column_store_fragmented_1M

+4%

99.2 µs95.3 µs

hash_join_anti_join[10000]

criterion::hash_join_anti_join::10000

+4%

302.3 µs291.2 µs

direct_columnstore_sum

criterion::table_layer_overhead_analysis

+4%

109.1 µs105.3 µs

table_layer_sum

criterion::table_layer_overhead_analysis

+3%

112.3 µs108.8 µs

hash_join_no_matches[1000]

criterion::hash_join_no_matches::1000

+3%

164.6 µs159.6 µs

sum_u64_scan_only

criterion::column_store_sum_1M

+3%

112.5 µs109.3 µs

highfrag/full/with_index

criterion::index_matrix_1M::highfrag_full_with_index

+3%

43.8 ms42.6 ms

hash_join_semi_join[100000]

criterion::hash_join_semi_join::100000

+3%

3.7 ms3.6 ms

highfrag/full/without_index

criterion::index_matrix_1M::highfrag_full_without_index

+3%

15.2 ms14.8 ms

hash_join_many_to_many[100000]

criterion::hash_join_many_to_many::100000

+3%

15.1 ms14.7 ms

sorted_with_row_ids_u64

criterion::scan_builder_1M

+2%

20.8 ms20.3 ms

hash_join_anti_join[1000]

criterion::hash_join_anti_join::1000

+2%

88.2 µs86.3 µs

scan_stream_expr_subtract_one

criterion::llkv_table_math_1M

+2%

1 ms1 ms

highfrag/range/with_index

criterion::index_matrix_1M::highfrag_range_with_index

+2%

3.4 ms3.3 ms

planner_fused_both_case_sensitive

criterion::string_substring_fused_vs_sequential

+2%

19.8 ms19.5 ms

hash_join_many_to_many[10000]

criterion::hash_join_many_to_many::10000

+1%

854.4 µs842.9 µs

hash_join_many_to_many[1000]

criterion::hash_join_many_to_many::1000

+1%

179.5 µs177.5 µs

store_sequential_contains_case_insensitive

criterion::string_substring_fused_vs_sequential

+1%

107.4 ms106.3 ms

scan_unsorted_multiset

criterion::random_probe_u64

+1%

1.7 ms1.7 ms

hash_join_inner_join[100000]

criterion::hash_join_inner_join::100000

+1%

13.2 ms13.1 ms

lowfrag/range/with_index

criterion::index_matrix_1M::lowfrag_range_with_index

+1%

2.1 ms2 ms

hash_join_left_join[1000]

criterion::hash_join_left_join::1000

+1%

154.2 µs153.2 µs

planner_fused_contains_case_insensitive

criterion::string_substring_fused_vs_sequential

+1%

101.5 ms100.8 ms

hash_join_left_join[10000]

criterion::hash_join_left_join::10000

+1%

619.9 µs616.1 µs

storage_fused_contains_case_insensitive

criterion::string_substring_storage_only

84.8 ms84.8 ms

hash_join_no_matches[10000]

criterion::hash_join_no_matches::10000

678.7 µs679.1 µs

storage_fused_both_case_insensitive

criterion::string_substring_storage_only

-1%

84.8 ms85.2 ms

planner_fused_starts_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

20.6 ms20.7 ms

scan_contains_needle_case_insensitive

criterion::string_substring_search

-1%

101.7 ms102.5 ms

hash_join_many_to_many[100]

criterion::hash_join_many_to_many::100

-1%

79 µs79.7 µs

planner_fused_both_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

101 ms101.9 ms

sorted_range_u64

criterion::scan_builder_1M

-1%

23.5 ms23.7 ms

store_sequential_both_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

143.7 ms145.4 ms

storage_sequential_contains_case_insensitive

criterion::string_substring_storage_only

-1%

107.2 ms108.7 ms

hash_join_left_join[100000]

criterion::hash_join_left_join::100000

-1%

8.5 ms8.6 ms

storage_fused_both_case_sensitive

criterion::string_substring_storage_only

-1%

4.8 ms4.9 ms

hash_join_inner_join[1000000]

criterion::hash_join_inner_join::1000000

-2%

292.8 ms297.7 ms

storage_sequential_both_case_sensitive

criterion::string_substring_storage_only

-2%

49.1 ms49.9 ms

storage_sequential_both_case_insensitive

criterion::string_substring_storage_only

-2%

142.8 ms145.4 ms

hash_join_inner_join[1000]

criterion::hash_join_inner_join::1000

-2%

89.9 µs91.7 µs

storage_fused_starts_case_insensitive

criterion::string_substring_storage_only

-2%

4.8 ms4.9 ms

hash_join_inner_join[10000]

criterion::hash_join_inner_join::10000

-2%

637.1 µs652.6 µs

store_sequential_starts_case_insensitive

criterion::string_substring_fused_vs_sequential

-3%

86.3 ms88.6 ms

hash_join_semi_join[1000]

criterion::hash_join_semi_join::1000

-3%

78.3 µs80.5 µs

hash_join_semi_join[1000000]

criterion::hash_join_semi_join::1000000

-3%

45.6 ms46.9 ms

hash_join_anti_join[1000000]

criterion::hash_join_anti_join::1000000

-3%

51.2 ms53 ms

storage_sequential_starts_case_insensitive

criterion::string_substring_storage_only

-4%

86 ms89.8 ms

highfrag/range/without_index

criterion::index_matrix_1M::highfrag_range_without_index

-5%

5.3 ms5.6 ms

ingest_mixed_1M[batches=4]

criterion::ingest_mixed_1M::batches=4

-6%

310.5 ms329 ms

scan_contains_needle_case_sensitive

criterion::string_substring_search

-6%

43.7 ms46.6 ms

hash_join_left_join[1000000]

criterion::hash_join_left_join::1000000

-7%

154.3 ms165.9 ms

ingest_mixed_1M[batches=1]

criterion::ingest_mixed_1M::batches=1

-8%

188.2 ms205.2 ms

store_sequential_both_case_sensitive

criterion::string_substring_fused_vs_sequential

-9%

46.9 ms51.6 ms

Commits

Click on a commit to change the comparison range

Base

main

e83e855

-37.36%

Resolve Clippy warnings

86d3b67

3 days ago

by jzombie

Home Terms Privacy Docs