On 08.10.2012 17:56, Tom Lane wrote: > Andrzej Zawadzki <zawadaa@xxxxx> writes: >> On 08.10.2012 16:52, Tom Lane wrote: >>> [ 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. > It looks like 9.0 wasn't flattening the EXISTS subqueries, so those > tables didn't count as relations of the main query. Thanks for explanation. Looks like now I can switch to 9.2.1 on production server. :-) -- Andrzej Zawadzki -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
