Re: CTE Materialization

I beg your pardon.
The problem is more or less clear to me, but the solution is not. What does
the "hack is to add an "offset 0" to the query" suggest? Thank you.
--
Regards, Dmitry!

вт, 7 дек. 2021 г. в 10:20, Paul van der Linden <paul(dot)doskabouter(at)gmail(dot)com
>:

> It did indeed work as expected.
> Took the query down from over 18 hours to 20 minutes, so a huge win!
>
> Paul
>
> On Thu, Dec 2, 2021 at 11:34 PM David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Thursday, December 2, 2021, Paul van der Linden <
>> paul(dot)doskabouter(at)gmail(dot)com> wrote:
>>
>>> Hi,
>>>
>>> when switching to postgres 14 (from 11) I'm having some slow queries
>>> because of inlining of CTE's.
>>> I know I can get the same result as with PG11 when adding MATERIALIZED
>>> to the cte, but the same application also needs to be able to run on older
>>> postgres versions, so that is a no-go.
>>> Is there any other way that I can have materialized cte's in PG14 while
>>> still be compatible with older PG versions?
>>> Much appreciated,
>>>
>>
>> The usual anti-inlining hack is to add an “offset 0” to the query.
>> Haven’t tried it in 14 myself though.
>>
>> David J.
>>
>>
>