Re: incomplete removal of not referenced CTEs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: incomplete removal of not referenced CTEs
Дата
Msg-id 2924.1472759205@sss.pgh.pa.us
обсуждение исходный текст
Ответ на incomplete removal of not referenced CTEs  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: incomplete removal of not referenced CTEs  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: incomplete removal of not referenced CTEs
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: System load consideration before spawning parallel workers