Re: Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions

From: Claus Stadler <cstadler(at)informatik(dot)uni-leipzig(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions
Date: 2012-03-19 10:42:00
Message-ID: 4F670D78.1030501@informatik.uni-leipzig.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Cool, thank you very much.

Cheers,
Claus

On 03/16/2012 06:17 PM, Tom Lane wrote:
> Claus Stadler<cstadler(at)informatik(dot)uni-leipzig(dot)de> writes:
>> Filtering a Union on constant custom type:
>> ...
>> Expected: Query optimizer should discard the scan as filter cannot be
>> satisfied.
> I've applied a patch for this. Thanks for the report!
>
> regards, tom lane
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2012-03-19 13:47:50 Re: Applicatin crashing with on postgresql 8.1 service restart
Previous Message Aren Cambre 2012-03-19 02:39:16 Re: BUG #6535: LEFT JOIN on large table is altering data