Use PG 14's hashed ScalarArrayOpExpr path for a non-Const array the planner can prove is fixed for one execution (col = ANY($1), IN ($1,...,$N), $1::int[], string_to_array($1,','), a stable function), not only for a Const array.
| ID | 7285 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Title | Use PG 14's hashed ScalarArrayOpExpr path for a non-Const array the planner can prove is fixed for one execution (col = ANY($1), IN ($1,...,$N), $1::int[], string_to_array($1,','), a stable function), not only for a Const array. | |||||||||
| CI (CFBot) |
Summary
|
|||||||||
| Stats (from CFBot) | Patch version: v3, Patch count: 2, First patch: +143−129, All patches: +749−185 | |||||||||
| Tags | Performance | |||||||||
| Created | 2026-09-09 17:36:58 | |||||||||
| Last modified | 2026-09-09 17:36:58 (1 month ago) | |||||||||
| Latest email | 2026-10-22 14:53:09 (2 days ago) | |||||||||
| Status |
PG20-3 (2026-11-01 – 2026-11-30): Needs review
|
|||||||||
| Target version | 20 | |||||||||
| Authors | Linden Lance (bestxmg) | |||||||||
| Reviewers | Become reviewer | |||||||||
| Committer | ||||||||||
| Links | ||||||||||
| Emails |
|
|||||||||
| History |
|