From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bill MacArthur <webmaster@dhs-club.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: query from 9.0 fails to return on 9.2
Date: Fri, 12 Oct 2012 16:27:51 -0400
Message-ID: <21576.1350073671@sss.pgh.pa.us> (raw)
In-Reply-To: <50786A75.5000601@dhs-club.com>
References: <50786A75.5000601@dhs-club.com>
Bill MacArthur <webmaster@dhs-club.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, webmaster@dhs-club.com
Subject: Re: query from 9.0 fails to return on 9.2
In-Reply-To: <21576.1350073671@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox