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