Re: Poor performance using CTE - Mailing list pgsql-performance

From Tom Lane
Subject Re: Poor performance using CTE
Date
Msg-id 6038.1353517790@sss.pgh.pa.us
Whole thread Raw
In response to Re: Poor performance using CTE  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-performance
Claudio Freire <klaussfreire@gmail.com> writes:
> collapse_cte_limit?

The join collapse limits address a completely different problem (ie,
explosion of planning time with too many relations), and are pretty much
useless as a model for this.  As multiple people told you already,
optimization fences are typically wanted for only specific subqueries.

            regards, tom lane


pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Poor performance using CTE
Next
From: Joe Conway
Date:
Subject: Re: Hints (was Poor performance using CTE)