Merged
Conversation
7350f6f to
92c5887
Compare
Contributor
There was a problem hiding this comment.
pg_search 'logs' Query Performance
Details
| Benchmark suite | Current: 92c5887 | Previous: 70739df | Ratio |
|---|---|---|---|
bucket-expr-filter |
7950.4439999999995 median ms |
7910.8955 median ms |
1.00 |
bucket-expr-filter - alternative 1 |
7900.507 median ms |
7857.659 median ms |
1.01 |
bucket-numeric-filter |
1882.2245 median ms |
1938.9365 median ms |
0.97 |
bucket-numeric-filter - alternative 1 |
410.1445 median ms |
418.304 median ms |
0.98 |
bucket-numeric-filter - alternative 2 |
95.02199999999999 median ms |
94.4365 median ms |
1.01 |
bucket-numeric-filter - alternative 3 |
414.523 median ms |
417.624 median ms |
0.99 |
bucket-numeric-filter - alternative 4 |
545.2915 median ms |
725.236 median ms |
0.75 |
bucket-numeric-nofilter |
1878.588 median ms |
1936.3245000000002 median ms |
0.97 |
bucket-numeric-nofilter - alternative 1 |
409.6365 median ms |
416.839 median ms |
0.98 |
bucket-numeric-nofilter - alternative 2 |
96.92099999999999 median ms |
96.325 median ms |
1.01 |
bucket-numeric-nofilter - alternative 3 |
410.038 median ms |
417.1725 median ms |
0.98 |
bucket-numeric-nofilter - alternative 4 |
547.155 median ms |
726.775 median ms |
0.75 |
bucket-string-filter |
2870.379 median ms |
2917.5825 median ms |
0.98 |
bucket-string-filter - alternative 1 |
377.414 median ms |
381.80550000000005 median ms |
0.99 |
bucket-string-filter - alternative 2 |
67.6995 median ms |
64.8135 median ms |
1.04 |
bucket-string-filter - alternative 3 |
380.135 median ms |
382.999 median ms |
0.99 |
bucket-string-filter - alternative 4 |
503.318 median ms |
474.6775 median ms |
1.06 |
bucket-string-nofilter |
2883.558 median ms |
2909.2780000000002 median ms |
0.99 |
bucket-string-nofilter - alternative 1 |
378.284 median ms |
380.998 median ms |
0.99 |
bucket-string-nofilter - alternative 2 |
66.96000000000001 median ms |
63.9415 median ms |
1.05 |
bucket-string-nofilter - alternative 3 |
380.0335 median ms |
383.876 median ms |
0.99 |
bucket-string-nofilter - alternative 4 |
503.938 median ms |
474.4975 median ms |
1.06 |
cardinality |
14827.047 median ms |
14860.533 median ms |
1.00 |
cardinality - alternative 1 |
1812.3845000000001 median ms |
1857.7775000000001 median ms |
0.98 |
cardinality - alternative 2 |
408.625 median ms |
417.92449999999997 median ms |
0.98 |
cardinality - alternative 3 |
95.1405 median ms |
94.47649999999999 median ms |
1.01 |
cardinality - alternative 4 |
414.397 median ms |
418.20799999999997 median ms |
0.99 |
cardinality - alternative 5 |
418.70349999999996 median ms |
419.6545 median ms |
1.00 |
count-filter |
210.0485 median ms |
212.43599999999998 median ms |
0.99 |
count-filter - alternative 1 |
146.1045 median ms |
147.4045 median ms |
0.99 |
count-filter - alternative 2 |
88.04 median ms |
86.92599999999999 median ms |
1.01 |
count-filter - alternative 3 |
150.747 median ms |
150.2735 median ms |
1.00 |
count-filter - alternative 4 |
148.103 median ms |
148.79500000000002 median ms |
1.00 |
count-nofilter |
682.783 median ms |
704.753 median ms |
0.97 |
count-nofilter - alternative 1 |
422.19399999999996 median ms |
429.351 median ms |
0.98 |
count-nofilter - alternative 2 |
153.67849999999999 median ms |
155.16899999999998 median ms |
0.99 |
count-nofilter - alternative 3 |
422.62850000000003 median ms |
432.994 median ms |
0.98 |
count-nofilter - alternative 4 |
423.837 median ms |
431.382 median ms |
0.98 |
filtered-highcard |
5.91 median ms |
5.7425 median ms |
1.03 |
filtered-lowcard |
5.743 median ms |
5.811 median ms |
0.99 |
filtered_json-range |
7.596 median ms |
7.3855 median ms |
1.03 |
filtered_json |
5.985 median ms |
6.013 median ms |
1.00 |
highlighting |
8.4365 median ms |
8.7625 median ms |
0.96 |
regex-and-heap |
5983.961 median ms |
5987.6615 median ms |
1.00 |
top_n-agg-avg |
561.51 median ms |
562.633 median ms |
1.00 |
top_n-agg-bucket-string |
522.2655 median ms |
522.222 median ms |
1.00 |
top_n-agg-count |
578.7315 median ms |
568.2235000000001 median ms |
1.02 |
top_n-compound |
75.8255 median ms |
78.8695 median ms |
0.96 |
top_n-numeric-highcard |
57.0045 median ms |
60.643 median ms |
0.94 |
top_n-numeric-lowcard |
42.311 median ms |
45.602999999999994 median ms |
0.93 |
top_n-score-asc |
86.995 median ms |
111.249 median ms |
0.78 |
top_n-score-desc |
86.6685 median ms |
95.788 median ms |
0.90 |
top_n-string |
43.888000000000005 median ms |
46.2425 median ms |
0.95 |
This comment was automatically generated by workflow using github-action-benchmark.
Contributor
There was a problem hiding this comment.
pg_search 'docs' Query Performance
Details
| Benchmark suite | Current: 92c5887 | Previous: 70739df | Ratio |
|---|---|---|---|
hierarchical_content-no-scores-large |
1197.8200000000002 median ms |
1229.0355 median ms |
0.97 |
hierarchical_content-no-scores-small |
650.262 median ms |
652.2065 median ms |
1.00 |
hierarchical_content-scores-large |
1503.308 median ms |
1516.7185 median ms |
0.99 |
hierarchical_content-scores-large - alternative 1 |
708.9685 median ms |
721.4005 median ms |
0.98 |
hierarchical_content-scores-small |
677.9255 median ms |
684.616 median ms |
0.99 |
line_items-distinct |
897.2945 median ms |
1279.9275 median ms |
0.70 |
paging-string-max |
26252.084 median ms |
31343.816 median ms |
0.84 |
paging-string-median |
26446.629 median ms |
31495.9985 median ms |
0.84 |
paging-string-min |
26477.7985 median ms |
31705.3675 median ms |
0.84 |
This comment was automatically generated by workflow using github-action-benchmark.
92c5887 to
71a896d
Compare
mdashti
approved these changes
Jan 15, 2026
stuhood
added a commit
that referenced
this pull request
Jan 20, 2026
Incorporate a [Jan 12th Tantivy rebase](paradedb/tantivy#93) (from [794ff1ffc9a7169ff7e41fba89a23d13afb358f4](https://github.com/quickwit-oss/tantivy/commits/794ff1ffc9a7169ff7e41fba89a23d13afb358f4) to [c92e831dde738163054729a2276ed74dfa1a8eee](https://github.com/quickwit-oss/tantivy/commits/c92e831dde738163054729a2276ed74dfa1a8eee)) To stay up to date, and pull in performance improvements. Some benchmarks show 20-40% improvements.
stuhood
added a commit
that referenced
this pull request
Jan 20, 2026
## What Incorporate a [Jan 12th Tantivy rebase](paradedb/tantivy#93) (from [794ff1ffc9a7169ff7e41fba89a23d13afb358f4](https://github.com/quickwit-oss/tantivy/commits/794ff1ffc9a7169ff7e41fba89a23d13afb358f4) to [c92e831dde738163054729a2276ed74dfa1a8eee](https://github.com/quickwit-oss/tantivy/commits/c92e831dde738163054729a2276ed74dfa1a8eee)) ## Why To stay up to date, and pull in performance improvements. ## Tests Some benchmarks show 20-40% improvements.
mdashti
pushed a commit
that referenced
this pull request
Feb 13, 2026
Incorporate a [Jan 12th Tantivy rebase](paradedb/tantivy#93) (from [794ff1ffc9a7169ff7e41fba89a23d13afb358f4](https://github.com/quickwit-oss/tantivy/commits/794ff1ffc9a7169ff7e41fba89a23d13afb358f4) to [c92e831dde738163054729a2276ed74dfa1a8eee](https://github.com/quickwit-oss/tantivy/commits/c92e831dde738163054729a2276ed74dfa1a8eee)) To stay up to date, and pull in performance improvements. Some benchmarks show 20-40% improvements.
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
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.
What
Incorporate a Jan 12th Tantivy rebase (from 794ff1ffc9a7169ff7e41fba89a23d13afb358f4 to c92e831dde738163054729a2276ed74dfa1a8eee)
Why
To stay up to date, and pull in performance improvements.
Tests
Some benchmarks show 20-40% improvements.