CTE Materialization - Mailing list pgsql-general

From Paul van der Linden
Subject CTE Materialization
Date
Msg-id CAEC-EqDkG=WB-RJ1cGKKJcgKw5END_3A=OdUsLR+xOLKKombDQ@mail.gmail.com
Whole thread Raw
Responses Re: CTE Materialization  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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,

Paul

PS please cc me when answering

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Issues cross-compiling libpq 14.x to MacOS armv8
Next
From: Tom Lane
Date:
Subject: Re: Require details that how to find user creation date in postgresql Database