Re: Really dumb planner decision

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2009/4/16 Matthew Wakeling <matthew@xxxxxxxxxxx>:
> On Thu, 16 Apr 2009, Grzegorz Jaśkiewicz wrote:
>>
>> 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))
>
> Really quick, just like the query that works in my email.

What happens if you change join_collapse_limit and from_collapse_limit
to some huge number?

http://www.postgresql.org/docs/current/static/runtime-config-query.html#GUC-FROM-COLLAPSE-LIMIT

...Robert

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux