On Thu, Apr 16, 2009 at 11:37 AM, Matthew Wakeling <matthew@xxxxxxxxxxx> wrote: > > I have a query that is executed really badly by Postgres. It is a nine table > join, where two of the tables are represented in a view. If I remove one of > the tables from the query, then the query runs very quickly using a > completely different plan. And what happens if you execute that view alone, with WHERE .. just like it would be a part of the whole query? ((id = 1267676)) -- GJ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
