On 08.10.2012 16:52, Tom Lane wrote: > Andrzej Zawadzki <zawa...@wp.pl> 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 (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
