On 10/12/2012 4:27 PM, Tom Lane wrote:
> 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
for10 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
>
Thanks for the feedback, Tom.
Those two settings remained at the defaults of 8 for both in both versions.
I did a quick google on the latter setting and found an ongoing discussion from back in 2011 involving increasing the
default,but your concern was that planner memory usage would escalate considerably by doing so. Given that information,
Iam inclined to ruminate on the query and boil it down to something simpler (less joins). Unless you think there is
valueto the greater good in determining what the underlying issue is, I won't bother creating a test case... at least
notuntil I spend some time trying to rework the thing.