Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange behavior after upgrade from 9.0 to 9.2 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Strange behavior after upgrade from 9.0 to 9.2
Date
Msg-id 1077.1349707951@sss.pgh.pa.us
Whole thread Raw
In response to Strange behavior after upgrade from 9.0 to 9.2  (Andrzej Zawadzki <zawadaa@wp.pl>)
Responses Re: Strange behavior after upgrade from 9.0 to 9.2
List pgsql-performance
Tree view 
Andrzej Zawadzki <zawadaa@wp.pl> writes:
> I have no idea whats wrong. Looks like planer bad decision.

[ counts... ]  You've got nine base relations in that query.  I think
you need to increase from_collapse_limit and/or join_collapse_limit.

            regards, tom lane

pgsql-performance by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [repost] Help me develop new commit_delay advice
Next
From: Andrzej Zawadzki
Date:
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2