Reduce unnecessary locking of pruned partitions when reusing cached plans

Edit
ID 6216
Title Reduce unnecessary locking of pruned partitions when reusing cached plans
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 6, First patch: +44−28, All patches: +963−85
Topic Performance
Tags Performance
Created 2025-11-12 14:22:28
Last modified 2025-11-12 14:22:29 (2 months ago)
Latest email 2025-11-25 08:31:04 (1 month ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
Target version 19
Authors Amit Langote (amitlan)
Reviewers Become reviewer
Committer
Links
Emails
generic plans and "initial" pruning
First at 2021-12-25 03:36:00 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2025-11-25 08:31:04 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v4-0002-Introduce-ExecutorPrep-and-refactor-executor-star.patch) at 2025-11-25 08:31:04 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v4-0002-Introduce-ExecutorPrep-and-refactor-executor-star.patch) at 2025-11-25 08:31:04 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0004-Use-pruning-aware-locking-in-cached-plans.patch) at 2025-11-20 07:30:26 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0005-Make-SQL-function-executor-track-ExecutorPrep-sta.patch) at 2025-11-17 12:50:01 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Reuse-partition-pruning-results-in-parallel-worke.patch) at 2025-11-12 14:17:43 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Revert-Don-t-lock-partitions-pruned-by-initial-pr.patch) at 2025-05-21 10:22:03 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0010-Partially-fix-some-extremely-broken-code-from-52.patch) at 2025-05-20 03:06:21 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v1-0001-Fix-bug-in-cbc127917-to-handle-nested-Append-corr.patch) at 2025-02-23 08:35:49 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-an-oversight-in-cbc127917-for-MERGE-handling.patch) at 2025-02-15 07:51:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v63-0001-Don-t-lock-partitions-pruned-by-initial-pruning.patch) at 2025-02-12 11:53:50 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v62-0001-Track-unpruned-relids-to-avoid-processing-pruned.patch) at 2025-02-06 02:35:47 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v61-0001-Track-unpruned-relids-to-avoid-processing-pruned.patch) at 2025-01-31 08:31:44 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v60-0002-Perform-runtime-initial-pruning-outside-ExecInit.patch) at 2025-01-23 07:15:48 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v59-0002-Initialize-PartitionPruneContexts-lazily.patch) at 2024-12-12 07:58:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0005-Remove-the-need-to-check-if-plan-is-valid-from-Execu.patch) at 2024-12-09 07:10:24 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (pruning-in-ExecutorStart.diff) at 2024-12-06 08:18:47 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v58-0001-Move-PartitionPruneInfo-out-of-plan-nodes-into-P.patch) at 2024-12-05 12:03:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (xeon-complete.pdf) at 2024-12-01 18:36:21 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v57-0002-Initialize-PartitionPruneContexts-lazily.patch) at 2024-10-25 12:30:24 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v56-0005-Handle-CachedPlan-invalidation-in-the-executor.patch) at 2024-09-20 08:10:03 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v55-0001-Move-PartitionPruneInfo-out-of-plan-nodes-into-P.patch) at 2024-09-19 12:10:04 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v54-0003-Defer-locking-of-runtime-prunable-relations-to-e.patch) at 2024-09-19 08:39:51 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v53-0001-Move-PartitionPruneInfo-out-of-plan-nodes-into-P.patch) at 2024-09-17 12:57:03 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v52-0001-Defer-locking-of-runtime-prunable-relations-to-e.patch) at 2024-09-05 09:55:47 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v51-0003-Handle-CachedPlan-invalidation-in-the-executor.patch) at 2024-08-29 13:34:17 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v50-0002-Add-field-to-store-parent-relids-to-Append-Merge.patch) at 2024-08-15 12:57:40 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v49-0006-Add-field-to-store-parent-relids-to-Append-Merge.patch) at 2023-11-20 04:29:53 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v48-0007-Delay-locking-of-child-tables-in-cached-plans-un.patch) at 2023-09-28 08:26:27 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v47-0005-Teach-the-executor-to-lock-child-tables-in-some-.patch) at 2023-09-26 13:06:12 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v47-0005-Add-field-to-store-parent-relids-to-Append-Merge.patch) at 2023-09-06 09:12:28 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v46-0004-Make-ExecutorStart-return-early-upon-plan-invali.patch) at 2023-09-05 07:13:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v45-0006-Track-opened-range-table-relations-in-a-List-in-.patch) at 2023-08-11 05:31:03 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v44-0004-Set-inFromCl-to-false-in-child-table-RTEs.patch) at 2023-08-03 08:37:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v43-0002-Add-field-to-store-parent-relids-to-Append-Merge.patch) at 2023-08-02 13:39:45 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (