Re: FOR EACH ROW triggers on partitioned tables - Mailing list pgsql-hackers

From Amit Langote
Subject Re: FOR EACH ROW triggers on partitioned tables
Date
Msg-id CA+HiwqEouYTK+Jgo9x95=pSkrftWMF_Z6r6RyqBsKByz2iRkNQ@mail.gmail.com
Whole thread Raw
In response to Re: FOR EACH ROW triggers on partitioned tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: FOR EACH ROW triggers on partitioned tables
List pgsql-hackers
On Fri, Feb 23, 2018 at 11:32 AM, Alvaro Herrera
<alvherre@alvh.no-ip.org> wrote:
> Amit Langote wrote:
>> On 2018/02/23 8:52, Alvaro Herrera wrote:
>> > We could mitigate the performance loss to some extent by adding more to
>> > RelationData.  For example, a "is_partition" boolean would help: skip
>> > searching pg_inherits for a relation that is not a partition.
>>
>> Unless I'm missing something, doesn't rd_rel->relispartition help?
>
> Uh, wow, how have I missed that all this time!  Yes, it probably does.
> I'll rework this tomorrow ... and the already committed index patch too,
> I think.

BTW, not sure if you'd noticed but I had emailed about setting
relispartition on index partitions after you committed the first
indexes patch.

https://www.postgresql.org/message-id/12085bc4-0bc6-0f3a-4c43-57fe0681772b@lab.ntt.co.jp

Thanks,
Amit


pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Translations contributions urgently needed
Next
From: Tom Lane
Date:
Subject: Re: Translations contributions urgently needed