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 1goLNb-0004Sh-7c for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Jan 2019 04:52:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goLNa-0000zT-3h for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Jan 2019 04:52:10 +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 1goLNZ-0000zF-Pf for pgsql-hackers@lists.postgresql.org; Tue, 29 Jan 2019 04:52:09 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goLNX-0008Dr-4L for pgsql-hackers@postgresql.org; Tue, 29 Jan 2019 04:52:08 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 85ADA22D52; Mon, 28 Jan 2019 23:52:05 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 28 Jan 2019 23:52:05 -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=uag80NbIs/9mkRpNmj5lWqUEUCw DS4H2PEWbSZe61Ns=; b=avKlTPWFvlH3WRRSZPvOeu9yzUbpq953QmfPdyuc3rl 2LHGg2x5z7ZCpqqslCxBi3Z2H2IvZirQnFmj4qzpcCVVXN0sNFW+6dKl4Q3xYOuJ Kuh04o9sxiMXQBfiimN9PQyIFk0yaD634ZT0bzE5YZ5UuLLtCDeyM3yg6NLsJVpP XZVpwyXee9aW8XFUfeHMLMmjBM8I8c3HMvizorAAJR+p9fju3Z96x6fJHFm/09JF tiWu3praJZxOtr4mqZIjmJhtXpzASKuUPReULIV8AXYpUbif3c5uOOPrHEPjGWy6 cGJv3/jbPIXzrYsUkXdQ/f/YTe3w3spmzTzlPwFbUGA== 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=uag80N bIs/9mkRpNmj5lWqUEUCwDS4H2PEWbSZe61Ns=; b=tJZq7d4K6uIBtf7WhT/Smc pzIM4oz4Q25pU7myiW9jtqaJUw3scXbIe8pzNa1eXUAjnO3BLTG/go2yUBJkHp1P SJXj5Qz5S1ZnkI2kXC2Dio51NrPoyzKFnW8Zo2vWHhxc8VWuWCqZSOy5N/7nw1EK nVzQaYMmpP9r+C8B/lh2KvbODwDbt0Z/7HWXQazm3iiOcGZa5O/tAoFRn4gOOe2W PDdteCDw+V3Ej83b7D/GCpvteKAFe/EGzOFpCDv0A9ghzS30mtBhi5S4KbnhhMYJ zhL05eoBM249deo8kImf0LP00RYPWOGjZe4L7VxHPb6WvJBOcHS1v7qaeveT6dyQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrjedugdejjecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmd enucfjughrpeffhffvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghh rggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenuc fkphepiedurddvudehrddufeejrdduiedvnecurfgrrhgrmhepmhgrihhlfhhrohhmpehm ihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgepud X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 3064CE4511; Mon, 28 Jan 2019 23:52:00 -0500 (EST) Date: Tue, 29 Jan 2019 13:51:58 +0900 From: Michael Paquier To: Tom Lane Cc: Peter Eisentraut , Robert Haas , Andreas Karlsson , Andres Freund , Thomas Munro , Andrew Gierth , David Fetter , Pg Hackers Subject: Re: Early WIP/PoC for inlining CTEs Message-ID: <20190129045158.GD3121@paquier.xyz> References: <20190111190403.77ye7m5mxypxsf4l@alap3.anarazel.de> <00818be9-2f63-f584-efcd-d97ee0662905@proxel.se> <5715d93e-6ebc-be17-c2c3-56a873100a38@proxel.se> <29576.1548084476@sss.pgh.pa.us> <12408.1548707732@sss.pgh.pa.us> <32184.1548713132@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="9dgjiU4MmWPVapMU" Content-Disposition: inline In-Reply-To: <32184.1548713132@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --9dgjiU4MmWPVapMU Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Jan 28, 2019 at 05:05:32PM -0500, Tom Lane wrote: > Yeah, I thought about that too, but it doesn't seem like an improvement. > If the query is very long (which isn't unlikely) I think people would > prefer to see the option(s) up front. Having these options at the front of the WITH clause looks more natural to me. -- Michael --9dgjiU4MmWPVapMU Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlxP2+4ACgkQnvQgOdby QH1i5g/+IgDdPuYl+oAaY0pDJqhLqLVR/Jj3IfXSQCl7uJ8vYvIeTEkknU1TLXHQ KKED0I9ODzabnIjc5BC4lKvNqye9nHXDemDLK/iqIWW8ZvdtmmWzRuuH6Lt3AwEk cBQz6YZwJSU6N756PCPYbNm84CCsEic3eoUFpqshGIbW4+QWIfuTzoz/Ks99bhIa 7dIQOUUBOFIbaHWM9pqdVa3Qs3o5wFEuBYR+vLWXYFDeNXYZ8gCnrzqRoMV0evOo M1kBGRfelalclkXi9VfpGPQvxTB15q6V/U+CeKY1Fac8ARuLMKhUpukoKIdjw5GZ PcVUfwRQI3YVQyM2779GB7/XEnfG6t56ke7fPfyR1u59aLMqjDQuhjmYoBgKmIWq Xzf1oftms9dcZRzy7pMVmcf3RBzOXweeHyFS056/72gsIU9tYHIN5+nU3tuW5dgb R4HyMsc7451qb0SikLGUHwomKxPXepF566mlDiZ35MO0RQpwPzPzk6WxJ/Dgzoiy uRxm/rS2NpOjF/n9tv3ZaIHyaCXHGpUPbLNu1wywB+Z0OzDdwDsOVV/t0tNfEfsz VJFnkGgjSb63qpm6zKO6zt53drWV/W1c5VbSHwS1Bp1/w0p7AFU6nk1hsXSR0Mrr 4kv9DIfvCUvDY/xqxyRsL1r0OY29bTsQKaMU3LcahArNT70p+Sk= =ulmd -----END PGP SIGNATURE----- --9dgjiU4MmWPVapMU--