"David Johnston" <polobo@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
