Search Postgresql Archives

Re: subselects vs WITH in views

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Feb 19, 2013 at 1:02 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:
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.

Where's the best place to read up on this?

Thanks,
Joe

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux