On 08.10.2012 16:52, Tom Lane wrote: > Andrzej Zawadzki <[email protected]> writes: >> I have no idea whats wrong. Looks like planer bad decision. > [ counts... ] You've got nine base relations in that query. I think > you need to increase from_collapse_limit and/or join_collapse_limit. > Bingo! Thank you! But... looks like in 9.0 this worked differently or option was skipped? Because I had default settings of that options and query has worked fine.
-- Andrzej Zawadzki -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
