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 1gi1PD-0000tY-Iz for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Jan 2019 18:19:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gi1PB-0004rm-Ub for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Jan 2019 18:19:41 +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 1gi1PA-0004rf-Qr for pgsql-hackers@lists.postgresql.org; Fri, 11 Jan 2019 18:19:41 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi1P7-0005VS-VJ for pgsql-hackers@postgresql.org; Fri, 11 Jan 2019 18:19:40 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id C1E7B248B0; Fri, 11 Jan 2019 13:19:36 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Fri, 11 Jan 2019 13:19:36 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=ZMnFykK3mPAcIs9iVHBCavczSEb L+63CisHcoVmUbnw=; b=WeSLUJw1wM9TJp/tMm3iF1RV7ibAZq8k9Jd09t+zW4u 2xCmrDzC6uwS3dwV2mKFjw8oXnQRF298xqwx6MlIMJh/lPztgU8t/8JFxVd26JkT MD7w/XLYgVO6wD7dJMQlrUgLzSSGoCOcDMmNaq0sPB+lv71ltcvLYecPvqMXAenw c1fMEqoldLyTwwgfjQWteXn/uMs0P9+8fvs66BgL4PZp5eA7lXPJG0wqG5rCv9dr ZdGdgkH288x3jdQvNalUzK0TeNc3DISE80D8ERXib8++FFpJosHhJgmp5MMC4mCr PX+nau2KJ9JyUlku/8HoHi+OjCWZNAY4f9Dcg5Lsc9w== 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=ZMnFyk K3mPAcIs9iVHBCavczSEbL+63CisHcoVmUbnw=; b=y6dUA+gcPgmeRw6gY9X8jg /2HkdNDKHTbN6l6uhFhfHTrhW4gDtXBCpoOt3PTO8V6kBsBBc0j9cAgMJLt8RPaW CfcIaZS6enqmNAX5IgRxP6IzWk1IucSpS+QlohGvuLKwJb3sogMQG6sJfEH7+lTj qOKn1yMQ7ahj2ARVApKwlmoVmua4UMaXw00C0HyA6iBAq/awbph0pAb3G+tj0aX7 pC7vYwjv8xlxJFIhvwd3EeYC0HJU1PMmKPN7jzS/NbtdidX0OylHa+TXP9TQQqR1 tjOhZ/Y6Z5vNNdsylCU20DFWIbZZWp2QyBJGTGsPwwgLVI8xVXUi2Ex+VR56qYUw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrfeehgdduudefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfquhhtnecuuegrihhlohhuthemucef tddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjughrpeffhffvuffkfh ggtggujgesthdtredttddtvdenucfhrhhomheptehnughrvghsucfhrhgvuhhnugcuoegr nhgurhgvshesrghnrghrrgiivghlrdguvgeqnecukfhppeelkedrvddutddrudegtddrud ejudenucfrrghrrghmpehmrghilhhfrhhomheprghnughrvghssegrnhgrrhgriigvlhdr uggvnecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from intern.anarazel.de (c-98-210-140-171.hsd1.ca.comcast.net [98.210.140.171]) by mail.messagingengine.com (Postfix) with ESMTPA id 42AD4E47A9; Fri, 11 Jan 2019 13:19:35 -0500 (EST) Date: Fri, 11 Jan 2019 10:19:34 -0800 From: Andres Freund To: Robert Haas Cc: Thomas Munro , Andreas Karlsson , Andrew Gierth , Tom Lane , David Fetter , Pg Hackers Subject: Re: Early WIP/PoC for inlining CTEs Message-ID: <20190111181934.g5qig23o7rxubnjt@alap3.anarazel.de> References: <20180727081058.GN17411@fetter.org> <8810.1542402910@sss.pgh.pa.us> <87r2dxrw1z.fsf@news-spur.riddles.org.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-01-11 11:12:25 -0500, Robert Haas wrote: > I actually think that we should go "all in" here and allow the user to > specify either that they want materialization or that they don't want > materialization. If they specify neither, then we make some decision > which we may change in a future release. If they do specify > something, we do that. +many