Re: subselects vs WITH in views

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Joe Van Dyk *EXTERN*" <joe(at)tanga(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: subselects vs WITH in views
Date: 2013-02-19 09:02:39
Message-ID: A737B7A37273E048B164557ADEF4A58B057B501D@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Van Dyk wrote:
> My assumption was that WITH acted just like subselects, but apparently they don't? Using WITH doesn't
> use the expected index.

Currently WITH acts as an "optimization fence", that means
that means that the planner won't move conditions into or
out of the WITH query.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message david harel 2013-02-19 09:52:54 Terminate query on page exit
Previous Message Bastiaan Olij 2013-02-19 06:37:47 Connection with server dropping out