Re: Strange behavior after upgrade from 9.0 to 9.2

From: Andrzej Zawadzki <zawadaa(at)wp(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Strange behavior after upgrade from 9.0 to 9.2
Date: 2012-10-08 15:41:17
Message-ID: 5072F41D.5010202@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 08.10.2012 16:52, Tom Lane wrote:
> Andrzej Zawadzki <zawadaa(at)wp(dot)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.
>
Bingo! Thank you!
But... looks like in 9.0 this worked differently or option was skipped?
Because I had default settings of that options and query has worked fine.

--
Andrzej Zawadzki

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2012-10-08 15:56:27 Re: Strange behavior after upgrade from 9.0 to 9.2
Previous Message Navaneethan R 2012-10-08 15:26:19 Scaling 10 million records in PostgreSQL table