"John D. Burger" <[EMAIL PROTECTED]> writes: > Anecdotally, I had a situation recently where I got different plans > depending on whether I queried a join of a view against itself, or > "macro expanded" the view by hand. I was =very= surprised at this.
Me too, at least if you didn't do any hand optimization but just stuck the view definition in as a sub-select. Can you provide a reproducible case? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend