Revert "Fix parallel-safety check of expressions and predicate for index builds"
Michael Paquier <michael@paquier.xyz>
Revert "Fix parallel-safety check of expressions and predicate for index builds" This reverts commit eae7be600be7, following a discussion with Tom Lane, due to concerns that this impacts the decisions made by the planner for the number of workers spawned based on the inlining and const-folding of index expressions and predicate for cases that would have worked until this commit. Discussion: https://postgr.es/m/162802.1709746091@sss.pgh.pa.us Backpatch-through: 12
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/plan/planner.c | modified | +2 −10 |
| src/backend/utils/cache/lsyscache.c | modified | +0 −68 |
| src/include/utils/lsyscache.h | modified | +0 −2 |
| src/test/regress/expected/btree_index.out | modified | +0 −19 |
| src/test/regress/sql/btree_index.sql | modified | +0 −22 |
Discussion
- BUG #18314: PARALLEL UNSAFE function does not prevent parallel index build 21 messages · 2024-01-29 → 2024-03-06