Postgres Pro
Downloads
Home   >   mailing lists

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

From Claudio Freire
Subject Re: Poor performance using CTE
Date
Msg-id CAGTBQpa14GQ+L9KSKdS+kXVWYkoEVNUBbvaUpgRjskufEx-=-A@mail.gmail.com
Whole thread Raw
In response to Re: Poor performance using CTE  (Andres Freund <andres@anarazel.de>)
Responses Re: Poor performance using CTE
List pgsql-performance
Tree view 
On Wed, Nov 21, 2012 at 12:32 PM, Andres Freund <andres@anarazel.de> wrote:
> +1
>
> WITH foo AS (SELECT ...) (barrier=on|off)?
>
> 9.3 introduces the syntax, defaulting to on
> 9.4 switches the default to off.

Why syntax? What about a guc?

collapse_cte_limit?

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Hints (was Poor performance using CTE)
Next
From: Andres Freund
Date:
Subject: Re: Poor performance using CTE