Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMlpz-0001XR-BK for pgsql-admin@postgresql.org; Fri, 12 Oct 2012 20:28:03 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMlpv-0002qb-7o for pgsql-admin@postgresql.org; Fri, 12 Oct 2012 20:28:02 +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 q9CKRp21021577; Fri, 12 Oct 2012 16:27:51 -0400 (EDT) From: Tom Lane To: Bill MacArthur cc: pgsql-admin@postgresql.org Subject: Re: query from 9.0 fails to return on 9.2 In-reply-to: <50786A75.5000601@dhs-club.com> References: <50786A75.5000601@dhs-club.com> Comments: In-reply-to Bill MacArthur message dated "Fri, 12 Oct 2012 15:07:33 -0400" Date: Fri, 12 Oct 2012 16:27:51 -0400 Message-ID: <21576.1350073671@sss.pgh.pa.us> X-Pg-Spam-Score: -4.0 (----) X-Archive-Number: 201210/40 X-Sequence-Number: 40156 Bill MacArthur writes: > Here is the top line of the *really long* explain as run on a 9.0 server (it takes only a couple of seconds to return): HashAggregate (cost=1148.97..1149.36 rows=1 width=205) > However, the same query run on the same machine after upgrade to 9.2.1 never returns. The query was sitting there for 10 hours unbeknownst to me. I'm wondering what values of join_collapse_limit & from_collapse_limit you're using on each machine. If it's not an oops-forgot-to-copy-the-configuration problem, you're going to need to put together a self-contained test case. regards, tom lane