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 <amitlangote09@gmail.com>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, 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:17:53Z
Lists: pgsql-hackers, pgsql-performance 
(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.

Thanks everyone who worked on this!

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