Contents
Permissioned Search, High Selectivity (Score Sort)
- Join: Single Feature (BM25 Score)
- Description: A Full Text Search (BM25) drives the ranking, restricted by a high-selectivity (narrow) foreign filter on
users(u.about_me ||| 'security'). On the 20M dataset, the foreign filter matches 4,577 users (0.20%, below bothparadedb.rank_join_min_rows = 10,000andparadedb.rank_join_unscored_selectivity_threshold = 0.08):RankJoinRuledeclinesRankJoinExecand rewrites the join intoHashJoinExec(fetch=10)over alazy_sortprobe scan usingBitsetFromPostingsdynamicInListpushdown.
Query Info (statistics from 20M dataset):
stackoverflow_posts.title ||| 'how using get create': ~2.03M matches (~10.1%)users.about_me ||| 'security': 4,577 / 2,261,291 users (~0.20%), yielding 6,506 joined post matches- Under database convention, this narrow filter represents high selectivity (filters out ~99.8% of
users).
Rank Join Variant Omission
rank_join.sql and rank_join_range_partitioned.sql are omitted because RankJoinRule intentionally declines RankJoinExec at 0.20% unscored selectivity (< paradedb.rank_join_unscored_selectivity_threshold = 0.08 and < paradedb.rank_join_min_rows = 10,000), rewriting hash_partitioned.sql and range_partitioned.sql directly into HashJoinExec(fetch=10) over a lazy_sort probe scan.
Native PostgreSQL Baseline Omission
See ../join_permissioned_search_low_selectivity/README.md for why postgres.sql is omitted across the join_permissioned_search_* tiers.