Re: Performance degradation with CTEs, switching from PG 11 to PG 15 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Performance degradation with CTEs, switching from PG 11 to PG 15
Date
Msg-id 1696363.1700669248@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance degradation with CTEs, switching from PG 11 to PG 15  (Jean-Christophe Boggio <postgresql@thefreecat.org>)
List pgsql-performance
Jean-Christophe Boggio <postgresql@thefreecat.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



pgsql-performance by date:

Previous
From: Jean-Christophe Boggio
Date:
Subject: Re: Performance degradation with CTEs, switching from PG 11 to PG 15
Next
From: Jean-Christophe Boggio
Date:
Subject: Strange "actual time" in simple CTE