Skip to main content

New Features 🎉

  • Support expressions in JoinScan DISTINCT target lists (e.g., upper(name), name IS NULL).

Stability Improvements 💪

  • Fix JoinScan DISTINCT planning for deferred keys.
  • Fix JoinScan pushdown with outer-only ORDER BY pathkeys.
  • Fix pdb.score() with SELECT subquery in WHERE clause.
  • Handle IN (SELECT ...) OR IS NULL via LeftMark JoinScan.
  • Fix score filter for joins and cases without other quals.
  • Handle pruned columns in nested semi/anti join keys.
  • Handle aliased indexed expressions in search resolution and top-k order by.
  • Lower x86_64 target-cpu from x86-64-v3 to x86-64-v2 for broader hardware compatibility.
  • Prevent DSM buffer overflow in PG18 parallel index scans.
  • Fix PlaceHolderVar found where not expected error.
  • Restore pdb.agg(jsonb) if accidentally removed by an upgrade script.
The full changelog is available on the GitHub Release.