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