Re: Index Ignored Due To Use Of View

"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