Re: Optimizing nested ConvertRowtypeExpr execution - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: Optimizing nested ConvertRowtypeExpr execution
Date
Msg-id CAFjFpRfr9RX-=HJt5Z6KiYJObtd+mvSSmoxqFPPoYKxv8KX7Aw@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing nested ConvertRowtypeExpr execution  (Andres Freund <andres@anarazel.de>)
Responses Re: Optimizing nested ConvertRowtypeExpr execution
List pgsql-hackers
On Mon, Apr 2, 2018 at 1:40 AM, Andres Freund <andres@anarazel.de> wrote:
> Hi,
>
> On 2018-02-26 17:20:05 +0530, Ashutosh Bapat wrote:
>> In a multi-level partitioned table, a parent whole-row reference gets
>> translated into nested ConvertRowtypeExpr with child whole-row
>> reference as the leaf. During the execution, the child whole-row
>> reference gets translated into all all intermediate parents' whole-row
>> references, ultimately represented as parent's whole-row reference.
>> AFAIU, the intermediate translations are unnecessary. The leaf child
>> whole-row can be directly translated into top parent's whole-row
>> reference. Here's a WIP patch which does that by eliminating
>> intermediate ConvertRowtypeExprs during ExecInitExprRec().
>
> Why is this done appropriately at ExecInitExpr() time, rather than at
> plan time? Seems like eval_const_expressions() would be a bit more
> appropriate (being badly named aside...)?

That seems to be a better idea. Here's patch.

-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14941: Vacuum crashes
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Commit 4dba331cb3 broke ATTACH PARTITION behaviour.