perf: Seek for dynamic filters which represent ranges#4452
Draft
stuhood wants to merge 8 commits into
Draft
Conversation
stuhood
added
cherry-pick/0.22.x
stuhood
force-pushed
the
stuhood.filter-seeking
branch
from
b1fffc7 to
86a6a27
Compare
![github-actions[bot]](https://avatars.githubusercontent.com/in/15368?s=60&v=4){kind=small}
Contributor
There was a problem hiding this comment.
pg_search 'docs' (25M rows)
Details
| Benchmark suite | Current: 86a6a27 | Previous: d5ce33c | Ratio |
|---|---|---|---|
aggregate_sort |
13370.2510315 median ms |
13353.567489000001 median ms |
1.00 |
aggregate_sort - alternative 1 |
13432.222021000001 median ms |
13358.340693999999 median ms |
1.01 |
distinct_parent_sort |
5937.211566 median ms |
5922.3590525 median ms |
1.00 |
distinct_parent_sort - alternative 1 |
7836.636018 median ms |
7953.2887869999995 median ms |
0.99 |
foreign_filter_local_sort |
533.8347435 median ms |
593.7974570000001 median ms |
0.90 |
foreign_filter_local_sort - alternative 1 |
488.917097 median ms |
500.112858 median ms |
0.98 |
hierarchical_content-no-scores-large |
1931.4149174999998 median ms |
1990.737345 median ms |
0.97 |
hierarchical_content-no-scores-large - alternative 1 |
1886.492765 median ms |
1844.034403 median ms |
1.02 |
hierarchical_content-no-scores-small |
515.1910419999999 median ms |
530.7872175 median ms |
0.97 |
hierarchical_content-no-scores-small - alternative 1 |
1826.1796115000002 median ms |
1872.6670175 median ms |
0.98 |
hierarchical_content-scores-large |
991.8630575 median ms |
1079.748703 median ms |
0.92 |
hierarchical_content-scores-large - alternative 1 |
656.900972 median ms |
632.3470715000001 median ms |
1.04 |
hierarchical_content-scores-large - alternative 2 |
972.5081975 median ms |
1061.0836465000002 median ms |
0.92 |
hierarchical_content-scores-small |
702.1346485 median ms |
719.088273 median ms |
0.98 |
hierarchical_content-scores-small - alternative 1 |
705.113067 median ms |
734.4643075 median ms |
0.96 |
paging-string-max |
12.1333775 median ms |
13.182396999999998 median ms |
0.92 |
paging-string-median |
43.189009999999996 median ms |
41.8594905 median ms |
1.03 |
paging-string-min |
63.4961275 median ms |
59.291281 median ms |
1.07 |
permissioned_search |
1394.5327725000002 median ms |
1464.625852 median ms |
0.95 |
permissioned_search - alternative 1 |
1872.6293799999999 median ms |
1882.9920670000001 median ms |
0.99 |
semi_join_filter |
434.3079375 median ms |
440.99843050000004 median ms |
0.98 |
semi_join_filter - alternative 1 |
346.17468899999994 median ms |
352.5819255 median ms |
0.98 |
semi_join_filter - alternative 2 |
434.417644 median ms |
444.08537 median ms |
0.98 |
semi_join_filter - alternative 3 |
2567.859335 median ms |
2535.2932455 median ms |
1.01 |
This comment was automatically generated by workflow using github-action-benchmark.
stuhood
force-pushed
the
stuhood.filter-seeking
branch
from
86a6a27 to
f02e9dd
Compare
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
1 participant
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Ticket(s) Closed
What
Why
How
Tests