pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Andreas Karlsson <andreas@proxel.se>
Cc: Nico Williams <nico@cryptonector.com>
Cc: David Fetter <david@fetter.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Early WIP/PoC for inlining CTEs
Date: Fri, 27 Jul 2018 17:33:51 +0100
Message-ID: <876010d4hi.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <28e6f571-000e-f087-0553-c2ee41eac293@proxel.se>
References: <87sh48ffhb.fsf@news-spur.riddles.org.uk>
	<20180725054236.GB17411@fetter.org>
	<20180725153205.GM5695@localhost>
	<877eljfhrx.fsf@news-spur.riddles.org.uk>
	<28e6f571-000e-f087-0553-c2ee41eac293@proxel.se>

>>>>> "Andreas" == Andreas Karlsson <andreas@proxel.se> writes:

 >> WITH ctename AS [[NOT] MATERIALIZED] (query)

 Andreas> I think "NOT MATERIALIZED" would be a bit misleading since the
 Andreas> planner may choose to materialize anyway,

It would certainly be possible to make an explicit NOT MATERIALIZED
override such a choice by the planner, or produce an error if it is
actually impossible to do so (e.g. using NOT MATERIALIZED on a wCTE)

-- 
Andrew (irc:RhodiumToad)




view thread (112+ messages)  latest in thread

Message-ID: <876010d4hi.fsf@news-spur.riddles.org.uk>
Permalink:  ../876010d4hi.fsf@news-spur.riddles.org.uk/
Also on:    postgresql.org/message-id/876010d4hi.fsf@news-spur.riddles.org.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: andrew@tao11.riddles.org.uk, andreas@proxel.se, nico@cryptonector.com, david@fetter.org
  Subject: Re: Early WIP/PoC for inlining CTEs
  In-Reply-To: <876010d4hi.fsf@news-spur.riddles.org.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox