On Thu, Apr 16, 2009 at 11:37 AM, Matthew Wakeling <matthew(at)flymine(dot)org> 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