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 ) id 1glVOd-0001Ug-Sr for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Jan 2019 08:57:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glVOb-0002nG-EC for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Jan 2019 08:57:29 +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 ) id 1glVOb-0002n9-7K for pgsql-hackers@lists.postgresql.org; Mon, 21 Jan 2019 08:57:29 +0000 Received: from tama50.ecl.ntt.co.jp ([129.60.39.147]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1glVOX-0001A4-GD for pgsql-hackers@postgresql.org; Mon, 21 Jan 2019 08:57:28 +0000 Received: from vc2.ecl.ntt.co.jp (vc2.ecl.ntt.co.jp [129.60.86.154]) by tama50.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id x0L8vKeN022187; Mon, 21 Jan 2019 17:57:20 +0900 Received: from vc2.ecl.ntt.co.jp (localhost [127.0.0.1]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id 4553B638F8F; Mon, 21 Jan 2019 17:57:20 +0900 (JST) Received: from jcms-pop21.ecl.ntt.co.jp (jcms-pop21.ecl.ntt.co.jp [129.60.87.134]) by vc2.ecl.ntt.co.jp (Postfix) with ESMTP id 3945E638F75; Mon, 21 Jan 2019 17:57:20 +0900 (JST) Received: from [IPv6:::1] (unknown [129.60.241.75]) by jcms-pop21.ecl.ntt.co.jp (Postfix) with ESMTPSA id 2DDC54003E3; Mon, 21 Jan 2019 17:57:20 +0900 (JST) Message-ID: <5C45894D.6010109@lab.ntt.co.jp> Date: Mon, 21 Jan 2019 17:56:45 +0900 From: Etsuro Fujita User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:11.0) Gecko/20120327 Thunderbird/11.0.1 MIME-Version: 1.0 Subject: Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 References: <8db4eca8-6e76-70ff-f934-e0228a1cc298@lab.ntt.co.jp> <20181206075726.pig32e6thltb56hr@alvherre.pgsql> <5C34846E.9090600@lab.ntt.co.jp> <96720c99-ffa0-01ad-c594-0504c8eda708@lab.ntt.co.jp> <5C35D912.8040200@lab.ntt.co.jp> <7354b5bf-5932-4c0c-81ee-d9550de18995@lab.ntt.co.jp> <5C36E105.2020902@lab.ntt.co.jp> <5C38910B.8010901@lab.ntt.co.jp> <5C3EC4EC.5070404@lab.ntt.co.jp> <5C41CCC0.5030702@lab.ntt.co.jp> <5C458031.2000906@lab.ntt.co.jp> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-CC-Mail-RelayStamp: 1 To: Amit Langote Cc: Amit Langote , Ashutosh Bapat , Alvaro Herrera , Justin Pryzby , sanyo.moura@tatic.net, Jeff Janes , David Rowley , Robert Haas , PostgreSQL-development X-TM-AS-MML: disable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk (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 >>> 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