"David Johnston" <polobo@yahoo.com> writes:
> Now, if I simply replace the original FROM clause with the view definition
> (i.e., SELECT * FROM (SELECT ... ) alias WHERE ) I get:
> [ a different plan ]
> I now have index scans on both "filetaskinstance" and "filereference" - but
> all I appeared to do is the same as what rule re-writing should have done.
If you really just manually plugged in the view definition, then yeah
you should have gotten the same results. Could we see a complete test
case?
regards, tom lane