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