Sv: Re: Early WIP/PoC for inlining CTEs

Andreas Joseph Krogh <andreas@visena.com>

From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2019-02-02T21:42:31Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Prevent inlining of multiply-referenced CTEs with outer recursive refs.

  2. Allow user control of CTE materialization, and change the default behavior.

  3. Split QTW_EXAMINE_RTES flag into QTW_EXAMINE_RTES_BEFORE/_AFTER.

  4. document when PREPARE uses generic plans

På lørdag 02. februar 2019 kl. 20:01:01, skrev Tom Lane <tgl@sss.pgh.pa.us 
<mailto:tgl@sss.pgh.pa.us>>: [snip]
 There's nothing particularly stopping us from accepting
 "materialized" with a D in this syntax, instead of or in addition
 to "materialize"; though I hesitate to mention it for fear of
 another round of bikeshedding.   +1 for keeping it "imperative-style" 
– MATERIALIZE – consistent with other SQL-stuff.   --
 Andreas Joseph Krogh