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 1iaWYy-00040G-El for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Nov 2019 03:03:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iaWYv-0005KK-LD for pgsql-hackers@arkaria.postgresql.org; Fri, 29 Nov 2019 03:03:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iaWYv-0005Jr-4j for pgsql-hackers@lists.postgresql.org; Fri, 29 Nov 2019 03:03:17 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iaWYo-0006a1-0j for pgsql-hackers@postgresql.org; Fri, 29 Nov 2019 03:03:15 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 5B956227F3; Thu, 28 Nov 2019 22:03:09 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 28 Nov 2019 22:03:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=bf8TfHHu6T9mgDDcQHiC5gEq/K4 FyimYnUWAMR8wb+8=; b=b5SZ52Cwi+PtwoqOkVjKy/uFXspjVMPIPnTavmnMN3p axxHo4wMYQVFnmB4LDoSW4WldylOjn/oBuFSETpMWWPTfl1GS+93DDo8butJ0VHi DiE4OMTy96LsQs8bAMOzZ5LO1sltcsDbVvZS3mg49KBv5wWuEuxBilv8sriV2T9Z IRoQEYFjE9sxzsQad/knk4KN2YMOku/tunXQt9qAEjyIjILyQ8sdKMhExVcMQn1y RbxiMcgcpOlAehsZndn2ekrsg9HW2CyuTioMKIYcBY/aEv/L9RFlAoGwly7XslNO 4Ia8jHoflDssEYmyxnP6qzfjc0PQ9NxqdDrTrXNWMpA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=bf8TfH Hu6T9mgDDcQHiC5gEq/K4FyimYnUWAMR8wb+8=; b=R7Hkb443gleg0PaKwPD3R9 rPGZJFzlVX1qP/bpqJ5MIF84OhddH6TSRog35PEEaNYeyFXlztiuFHTbx+TmXD1G 7DvDZ30CYhvEsBTxxq0Sk0RMF1QYgPlisFYXGjI+8bAxNIi3U7owUADNyJBwNJtJ i0ezR07j/zu4/lmZku7qvasZ8z6qYPGAhAqRhvw92gmKW/sGYMQw0oFXDhrdaYvh 202w1fgiFSHcYv3Y5I9kmXWJ67BIv3wfIM2hy9m4bGE234Qvo+U9SLOSOHAYyvQ1 +7H9SAYbnefudGfKl+F/ZYMwyvVCo3/3GjrnV4CpAQHydQcJih3Obpl/1/w0xxCA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudeikedgheegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id C155530600BF; Thu, 28 Nov 2019 22:03:07 -0500 (EST) Date: Fri, 29 Nov 2019 12:03:05 +0900 From: Michael Paquier To: Etsuro Fujita Cc: Richard Guo , Amit Langote , PostgreSQL-development Subject: Re: A problem about partitionwise join Message-ID: <20191129030305.GF2505@paquier.xyz> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="JbKQpFqZXJ2T76Sg" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --JbKQpFqZXJ2T76Sg Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Nov 26, 2019 at 08:35:33PM +0900, Etsuro Fujita wrote: > I've just started reviewing this patch. One comment I have for now > is: this is categorized into Bug Fixes, but we have a workaround at > least to the regression test case in the patch (ie, just reorder join > clauses), so this seems to me more like an improvement than a bug fix. Hmm. Agreed. Changed the category and moved to next CF. -- Michael --JbKQpFqZXJ2T76Sg Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3gimkACgkQnvQgOdby QH2URQ//fgO8E+cD3SA6JSK8hgjdmnQRGAxoM1J7UwRIil6jmcQt9wcTO7pkUcF0 uUhxeK8OQSYZ2Qrzd/z4KoECIFn8chI9Yo5qtjETkZIda3qvLyV1otjrRTYIU+Sb 0kvlsHFQVsApaPyU10Y1gPtcGt7k6EUXQ2WpygqJ/dXH4IxZpNS3FIY7Hdt6Msjk 1TJAcFjtd4O2jqFaAoXmTKMiof33o8DflHvuZ+cRmBTTVanwaAyNviR/zNXke5YZ yJmRa4Nv9DgDthjO8SR3Hs5yL+5iMaElECw/dm6LhLlGnxq/fERKDMcyCKyNL4z9 A7ynGYFx1af/C5dsQLC2x7+ey5kY8lEz8JBa7LG0T1CwhKsy6M3031smnV5vmX6q +fWw3WFrnCKdOPPDkw51pIc95Gik/aA/oO0les+O4gFaxshMqAkeUQLkw1WUiK99 ypSIfxVXQqqkD36Y5PYyVUH/PR8NGEfexX/rWLT23VQyyzHnxGVcuITKLt66+suW OSj9GW2DumaY5z9xLKRPbm8eYL1pWpeb9+V8WRUcSQW2pgrkRe1mzD2ZewZ9sJit MI8DqSwnrQsHeV6pdgs0hwZBREC16x2bG1b+OBjxWlqYLPxtlI0pmdEOTumsmKT4 6LVFmquTp4TPCWzGIHfPK/HXNq9Uh8Q+HwSNFus1ichIpYfIuxg= =k9zg -----END PGP SIGNATURE----- --JbKQpFqZXJ2T76Sg--