Re: Performance degradation with CTEs, switching from PG 11 to PG 15

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Christophe Boggio <postgresql(at)thefreecat(dot)org>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Performance degradation with CTEs, switching from PG 11 to PG 15
Date: 2023-11-22 16:07:28
Message-ID: 1696363.1700669248@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jean-Christophe Boggio <postgresql(at)thefreecat(dot)org> writes:
> I did upgrade :-) But we have many users for which we don't decide on
> when they do upgrade so we have to keep compatibility with most versions
> of PG and in that particular case (non-existence of the materialized
> keyword for PG 11 and before) it is a real problem.

PG 11 is out of support as of earlier this month, so your users really
need to be prioritizing getting onto more modern versions.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-Christophe Boggio 2023-12-02 16:50:02 Strange "actual time" in simple CTE
Previous Message Jean-Christophe Boggio 2023-11-22 15:58:01 Re: Performance degradation with CTEs, switching from PG 11 to PG 15