"David Johnston" <pol...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
