Re: FOR EACH ROW triggers on partitioned tables
От | Amit Langote |
---|---|
Тема | Re: FOR EACH ROW triggers on partitioned tables |
Дата | |
Msg-id | CA+HiwqEouYTK+Jgo9x95=pSkrftWMF_Z6r6RyqBsKByz2iRkNQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: FOR EACH ROW triggers on partitioned tables (Alvaro Herrera <alvherre@alvh.no-ip.org>) |
Ответы |
Re: FOR EACH ROW triggers on partitioned tables
|
Список | 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 по дате отправления: