Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1gUjGZ-00047t-Rh
	for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Dec 2018 02:19:52 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1gUjGY-0000pC-BS
	for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Dec 2018 02:19:50 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <Langote_Amit_f8@lab.ntt.co.jp>)
	id 1gUjGY-0000gh-4S; Thu, 06 Dec 2018 02:19:50 +0000
Received: from tama50.ecl.ntt.co.jp ([129.60.39.147])
	by magus.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <Langote_Amit_f8@lab.ntt.co.jp>)
	id 1gUjGP-0000AS-AS; Thu, 06 Dec 2018 02:19:44 +0000
Received: from vc1.ecl.ntt.co.jp (vc1.ecl.ntt.co.jp [129.60.86.153])
	by tama50.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id wB62JbMq002298;
	Thu, 6 Dec 2018 11:19:37 +0900
Received: from vc1.ecl.ntt.co.jp (localhost [127.0.0.1])
	by vc1.ecl.ntt.co.jp (Postfix) with ESMTP id CC447EA87CD;
	Thu,  6 Dec 2018 11:19:37 +0900 (JST)
Received: from jcms-pop21.ecl.ntt.co.jp (jcms-pop21.ecl.ntt.co.jp
 [129.60.87.134])
	by vc1.ecl.ntt.co.jp (Postfix) with ESMTP id C0D69EA87C1;
	Thu,  6 Dec 2018 11:19:37 +0900 (JST)
Received: from [127.0.0.1] (unknown [129.60.241.61])
	by jcms-pop21.ecl.ntt.co.jp (Postfix) with ESMTPSA id B8279400A84;
	Thu,  6 Dec 2018 11:19:37 +0900 (JST)
Subject: Re: Query with high planning time at version 11.1 compared versions
 10.5 and 11.0
From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
References: <20181204215547.7ymtmwaot32slmul@alvherre.pgsql>
 <8db4eca8-6e76-70ff-f934-e0228a1cc298@lab.ntt.co.jp>
Message-ID: <7aa0268e-7fe7-bbda-119d-88a9dcbc189e@lab.ntt.co.jp>
Date: Thu, 6 Dec 2018 11:19:24 +0900
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101
 Thunderbird/60.3.2
MIME-Version: 1.0
In-Reply-To: <8db4eca8-6e76-70ff-f934-e0228a1cc298@lab.ntt.co.jp>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 7bit
X-CC-Mail-RelayStamp: 1
To: Alvaro Herrera <alvherre@2ndquadrant.com>,
        Justin Pryzby <pryzby@telsasoft.com>
Cc: Sanyo Moura <sanyo.moura@tatic.net>, jeff.janes@gmail.com,
        David Rowley <david.rowley@2ndquadrant.com>,
        Robert Haas <robertmhaas@gmail.com>,
        Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>,
        pgsql-performance@lists.postgresql.org,
        Pg Hackers <pgsql-hackers@postgresql.org>
X-TM-AS-MML: disable
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2018/12/06 11:14, Amit Langote wrote:
> I ran the original unmodified query at [1] (the one that produces an empty
> plan due to all children being pruned) against the server built with
> patches I posted on the "speeding up planning with partitions" [2] thread
> and it finished in a jiffy.

Forgot to add the link for [2]: https://commitfest.postgresql.org/21/1778/

Thanks,
Amit