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. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
