Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TLEh9-0005Gi-Hp
	for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 14:52:35 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1TLEh6-0007lQ-CK
	for pgsql-performance@postgresql.org; Mon, 08 Oct 2012 14:52:34 +0000
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q98EqVQe001078;
	Mon, 8 Oct 2012 10:52:31 -0400 (EDT)
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrzej Zawadzki <zawadaa@wp.pl>
cc: pgsql-performance@postgresql.org
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
In-reply-to: <50728C3E.9050904@wp.pl>
References: <50728C3E.9050904@wp.pl>
Comments: In-reply-to Andrzej Zawadzki <zawadaa@wp.pl>
	message dated "Mon, 08 Oct 2012 10:18:06 +0200"
Date: Mon, 08 Oct 2012 10:52:31 -0400
Message-ID: <1077.1349707951@sss.pgh.pa.us>
X-Pg-Spam-Score: -4.0 (----)
X-Archive-Number: 201210/47
X-Sequence-Number: 48006

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.

			regards, tom lane