Re: generic plans and "initial" pruning

Amit Langote <amitlangote09@gmail.com>

From: Amit Langote <amitlangote09@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>, "David Rowley *EXTERN*" <dgrowleyml@gmail.com>

Date: 2022-03-31T03:25:20Z

Lists: pgsql-hackers

Attachments

v8-0004-Optimize-AcquireExecutorLocks-to-skip-pruned-part.patch (application/octet-stream) patch v8-0004
v8-0001-Some-refactoring-of-runtime-pruning-code.patch (application/octet-stream) patch v8-0001
v8-0003-Add-a-plan_tree_walker.patch (application/octet-stream) patch v8-0003
v8-0002-Add-Merge-Append.partitioned_rels.patch (application/octet-stream) patch v8-0002

On Mon, Mar 28, 2022 at 4:28 PM Amit Langote <amitlangote09@gmail.com> wrote:
> On Mon, Mar 28, 2022 at 4:17 PM Amit Langote <amitlangote09@gmail.com> wrote:
> > Other than the changes mentioned above, the updated patch now contains
> > a bit more commentary than earlier versions, mostly around
> > AcquireExecutorLocks()'s new way of determining the set of relations
> > to lock and the significantly redesigned working of the "initial"
> > execution pruning.
>
> Forgot to rebase over the latest HEAD, so here's v7.  Also fixed that
> _out and _read functions for PlanInitPruningOutput were using an
> obsolete node label.

Rebased.

-- 
Amit Langote
EDB: http://www.enterprisedb.com

Commits

Stamp 19beta1.
- 4b0bf0788b06 19 (unreleased) cited
Revert "Don't lock partitions pruned by initial pruning"
- 1722d5eb05d8 18.0 landed
Ensure first ModifyTable rel initialized if all are pruned
- 28317de723b6 18.0 cited
Fix bug in cbc127917 to handle nested Append correctly
- cbb9086c9ef6 18.0 landed
Remove unstable test suite added by 525392d57
- 4f1b6e5bb4fe 18.0 landed
Don't lock partitions pruned by initial pruning
- 525392d5727f 18.0 landed
Fix an oversight in cbc127917 to handle MERGE correctly
- 75dfde13639a 18.0 landed
Track unpruned relids to avoid processing pruned relations
- cbc127917e04 18.0 landed
Perform runtime initial pruning outside ExecInitNode()
- d47cbf474ecb 18.0 landed
Move PartitionPruneInfo out of plan nodes into PlannedStmt
- bb3ec16e14de 18.0 landed
Fix setrefs.c's failure to do expression processing on prune steps.
- bf826ea06297 18.0 cited
Remove obsolete executor cleanup code
- d060e921ea5a 17.0 landed
Revert "Move PartitionPruneInfo out of plan nodes into PlannedStmt"
- 5472743d9e85 16.0 landed
Move PartitioPruneInfo out of plan nodes into PlannedStmt
- ec386948948c 16.0 landed
Refactor and cleanup runtime partition prune code a little
- 297daa9d4353 15.0 landed
Remove some unnecessary fields from Plan trees.
- 52ed730d511b 12.0 cited
Remove more redundant relation locking during executor startup.
- f2343653f5b2 12.0 cited
Shut down Gather's children before shutting down Gather itself.
- acf555bc53ac 10.0 cited