Re: Early WIP/PoC for inlining CTEs - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: Early WIP/PoC for inlining CTEs
Date
Msg-id CAL9smLAxU2ZqnSt09g6Byk9UAdAsqazVXU3n4hyq2cxxJdaWpg@mail.gmail.com
Whole thread Raw
In response to Re: Early WIP/PoC for inlining CTEs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, Jan 26, 2019 at 12:22 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Therefore, I'm reversing my previous opinion that we should not have
an explicit NOT MATERIALIZED option.  I think we should add that, and
the behavior ought to be:

* No option given: inline if there's exactly one reference.

* With MATERIALIZED: never inline.

* With NOT MATERIALIZED: inline regardless of the number of references.

This much has been obvious to most people for a long time.


.m

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Early WIP/PoC for inlining CTEs
Next
From: Tom Lane
Date:
Subject: Race condition in crash-recovery tests