Re: incomplete removal of not referenced CTEs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: incomplete removal of not referenced CTEs
Date
Msg-id 2924.1472759205@sss.pgh.pa.us
Whole thread Raw
In response to incomplete removal of not referenced CTEs  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: incomplete removal of not referenced CTEs  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes:
> While investigating a CTE-related query, I've noticed that we don't
> really remove all unreachable CTEs.

We expend a grand total of three lines of code on making that happen.
I'm pretty much -1 on adding a great deal more code or complexity
to make it happen recursively; the case simply doesn't arise in
reasonably well written queries.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: incomplete removal of not referenced CTEs
Next
From: Gavin Flower
Date:
Subject: Re: System load consideration before spawning parallel workers