git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8400704) | patch
Revert "Enable parallel SELECT for "INSERT INTO ... SELECT ..."."
2021年3月24日 05:40:12 +0000 (11:10 +0530)
2021年3月24日 05:59:15 +0000 (11:29 +0530)
commit 26acb54a1368bf3706294400abca85b15c9233a6
Revert "Enable parallel SELECT for "INSERT INTO ... SELECT ..."."

To allow inserts in parallel-mode this feature has to ensure that all the
constraints, triggers, etc. are parallel-safe for the partition hierarchy
which is costly and we need to find a better way to do that. Additionally,
we could have used existing cached information in some cases like indexes,
domains, etc. to determine the parallel-safety.

List of commits reverted, in reverse chronological order:

ed62d3737c Doc: Update description for parallel insert reloption.
c8f78b6161 Add a new GUC and a reloption to enable inserts in parallel-mode.
c5be48f092 Improve FK trigger parallel-safety check added by 05c8482f7f.
e2cda3c20a Fix use of relcache TriggerDesc field introduced by commit 05c8482f7f.
e4e87a32cc Fix valgrind issue in commit 05c8482f7f.
05c8482f7f Enable parallel SELECT for "INSERT INTO ... SELECT ...".

Discussion: https://postgr.es/m/E1lMiB9-0001c3-SY@gemulon.postgresql.org
31 files changed:
doc/src/sgml/config.sgml diff | blob | blame | history
doc/src/sgml/parallel.sgml diff | blob | blame | history
doc/src/sgml/ref/alter_table.sgml diff | blob | blame | history
doc/src/sgml/ref/create_table.sgml diff | blob | blame | history
src/backend/access/common/reloptions.c diff | blob | blame | history
src/backend/access/transam/xact.c diff | blob | blame | history
src/backend/executor/execMain.c diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/outfuncs.c diff | blob | blame | history
src/backend/nodes/readfuncs.c diff | blob | blame | history
src/backend/optimizer/path/costsize.c diff | blob | blame | history
src/backend/optimizer/plan/planner.c diff | blob | blame | history
src/backend/optimizer/util/clauses.c diff | blob | blame | history
src/backend/utils/cache/plancache.c diff | blob | blame | history
src/backend/utils/misc/guc.c diff | blob | blame | history
src/backend/utils/misc/postgresql.conf.sample diff | blob | blame | history
src/bin/psql/tab-complete.c diff | blob | blame | history
src/include/access/xact.h diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_proc.dat diff | blob | blame | history
src/include/nodes/pathnodes.h diff | blob | blame | history
src/include/nodes/plannodes.h diff | blob | blame | history
src/include/optimizer/clauses.h diff | blob | blame | history
src/include/optimizer/cost.h diff | blob | blame | history
src/include/utils/rel.h diff | blob | blame | history
src/test/regress/expected/insert_parallel.out [deleted file] blob | blame | history
src/test/regress/expected/sysviews.out diff | blob | blame | history
src/test/regress/parallel_schedule diff | blob | blame | history
src/test/regress/serial_schedule diff | blob | blame | history
src/test/regress/sql/insert_parallel.sql [deleted file] blob | blame | history
src/tools/pgindent/typedefs.list diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /