Bill MacArthur <[email protected]> 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
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
