=== Applying patches on top of PostgreSQL commit ID e4a8fb8fefb903fe601f7415098a4fe39a14069a === /etc/rc.d/jail: WARNING: Per-jail configuration via jail_* variables is obsolete. Please consider migrating to /etc/jail.conf. === applying patch ./v59-0001-Move-PartitionPruneInfo-out-of-plan-nodes-into-P.patch patching file src/backend/executor/execMain.c Hunk #1 succeeded at 853 (offset -3 lines). patching file src/backend/executor/execParallel.c patching file src/backend/executor/execPartition.c patching file src/backend/executor/execUtils.c patching file src/backend/executor/nodeAppend.c Hunk #1 succeeded at 135 (offset 1 line). Hunk #2 succeeded at 146 (offset 1 line). patching file src/backend/executor/nodeMergeAppend.c Hunk #1 succeeded at 83 (offset 1 line). Hunk #2 succeeded at 94 (offset 1 line). patching file src/backend/optimizer/plan/createplan.c patching file src/backend/optimizer/plan/planner.c Hunk #1 succeeded at 555 (offset -2 lines). patching file src/backend/optimizer/plan/setrefs.c patching file src/backend/partitioning/partprune.c patching file src/include/executor/execPartition.h patching file src/include/nodes/execnodes.h patching file src/include/nodes/pathnodes.h patching file src/include/nodes/plannodes.h Hunk #4 succeeded at 1414 (offset -3 lines). Hunk #5 succeeded at 1430 (offset -3 lines). patching file src/include/partitioning/partprune.h [cf/3478 86770afd99] Move PartitionPruneInfo out of plan nodes into PlannedStmt Author: Amit Langote Date: Wed Dec 4 16:16:29 2024 +0900 15 files changed, 131 insertions(+), 61 deletions(-) === applying patch ./v59-0002-Initialize-PartitionPruneContexts-lazily.patch patching file src/backend/executor/execPartition.c patching file src/backend/partitioning/partprune.c patching file src/include/executor/execPartition.h patching file src/include/partitioning/partprune.h [cf/3478 52a3f82654] Initialize PartitionPruneContexts lazily Author: Amit Langote Date: Wed Dec 4 16:16:41 2024 +0900 4 files changed, 123 insertions(+), 49 deletions(-) === applying patch ./v59-0003-Perform-runtime-initial-pruning-outside-ExecInit.patch patching file src/backend/executor/execMain.c Hunk #2 succeeded at 856 (offset -3 lines). patching file src/backend/executor/execPartition.c patching file src/backend/executor/nodeAppend.c Hunk #1 succeeded at 144 (offset 1 line). patching file src/backend/executor/nodeMergeAppend.c Hunk #1 succeeded at 92 (offset 1 line). patching file src/include/executor/execPartition.h patching file src/include/nodes/execnodes.h [cf/3478 5034fa0c13] Perform runtime initial pruning outside ExecInitNode() Author: Amit Langote Date: Wed Dec 4 16:16:49 2024 +0900 6 files changed, 125 insertions(+), 50 deletions(-) === applying patch ./v59-0004-Defer-locking-of-runtime-prunable-relations-in-c.patch patching file contrib/auto_explain/auto_explain.c patching file contrib/pg_stat_statements/pg_stat_statements.c patching file src/backend/commands/copyfrom.c patching file src/backend/commands/copyto.c patching file src/backend/commands/createas.c patching file src/backend/commands/explain.c Hunk #1 succeeded at 519 (offset 7 lines). Hunk #2 succeeded at 642 (offset 7 lines). Hunk #3 succeeded at 700 (offset 7 lines). Hunk #4 succeeded at 714 (offset 7 lines). patching file src/backend/commands/extension.c patching file src/backend/commands/matview.c patching file src/backend/commands/portalcmds.c patching file src/backend/commands/prepare.c patching file src/backend/commands/trigger.c patching file src/backend/executor/README patching file src/backend/executor/execMain.c Hunk #2 succeeded at 137 (offset -2 lines). Hunk #3 succeeded at 375 (offset -3 lines). Hunk #4 succeeded at 482 (offset -3 lines). Hunk #5 succeeded at 549 (offset -3 lines). Hunk #6 succeeded at 566 (offset -3 lines). Hunk #7 succeeded at 672 (offset -3 lines). Hunk #8 succeeded at 912 (offset -3 lines). Hunk #9 succeeded at 925 (offset -3 lines). Hunk #10 succeeded at 942 (offset -3 lines). Hunk #11 succeeded at 957 (offset -3 lines). Hunk #12 succeeded at 980 (offset -3 lines). patching file src/backend/executor/execParallel.c patching file src/backend/executor/execPartition.c patching file src/backend/executor/execUtils.c Hunk #2 succeeded at 772 (offset 43 lines). Hunk #3 succeeded at 784 (offset 43 lines). Hunk #4 succeeded at 813 (offset 43 lines). Hunk #5 succeeded at 825 (offset 43 lines). patching file src/backend/executor/functions.c patching file src/backend/executor/nodeAppend.c Hunk #1 succeeded at 595 (offset 14 lines). Hunk #2 succeeded at 662 (offset 14 lines). Hunk #3 succeeded at 738 (offset 14 lines). Hunk #4 succeeded at 891 (offset 14 lines). patching file src/backend/executor/nodeLockRows.c patching file src/backend/executor/nodeMergeAppend.c Hunk #1 succeeded at 233 (offset 14 lines). patching file src/backend/executor/nodeModifyTable.c patching file src/backend/executor/spi.c Hunk #7 succeeded at 2935 with fuzz 2. patching file src/backend/optimizer/plan/planner.c Hunk #1 succeeded at 557 (offset -2 lines). patching file src/backend/optimizer/plan/setrefs.c patching file src/backend/partitioning/partprune.c patching file src/backend/replication/logical/worker.c patching file src/backend/replication/pgoutput/pgoutput.c Hunk #1 succeeded at 815 (offset 4 lines). patching file src/backend/tcop/postgres.c Hunk #1 succeeded at 1224 (offset -12 lines). Hunk #2 succeeded at 2026 (offset -13 lines). patching file src/backend/tcop/pquery.c Hunk #10 succeeded at 1208 (offset -6 lines). Hunk #11 succeeded at 1290 (offset -6 lines). Hunk #12 succeeded at 1302 (offset -6 lines). Hunk #13 succeeded at 1369 (offset -6 lines). patching file src/backend/utils/cache/plancache.c patching file src/backend/utils/mmgr/portalmem.c patching file src/include/commands/explain.h patching file src/include/commands/trigger.h patching file src/include/executor/execPartition.h patching file src/include/executor/execdesc.h patching file src/include/executor/executor.h Hunk #2 succeeded at 193 with fuzz 1 (offset -6 lines). Hunk #3 succeeded at 259 (offset -6 lines). Hunk #4 succeeded at 623 (offset 5 lines). patching file src/include/nodes/execnodes.h Hunk #4 succeeded at 1432 (offset -1 lines). patching file src/include/nodes/pathnodes.h patching file src/include/nodes/plannodes.h Hunk #2 succeeded at 1477 (offset -3 lines). patching file src/include/utils/plancache.h patching file src/include/utils/portal.h Hunk #2 succeeded at 241 (offset -1 lines). patching file src/test/modules/delay_execution/Makefile patching file src/test/modules/delay_execution/delay_execution.c patching file src/test/modules/delay_execution/expected/cached-plan-inval.out patching file src/test/modules/delay_execution/meson.build patching file src/test/modules/delay_execution/specs/cached-plan-inval.spec patching file src/test/regress/expected/partition_prune.out patching file src/test/regress/sql/partition_prune.sql [cf/3478 8e39253416] Defer locking of runtime-prunable relations in cached plans Author: Amit Langote Date: Wed Dec 4 16:16:56 2024 +0900 48 files changed, 1299 insertions(+), 117 deletions(-) create mode 100644 src/test/modules/delay_execution/expected/cached-plan-inval.out create mode 100644 src/test/modules/delay_execution/specs/cached-plan-inval.spec === applying patch ./v59-0005-Remove-the-need-to-check-if-plan-is-valid-from-E.patch patching file contrib/auto_explain/auto_explain.c patching file contrib/pg_stat_statements/pg_stat_statements.c patching file src/backend/executor/execMain.c Hunk #2 succeeded at 122 (offset -2 lines). Hunk #3 succeeded at 142 (offset -2 lines). Hunk #4 succeeded at 279 (offset -2 lines). Hunk #5 succeeded at 332 (offset -2 lines). Hunk #6 succeeded at 361 (offset -2 lines). Hunk #7 succeeded at 368 (offset -2 lines). Hunk #8 succeeded at 985 (offset -3 lines). patching file src/backend/executor/execPartition.c patching file src/include/executor/execPartition.h patching file src/include/executor/executor.h Hunk #2 succeeded at 203 with fuzz 2 (offset -6 lines). Hunk #3 succeeded at 268 (offset -6 lines). patching file src/include/nodes/execnodes.h patching file src/test/modules/delay_execution/delay_execution.c patching file src/test/modules/delay_execution/expected/cached-plan-inval.out [cf/3478 4623e4f7a6] Remove the need to check if plan is valid from ExecutorStart hooks Author: Amit Langote Date: Mon Dec 9 12:34:04 2024 +0900 9 files changed, 179 insertions(+), 177 deletions(-)