New Features ✨
- Join Scan now supports top-K
ORDER BYon vector distance operators (<->,<=>,<#>) acrossINNERandSEMI(IN/EXISTS) joins (#7137).
Performance Improvements 🚀
- Top-K joins ordered by combined search scores now use the rank join when a leaf carries a single-table filter answered by the index, including row-level security policies,
=,= ANY, and range conditions. Such filters previously forced a hash join over every permitted row.
Stability Improvements 💪
- Fixed a crash when a
JoinScanSELECTlist combinespdb.score()with a scalar subquery or query parameter, keptRankJoinExecfor joins with manyORor constant-score predicates on one side, and addedEXPLAINwarnings whenRankJoinExecis not used.