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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f3622b6) | patch
Revert "Don't lock partitions pruned by initial pruning"
2025年5月22日 05:17:24 +0000 (14:17 +0900)
2025年5月22日 08:02:35 +0000 (17:02 +0900)
commit 1722d5eb05d8e5d2e064cd1798abcae4f296ca9d
Revert "Don't lock partitions pruned by initial pruning"

As pointed out by Tom Lane, the patch introduced fragile and invasive
design around plan invalidation handling when locking of prunable
partitions was deferred from plancache.c to the executor. In
particular, it violated assumptions about CachedPlan immutability and
altered executor APIs in ways that are difficult to justify given the
added complexity and overhead.

This also removes the firstResultRels field added to PlannedStmt in
commit 28317de72, which was intended to support deferred locking of
certain ModifyTable result relations.

Reported-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/605328.1747710381@sss.pgh.pa.us
33 files changed:
contrib/auto_explain/auto_explain.c diff | blob | blame | history
contrib/pg_stat_statements/pg_stat_statements.c diff | blob | blame | history
doc/src/sgml/release-18.sgml diff | blob | blame | history
src/backend/commands/copyto.c diff | blob | blame | history
src/backend/commands/createas.c diff | blob | blame | history
src/backend/commands/explain.c diff | blob | blame | history
src/backend/commands/extension.c diff | blob | blame | history
src/backend/commands/matview.c diff | blob | blame | history
src/backend/commands/portalcmds.c diff | blob | blame | history
src/backend/commands/prepare.c diff | blob | blame | history
src/backend/commands/trigger.c diff | blob | blame | history
src/backend/executor/README diff | blob | blame | history
src/backend/executor/execMain.c diff | blob | blame | history
src/backend/executor/execParallel.c diff | blob | blame | history
src/backend/executor/execPartition.c diff | blob | blame | history
src/backend/executor/execUtils.c diff | blob | blame | history
src/backend/executor/functions.c diff | blob | blame | history
src/backend/executor/spi.c diff | blob | blame | history
src/backend/optimizer/plan/planner.c diff | blob | blame | history
src/backend/optimizer/plan/setrefs.c diff | blob | blame | history
src/backend/tcop/postgres.c diff | blob | blame | history
src/backend/tcop/pquery.c diff | blob | blame | history
src/backend/utils/cache/plancache.c diff | blob | blame | history
src/backend/utils/mmgr/portalmem.c diff | blob | blame | history
src/include/commands/explain.h diff | blob | blame | history
src/include/commands/trigger.h diff | blob | blame | history
src/include/executor/execdesc.h diff | blob | blame | history
src/include/executor/executor.h diff | blob | blame | history
src/include/nodes/execnodes.h diff | blob | blame | history
src/include/nodes/pathnodes.h diff | blob | blame | history
src/include/nodes/plannodes.h diff | blob | blame | history
src/include/utils/plancache.h diff | blob | blame | history
src/include/utils/portal.h diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

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