On Thursday, December 2, 2021, Paul van der Linden < paul.doskabou...@gmail.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.
