Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fi72M-0002uF-Nl for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Jul 2018 23:48:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fi72L-0003p9-4a for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Jul 2018 23:48:13 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fi72K-0003p1-Q8 for pgsql-hackers@lists.postgresql.org; Tue, 24 Jul 2018 23:48:12 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fi72C-0000uM-V8 for pgsql-hackers@postgresql.org; Tue, 24 Jul 2018 23:48:11 +0000 Received: from [192.168.127.1] (port=44952 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1fi72A-000Dsm-7p; Tue, 24 Jul 2018 23:48:02 +0000 Received: from [127.0.0.1] (port=16986 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1fi729-000Edn-Hg; Tue, 24 Jul 2018 23:48:01 +0000 From: Andrew Gierth To: Andres Freund Cc: Jeremy Finzel , pgsql-hackers@postgresql.org Subject: Re: Early WIP/PoC for inlining CTEs In-Reply-To: <20180724231010.quiaae5qyfrreiyj@alap3.anarazel.de> (Andres Freund's message of "Tue, 24 Jul 2018 16:10:10 -0700") Message-ID: <87o9ewfbar.fsf@news-spur.riddles.org.uk> References: <87sh48ffhb.fsf@news-spur.riddles.org.uk> <20180724231010.quiaae5qyfrreiyj@alap3.anarazel.de> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Wed, 25 Jul 2018 00:48:01 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Andres" == Andres Freund writes: Andres> My read of the concensus (in which I am in the majority, so I Andres> might be biased) is that we do want inlining to be the default. Andres> We were thinking that it'd be necessary to provide a way to Andres> force inlining on the SQL level for individual CTEs. For the record, here is where it came up in the original discussion exactly 10 years ago when the feature was being added: https://www.postgresql.org/message-id/flat/87myk1rg4z.fsf%40news-spur.riddles.org.uk#35efe8ef370518116c38ddc550632aa0 -- Andrew (irc:RhodiumToad)