pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Revert "Fix parallel-safety check of expressions and predicate f 6+ messages / 1 participants [nested] [flat]
* pgsql: Revert "Fix parallel-safety check of expressions and predicate f @ 2024-03-06 23:32 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2024-03-06 23:32 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Revert "Fix parallel-safety check of expressions and predicate f @ 2024-03-06 23:32 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2024-03-06 23:32 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Revert "Fix parallel-safety check of expressions and predicate f @ 2024-03-06 23:32 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2024-03-06 23:32 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Revert "Fix parallel-safety check of expressions and predicate f @ 2024-03-06 23:32 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2024-03-06 23:32 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Revert "Fix parallel-safety check of expressions and predicate f @ 2024-03-06 23:32 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2024-03-06 23:32 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Revert "Fix parallel-safety check of expressions and predicate f @ 2024-03-06 23:32 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 6+ messages in thread From: Michael Paquier @ 2024-03-06 23:32 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 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(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-03-06 23:32 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-03-06 23:32 pgsql: Revert "Fix parallel-safety check of expressions and predicate f Michael Paquier <michael@paquier.xyz> 2024-03-06 23:32 pgsql: Revert "Fix parallel-safety check of expressions and predicate f Michael Paquier <michael@paquier.xyz> 2024-03-06 23:32 pgsql: Revert "Fix parallel-safety check of expressions and predicate f Michael Paquier <michael@paquier.xyz> 2024-03-06 23:32 pgsql: Revert "Fix parallel-safety check of expressions and predicate f Michael Paquier <michael@paquier.xyz> 2024-03-06 23:32 pgsql: Revert "Fix parallel-safety check of expressions and predicate f Michael Paquier <michael@paquier.xyz> 2024-03-06 23:32 pgsql: Revert "Fix parallel-safety check of expressions and predicate f Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox