CTE Materialization

From: Paul van der Linden <paul(dot)doskabouter(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: CTE Materialization
Date: 2021-12-02 18:57:06
Message-ID: CAEC-EqDkG=WB-RJ1cGKKJcgKw5END_3A=OdUsLR+xOLKKombDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-12-02 22:21:10 Re: Require details that how to find user creation date in postgresql Database
Previous Message Tom Lane 2021-12-02 18:56:53 Re: Issues cross-compiling libpq 14.x to MacOS armv8