Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <zawadaa@wp.pl>) id 1TLFSc-0004FF-Gg
	for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 15:41:38 +0000
Received: from mx4.wp.pl ([212.77.101.8])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <zawadaa@wp.pl>) id 1TLFSa-0000G7-KS
	for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 15:41:37 +0000
Received: (wp-smtpd smtp.wp.pl 7287 invoked from network);
	8 Oct 2012 17:41:18 +0200
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wp.pl; s=1024a;
	t=1349710878; bh=OFlYQo9H/q7v8u3DYjhAZlXkVJeQGNot9amyiv50lGU=;
	h=From:To:CC:Subject;
	b=Nr3GF5Aq15sKM6k6Y7ytzB86jgh2BenRCA7GsgLT9F3hRN1i4SIH9/Q6ldTa0wF/K
	Q12/9Y3FQcJIPv6asEn1bLpn5S9kkyLUHzmahA7CqyvZQ9a7L1jzuQPX1Bk4GQonQ8
	yg2Igd7x5Kzts/Ce1HucfNM/elMQGDrVlD6Y/IBA=
Received: from bramka-zew.dfqs.pl (HELO [192.168.20.69])
	(zawadaa@[194.126.222.22]) (envelope-sender <zawadaa@wp.pl>)
	by smtp.wp.pl (WP-SMTPD) with CAMELLIA256-SHA encrypted SMTP
	for <pgsql-performance@postgresql.org>; 8 Oct 2012 17:41:18 +0200
Message-ID: <5072F41D.5010202@wp.pl>
Date: Mon, 08 Oct 2012 17:41:17 +0200
From: Andrzej Zawadzki <zawadaa@wp.pl>
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:15.0) Gecko/20120829 Icedove/15.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
CC: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
References: <50728C3E.9050904@wp.pl> <1077.1349707951@sss.pgh.pa.us>
In-Reply-To: <1077.1349707951@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A.
X-WP-SPAM: NO 0000000 [0WPE]                               
X-Pg-Spam-Score: -4.0 (----)
X-Archive-Number: 201210/48
X-Sequence-Number: 48007

On 08.10.2012 16:52, Tom Lane wrote:
> Andrzej Zawadzki <zawadaa@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