Re: Chaotic query planning ?

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

 



Albe Laurenz wrote

> […]
> Experiment with raising join_collapse_limit and from_collapse_limit to 11.

Thank you, this solve the problem.

> Alternatively, optimize the join order by hand and don't tune the parameters.

What is surprising is that there is no apparent/logical optimal strategy.

Best regards,
-- 
PI


-- 
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