Horton

Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0

Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

View thread View on postgr.es
From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Amit Langote <amitlangote09@gmail.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, Justin Pryzby <pryzby@telsasoft.com>, sanyo.moura@tatic.net, Jeff Janes <jeff.janes@gmail.com>, David Rowley <david.rowley@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-01-21T08:56:45Z
Lists: pgsql-hackers, pgsql-performance 
(2019/01/21 17:21), Amit Langote wrote:
> On 2019/01/21 17:17, Etsuro Fujita wrote:
>> (2019/01/19 21:17), Amit Langote wrote:
>>> On Fri, Jan 18, 2019 at 9:58 PM Etsuro Fujita
>>> <fujita.etsuro@lab.ntt.co.jp>   wrote:
>>>> I updated the patch as such and rebased it to the latest HEAD.  I also
>>>> added the commit message.  Attached is an updated patch.  Does that make
>>>> sense?  If there are no objections, I'll push that patch early next week.
>>>
>>> Thank you.  Looks good to me.
>>
>> Cool.  Pushed after tweaking the commit message based on the feedback from
>> Justin offlist and a self-review.
>
> Thank you.

One thing to add: I forgot back-patching :(, so I did that a little 
while ago.

Best regards,
Etsuro Fujita

Commits

  1. Postpone generating tlists and EC members for inheritance dummy children.

  2. Allow direct lookups of AppendRelInfo by child relid