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: v5, Patch count: 2, First patch: +143−129, All patches: +767−202 | ||||||||||||
| Tags | Performance | ||||||||||||
| Created | 2026-09-09 17:36:58 | ||||||||||||
| Last modified | 2026-09-09 17:36:58 (1 month ago) | ||||||||||||
| Latest email | 2026-11-01 20:07:53 (1 hour ago) | ||||||||||||
| Status |
PG20-3 (2026-11-01 – 2026-11-30): Needs review
|
||||||||||||
| Target version | 20 | ||||||||||||
| Authors | Linden Lance (bestxmg) | ||||||||||||
| Reviewers | Ayoub Kazar (kaz) Become reviewer | ||||||||||||
| Committer | |||||||||||||
| Links | |||||||||||||
| Emails |
|
||||||||||||
| History |
|