Re: Prologue of set_append_rel_size() and partitionedtables - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Prologue of set_append_rel_size() and partitionedtables
Date
Msg-id 3d3a8540-daba-d819-2b9f-9f9fe638d741@lab.ntt.co.jp
Whole thread Raw
Responses Re: Prologue of set_append_rel_size() and partitioned tables
List pgsql-hackers
On 2017/03/29 15:20, Ashutosh Bapat wrote:
> The prologue of set_append_rel_size() mentions
> 
>  * ....  Note that in the inheritance case,
>  * the first member relation is actually the same table as is mentioned in
>  * the parent RTE ... but it has a different RTE and RelOptInfo.
> 
> This isn't true about partitioned tables anymore. We do not create
> RelOptInfo of the partitioned table and thus is not first member
> relation.

My bad.

> We could argue that inheritance in case of partitioned
> tables is just an implementation detail and partitioned table is not
> "inherited" in true sense. So "inheritance case" referred to here does
> not cover partitioning and so the sentence still holds. But I guess,
> this needs some change so that we do not expect first member to be
> same as partitioned table. I am not able to craft an elegant sentence
> but how about something like attached?

I think we *should* update the comment somwhow.  Since now there are a few
places using "non-partitioned inheritance" to refer to regular parent
tables, why not use that term here too?  So:

  * The passed-in rel and RTE represent the entire append relation.  The
- * relation's contents are computed by appending together the output of
- * the individual member relations.  Note that in the inheritance case,
- * the first member relation is actually the same table as is mentioned in
- * the parent RTE ... but it has a different RTE and RelOptInfo.  This is
+ * relation's contents are computed by appending together the output of the
+ * individual member relations.  Note that in the non-partitioned inheritance
+ * case, the first member relation is actually the same table as is mentioned
+ * in the parent RTE ... but it has a different RTE and RelOptInfo.  This is

Update patch attached.

Thanks,
Amit

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Partitioned tables and relfilenode
Next
From: Kang Yuzhe
Date:
Subject: Re: On How To Shorten the Steep Learning Curve Towards PG Hacking...