AcquireExecutorLocks() and run-time pruning

Edit

Title

Topic

Performance

Created

2021-12-25 03:38:07

Last modified

2023-04-09 02:32:16 (1 month, 3 weeks ago)

Latest email

2023-04-05 23:23:31 (2 months ago)

Status

2023-07: Needs review

2023-03: Moved to next CF

2023-01: Moved to next CF

2022-11: Moved to next CF

2022-09: Moved to next CF

2022-07: Moved to next CF

2022-03: Moved to next CF

2022-01: Moved to next CF

Target version

Authors

Amit Langote (amitlan)

Reviewers

Tom Lane (tgl)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 2023-04-05 23:23:31 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v38-0001-Add-field-to-store-partitioned-relids-to-Append-.patch) at 2023-03-27 14:00:38 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v38-0001-Add-field-to-store-partitioned-relids-to-Append-.patch) at 2023-03-27 14:00:38 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v37-0001-Add-field-to-store-partitioned-relids-to-Append-.patch) at 2023-03-27 08:18:20 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v36-0003-Track-opened-range-table-relations-in-a-List-in-.patch) at 2023-03-22 12:48:49 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v35-0003-Track-opened-range-table-relations-in-a-List-in-.patch) at 2023-03-14 10:07:41 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Move-AcquireExecutorLocks-s-responsibility-into-.patch) at 2023-03-02 13:52:53 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v33-0001-Move-AcquireExecutorLocks-s-responsibility-into-.patch) at 2023-02-03 13:01:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v32-0001-Move-AcquireExecutorLocks-s-responsibility-into-.patch) at 2023-02-02 14:49:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v31-0001-Move-ExecutorStart-closer-to-GetCachedPlan.patch) at 2023-01-27 07:01:05 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v30-0002-In-GetCachedPlan-only-lock-unpruned-partitions.patch) at 2022-12-16 02:33:53 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Preparatory-refactoring-before-reworking-CachedP.patch) at 2022-12-14 08:35:47 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v28-0002-Add-root_parent_relids-to-PartitionPruneResult.patch) at 2022-12-05 06:08:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Optimize-AcquireExecutorLocks-by-locking-only-un.patch) at 2022-12-05 03:00:01 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v26-0002-Add-root_parent_relids-to-PartitionPruneResult.patch) at 2022-12-02 10:40:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Optimize-AcquireExecutorLocks-by-locking-only-un.patch) at 2022-12-01 12:43:28 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (PartitionPruneInfo-relids.patch) at 2022-12-01 07:59:25 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v24-0002-Optimize-AcquireExecutorLocks-by-locking-only-un.patch) at 2022-11-08 06:22:32 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch) at 2022-10-27 02:41:55 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch) at 2022-10-17 09:29:48 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch) at 2022-10-12 07:36:15 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch) at 2022-07-27 03:00:57 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch) at 2022-07-13 07:03:51 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v18-0002-Optimize-AcquireExecutorLocks-by-locking-only-un.patch) at 2022-07-13 06:40:10 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch) at 2022-07-06 02:37:57 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Move-PartitioPruneInfo-out-of-plan-nodes-into-Pl.patch) at 2022-05-27 08:09:46 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Optimize-AcquireExecutorLocks-to-skip-pruned-par.patch) at 2022-04-11 03:05:19 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Optimize-AcquireExecutorLocks-to-skip-pruned-par.patch) at 2022-04-08 11:45:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (misc_fixes.patch.txt) at 2022-04-08 11:15:53 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Optimize-AcquireExecutorLocks-to-skip-pruned-par.patch) at 2022-04-08 05:49:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Optimize-AcquireExecutorLocks-to-skip-pruned-par.patch) at 2022-04-07 08:27:50 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Optimize-AcquireExecutorLocks-to-skip-pruned-par.patch) at 2022-04-06 07:20:46 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Some-refactoring-of-runtime-pruning-code.patch) at 2022-04-05 02:29:49 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Some-refactoring-of-runtime-pruning-code.patch) at 2022-04-04 12:55:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0004-Optimize-AcquireExecutorLocks-to-skip-pruned-part.patch) at 2022-03-31 03:25:20 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Add-Merge-Append.partitioned_rels.patch) at 2022-03-28 07:28:46 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v6-0003-Add-a-plan_tree_walker.patch) at 2022-03-28 07:17:00 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Add-a-plan_tree_walker.patch) at 2022-03-11 14:35:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Invent-a-new-executor-prep-phase.patch) at 2022-02-10 08:13:52 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v3-0001-Teach-AcquireExecutorLocks-to-acquire-fewer-locks.patch) at 2022-01-18 01:32:57 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Teach-AcquireExecutorLocks-to-acquire-fewer-locks.patch) at 2022-01-14 14:10:43 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Teach-AcquireExecutorLocks-to-acquire-fewer-locks.patch) at 2021-12-25 03:36:00 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)

History

When	Who	What
2023-04-09 02:32:16	Greg Stark (stark)	Closed in commitfest 2023-03 with status: Moved to next CF
2023-02-02 14:50:28	Amit Langote (amitlan)	New status: Needs review
2023-01-31 16:43:44	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-20 20:26:43	Tom Lane (tgl)	New status: Waiting on Author
2022-12-21 15:18:17	Tom Lane (tgl)	Added tgl as reviewer
2022-12-21 10:18:57	Álvaro Herrera (alvherre)	New status: Ready for Committer
2022-12-13 23:49:50	Ian Barwick (barwick)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-12 13:01:31	Amit Langote (amitlan)	New status: Needs review
2022-10-12 07:38:09	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 07:38:06	Michael Paquier (michael-kun)	New status: Waiting on Author
2022-08-01 22:51:18	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-04-08 14:36:41	Greg Stark (stark)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:33:50	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-25 03:38:13	Amit Langote (amitlan)	Changed authors to Amit Langote (amitlan)
2021-12-25 03:38:07	Amit Langote (amitlan)	Attached mail thread CA+HiwqFGkMSge6TgC9KQzde0ohpAycLQuV7ooitEEpbKB0O_mg@mail.gmail.com
2021-12-25 03:38:07	Amit Langote (amitlan)	Created patch record

Edit