Re: query from 9.0 fails to return on 9.2

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
10hours 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