Re: Partitioned tables and relfilenode

On 2017/03/08 22:36, Robert Haas wrote:
> On Wed, Mar 8, 2017 at 5:36 AM, Amit Langote wrote:
>>> - rel = mtstate->resultRelInfo->ri_RelationDesc;
>>> + nominalRTE = rt_fetch(node->nominalRelation, estate->es_range_table);
>>> + nominalRel = heap_open(nominalRTE->relid, NoLock);
>>>
>>> No lock?
>>
>> Hmm, I think I missed that a partitioned parent table would not be locked
>> by the *executor* at all after applying this patch. As of now, InitPlan()
>> takes care of locking all the result relations in the
>> PlannedStmt.resultRelations list. This patch removes partitioned
>> parent(s) from appearing in this list. But that makes me wonder - aren't
>> the locks taken by expand_inherited_rtentry() kept long enough? Why does
>> InitPlan need to acquire them again? I see this comment in
>> expand_inherited_rtentry:
>
> Parse-time locks, plan-time locks, and execution-time locks are all
> separate. See the header comments for AcquireRewriteLocks in
> rewriteHandler.c; think about a view, where the parsed query has been
> stored and is later rewritten and planned. Similarly, a plan can be
> reused even after the transaction that created that plan has
> committed; see AcquireExecutorLocks in plancache.c.

Thanks for those references.

I took a step back here and thought a bit more about the implications this
patch. It occurred to me that the complete absence of partitioned table
RT entries in the plan-tree has more consequences than I originally
imagined. I will post an updated patch by Monday latest.

Thanks,
Amit