Re: executor relation handling

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>

To: David Rowley <david.rowley@2ndquadrant.com>

Cc: Jesper Pedersen <jesper.pedersen@redhat.com>, Amit Langote <amitlangote09@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>

Date: 2018-09-28T08:58:49Z

Lists: pgsql-hackers

Attachments

v9-0001-Don-t-lock-range-table-relations-in-the-executor.patch (text/plain) patch v9-0001
v9-0002-Remove-useless-fields-from-planner-nodes.patch (text/plain) patch v9-0002
v9-0003-Prune-PlanRowMark-of-relations-that-are-pruned-fr.patch (text/plain) patch v9-0003
v9-0004-Revise-executor-range-table-relation-opening-clos.patch (text/plain) patch v9-0004

On 2018/09/28 17:48, David Rowley wrote:
> On 28 September 2018 at 20:28, Amit Langote
> <Langote_Amit_f8@lab.ntt.co.jp> wrote:
>> On 2018/09/28 17:21, David Rowley wrote:
>>> I think we maybe should switch the word "assert" for "verifies". The
>>> Assert is just checking we didn't get a NoLock and I don't think
>>> you're using "assert" meaning the Assert() marco, so likely should be
>>> changed to avoid confusion.
>>
>> Okay, I've revised the text in the attached updated patch.
> 
> Meh, I just noticed that the WARNING text claims "InitPlan" is the
> function name. I think it's best to get rid of that. It's pretty much
> redundant anyway if you do: \set VERBOSITY verbose

Oops, good catch that one.  Removed "InitPlan: " from the message in the
attached.

Thanks,
Amit

Commits

Avoid O(N^2) cost in ExecFindRowMark().
- f9eb7c14b08d 12.0 landed
Remove some unnecessary fields from Plan trees.
- 52ed730d511b 12.0 landed
Restore sane locking behavior during parallel query.
- 29ef2b310da9 12.0 landed
Remove more redundant relation locking during executor startup.
- f2343653f5b2 12.0 landed
In the executor, use an array of pointers to access the rangetable.
- d73f4c74dd34 12.0 landed
Centralize executor's opening/closing of Relations for rangetable entries.
- 9ddef36278a9 12.0 landed
Change executor to just Assert that table locks were already obtained.
- 9a3cebeaa7fd 12.0 landed
Change rewriter/planner/executor/plancache to depend on RTE rellockmode.
- 6e35939febf8 12.0 landed
Add assertions that we hold some relevant lock during relation open.
- b04aeb0a053e 12.0 landed
Create an RTE field to record the query's lock mode for each relation.
- fdba460a26af 12.0 landed