Re: [GENERAL] Index Ignored Due To Use Of View

2011-02-25 Thread David Johnston
lains. David J. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane Sent: Friday, February 25, 2011 12:33 AM To: David Johnston Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Index Ignored Due To Use Of View

Re: [GENERAL] Index Ignored Due To Use Of View

2011-02-24 Thread Tom Lane
"David Johnston" 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