pgsql: Revert "Fix parallel-safety check of expressions and predicate f

2024-03-06 Thread Michael Paquier
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.1709746...@sss.pgh.pa.us
Backpatch-through: 12

Branch
--
REL_16_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/c46817ee512afa156561cce2dd6dc8440fe98d55

Modified Files
--
src/backend/optimizer/plan/planner.c  | 12 +-
src/backend/utils/cache/lsyscache.c   | 68 ---
src/include/utils/lsyscache.h |  2 -
src/test/regress/expected/btree_index.out | 19 -
src/test/regress/sql/btree_index.sql  | 22 --
5 files changed, 2 insertions(+), 121 deletions(-)



pgsql: Revert "Fix parallel-safety check of expressions and predicate f

2024-03-06 Thread Michael Paquier
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.1709746...@sss.pgh.pa.us
Backpatch-through: 12

Branch
--
REL_14_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/49b971298a9b4271a9d5f91dcc969c5cb1acfbc1

Modified Files
--
src/backend/optimizer/plan/planner.c  | 12 +-
src/backend/utils/cache/lsyscache.c   | 68 ---
src/include/utils/lsyscache.h |  2 -
src/test/regress/expected/btree_index.out | 19 -
src/test/regress/sql/btree_index.sql  | 22 --
5 files changed, 2 insertions(+), 121 deletions(-)



pgsql: Revert "Fix parallel-safety check of expressions and predicate f

2024-03-06 Thread Michael Paquier
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.1709746...@sss.pgh.pa.us
Backpatch-through: 12

Branch
--
REL_15_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/e82b64a92cf5650e618b26b85ca5c0f090286bb4

Modified Files
--
src/backend/optimizer/plan/planner.c  | 12 +-
src/backend/utils/cache/lsyscache.c   | 68 ---
src/include/utils/lsyscache.h |  2 -
src/test/regress/expected/btree_index.out | 19 -
src/test/regress/sql/btree_index.sql  | 22 --
5 files changed, 2 insertions(+), 121 deletions(-)



pgsql: Revert "Fix parallel-safety check of expressions and predicate f

2024-03-06 Thread Michael Paquier
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.1709746...@sss.pgh.pa.us
Backpatch-through: 12

Branch
--
REL_12_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/69e8f9dadb01377b8b757aa892ef00ce377f047e

Modified Files
--
src/backend/optimizer/plan/planner.c  | 12 +-
src/backend/utils/cache/lsyscache.c   | 68 ---
src/include/utils/lsyscache.h |  2 -
src/test/regress/expected/btree_index.out | 19 -
src/test/regress/sql/btree_index.sql  | 22 --
5 files changed, 2 insertions(+), 121 deletions(-)



pgsql: Revert "Fix parallel-safety check of expressions and predicate f

2024-03-06 Thread Michael Paquier
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.1709746...@sss.pgh.pa.us
Backpatch-through: 12

Branch
--
REL_13_STABLE

Details
---
https://git.postgresql.org/pg/commitdiff/70a31629aede159a99226da3edc4b1c10192cc44

Modified Files
--
src/backend/optimizer/plan/planner.c  | 12 +-
src/backend/utils/cache/lsyscache.c   | 68 ---
src/include/utils/lsyscache.h |  2 -
src/test/regress/expected/btree_index.out | 19 -
src/test/regress/sql/btree_index.sql  | 22 --
5 files changed, 2 insertions(+), 121 deletions(-)



pgsql: Revert "Fix parallel-safety check of expressions and predicate f

2024-03-06 Thread Michael Paquier
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.1709746...@sss.pgh.pa.us
Backpatch-through: 12

Branch
--
master

Details
---
https://git.postgresql.org/pg/commitdiff/099ca50bd41c1a72fe5a086bb095858ea74c88de

Modified Files
--
src/backend/optimizer/plan/planner.c  | 12 +-
src/backend/utils/cache/lsyscache.c   | 68 ---
src/include/utils/lsyscache.h |  2 -
src/test/regress/expected/btree_index.out | 19 -
src/test/regress/sql/btree_index.sql  | 22 --
5 files changed, 2 insertions(+), 121 deletions(-)