From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
---|---|
To: | Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Sv: Re: Sv: Re: CTE optimization fence |
Date: | 2018-06-27 09:54:33 |
Message-ID: | VisenaEmail.24.aff6251fef9d9dce.16440a8439b@tc7-visena |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
På onsdag 27. juni 2018 kl. 11:44:05, skrev Adrien NAYRAT <
adrien(dot)nayrat(at)anayrat(dot)info <mailto:adrien(dot)nayrat(at)anayrat(dot)info>>:
On 06/27/2018 09:58 AM, Andreas Joseph Krogh wrote:
> >
> > but we have to settle on a way of controlling it.
>
> +1 from me.
>
> I am running more and more into situations where people consider
> this a bug rather than a feature.
>
> FWIW, I think a GUC that switches between the current (mostly
> unwanted, at least surprising)
> way and one where the CTE is optimized together with the main query
> would suit "most" people.
>
> For sake of compatibility this could default to the current behaviour
>
> +1 from me. The default should be "no fence" for sake of least surprise
> I think. Documenting the change would be sufficient.
> I hope this will be picked up in the comming V12-cycle.
FYI this subject has been discussed in this thread :
https://www.postgresql.org/message-id/5351711493487900%40web53g.yandex.ru
Regards,
I know. I hate the INLINE proposal and hope default-behaviour will be like in
other DBs, inline like sub-query as default. GUC for preserving fence is what I
hope will happen.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2018-06-27 11:11:30 | Re: Code of Conduct committee: call for volunteers |
Previous Message | Adrien NAYRAT | 2018-06-27 09:44:05 | Re: Sv: Re: CTE optimization fence |