Re: [HACKERS] CTE inlining

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] CTE inlining
Дата
Msg-id 23652.1493923066@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] CTE inlining  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> I'm not sure what your point is.  We know that for some cases the
> optimization barrier semantics are useful, which is why the proposal is
> to add a keyword to install one explicitely:

>          with materialized r as
>          (
>             select json_populate_record(null::mytype, myjson) as x
>             from mytable
>          )
>          select (x).*
>          from r;

> this would preserve the current semantics.

Uh, no, it wouldn't, until you had changed your query (and made it
non-SQL-compliant, and unable to work at all on pre-v11 PG).
This might be a good design, but surely it does not provide backwards
compatibility.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Reducing runtime of stats regression test
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: [HACKERS] CTE inlining