Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-bugs-owner+M35470=pgsql+2Dbugs=arkaria.postgresql.org@postgresql.org>)
	id 1U9Huj-00009Z-3O
	for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Feb 2013 16:25:29 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-bugs-owner+M35470=pgsql+2Dbugs=arkaria.postgresql.org@postgresql.org>)
	id 1U9Hui-00069e-J2
	for pgsql-bugs@arkaria.postgresql.org; Sat, 23 Feb 2013 16:25:28 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1U9Huh-00069Y-OO
	for pgsql-bugs@postgresql.org; Sat, 23 Feb 2013 16:25:27 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1U9Hug-0000z7-3v
	for pgsql-bugs@postgresql.org; Sat, 23 Feb 2013 16:25:27 +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 r1NGPOdC002934;
	Sat, 23 Feb 2013 11:25:24 -0500 (EST)
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Janes <jeff.janes@gmail.com>
cc: Claude Speed <gta3user@gmail.com>,
	"pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Subject: Re: new BUG: "postgresql 9.2.3: very long query time"
In-reply-to: 
 <CAMkU=1xLiwDkfemkDWjznr_JmzUYbZzRZ4F22kXa3Vg6Pz9hCQ@mail.gmail.com>
References: <5124D2BE.5090001@gmail.com>
	<CAMkU=1wtFVHd9JQidMjANWkGQ3crrmWhgMOJ6OqD+80Dw=rhZA@mail.gmail.com>
	<5015.1361558088@sss.pgh.pa.us>
	<CAMkU=1xLiwDkfemkDWjznr_JmzUYbZzRZ4F22kXa3Vg6Pz9hCQ@mail.gmail.com>
Comments: In-reply-to Jeff Janes <jeff.janes@gmail.com>
	message dated "Sat, 23 Feb 2013 08:02:44 -0800"
Date: Sat, 23 Feb 2013 11:25:24 -0500
Message-ID: <2933.1361636724@sss.pgh.pa.us>
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-bugs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-bugs.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@postgresql.org>
List-Post: <mailto:pgsql-bugs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-bugs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
X-Mailing-List: pgsql-bugs
Precedence: bulk
Sender: pgsql-bugs-owner@postgresql.org

Jeff Janes <jeff.janes@gmail.com> writes:
> On Friday, February 22, 2013, Tom Lane wrote:
>> Try increasing from_collapse_limit to 11 or more.

> I've increased it to 20 and still no luck.

Huh --- that improved the results for me.

> I've stripped it down to this:

I'm not sure if that's exactly the same issue the OP is hitting, but
will take a look at it.  Thanks for the simpler test case.

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs