Re: Really dumb planner decision - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Really dumb planner decision
Date
Msg-id 2f4958ff0904160348y4e05defam92b767ca396e0d70@mail.gmail.com
Whole thread Raw
In response to Really dumb planner decision  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: Really dumb planner decision
List pgsql-performance
On Thu, Apr 16, 2009 at 11:37 AM, Matthew Wakeling <matthew@flymine.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

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Really dumb planner decision
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Really dumb planner decision