On Fri, Jan 18, 2019 at 3:42 PM Andres Freund <and...@anarazel.de> wrote: > On 2019-01-18 15:34:46 -0500, Robert Haas wrote: > > On Thu, Jan 17, 2019 at 10:48 AM Andreas Karlsson <andr...@proxel.se> wrote: > > > On 1/11/19 8:10 PM, Robert Haas wrote: > > > > WITH cte_name [[NOT] MATERIALIZED] AS (query) main_query... > > > > > > Hm, when would one want "NOT MATERIALIZED"? I am not sure I see the > > > usefulness of forcing inlining other than if we by default do not inline > > > when a CTE is referenced multiple times. > > > > When the planner materializes it, but the performance of the resulting > > plan therefore sucks, I suppose. > > > > I don't feel super-strongly about this, and Tom is right that there > > may be cases where materialization is just not practical due to > > implementation restrictions. > > *not* materializing I assume?
Right, sorry. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company