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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: 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 14:25:11
Message-ID: 211a58a6-5741-a0a2-db97-0e79f75d9d4f@a-kretschmer.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Am 22.11.23 um 12:38 schrieb Jean-Christophe Boggio:
>
>
> Also, adding "materialized" to both "withcwrack" and "withcwrack0"
> CTEs gets the result in acceptable timings (a few seconds). The
> problem with this is that we have some clients with older versions of
> PG and I guess blindly adding the "materialized" keyword will cause
> errors.
>

yeah, prior to 11 CTEs are a optimizer barrier. You can try to rewrite
the queries to not using CTEs - or upgrade. If i were you i would upgrade.

Regards, Andreas

--
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-Christophe Boggio 2023-11-22 15:58:01 Re: Performance degradation with CTEs, switching from PG 11 to PG 15
Previous Message Jean-Christophe Boggio 2023-11-22 13:48:07 Re: Performance degradation with CTEs, switching from PG 11 to PG 15