Horton

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

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

View thread View on postgr.es
From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
To: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>, Amit Langote <amitlangote09@gmail.com>
Cc: 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:21:46Z
Lists: pgsql-hackers, pgsql-performance 
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.

Regards,
Amit

Commits

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

  2. Allow direct lookups of AppendRelInfo by child relid