Bill MacArthur <webmaster(at)dhs-club(dot)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