On Tue, Mar 5, 2013 at 11:53 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Tue, Mar 5, 2013 at 3:44 PM, Tom Lane wrote:
>>> If "foo OR bar" is useful as an indexqual condition in the inner scan,
>>> that's one thing. But if it isn't, the cycles expended to check it in
>>> the inner scan are p
Robert Haas writes:
> On Tue, Mar 5, 2013 at 3:44 PM, Tom Lane wrote:
>> If "foo OR bar" is useful as an indexqual condition in the inner scan,
>> that's one thing. But if it isn't, the cycles expended to check it in
>> the inner scan are possibly wasted, because we'll still have to check
>> the
On Tue, Mar 5, 2013 at 3:44 PM, Tom Lane wrote:
> Well, the point is not so much about whether it's an improvement as that
> 9.2's current behavior is a regression from 9.1 and earlier. People may
> not like changes in minor releases, but they don't like regressions
> either.
That's true, but I'
Robert Haas writes:
> On Thu, Feb 28, 2013 at 3:03 PM, Tom Lane wrote:
>> Whichever way we go, the resulting patch is likely to be too large and
>> invasive for me to feel terribly comfortable about back-patching it into
>> 9.2. AFAICT this issue only arises for indexquals extracted out of
>> la
On 03/05/2013 12:33 AM, Robert Haas wrote:
> On Thu, Feb 28, 2013 at 3:03 PM, Tom Lane wrote:
>> Whichever way we go, the resulting patch is likely to be too large and
>> invasive for me to feel terribly comfortable about back-patching it into
>> 9.2. AFAICT this issue only arises for indexquals
On Thu, Feb 28, 2013 at 3:03 PM, Tom Lane wrote:
> Whichever way we go, the resulting patch is likely to be too large and
> invasive for me to feel terribly comfortable about back-patching it into
> 9.2. AFAICT this issue only arises for indexquals extracted out of
> larger OR conditions, so mayb
I looked into the behavior complained of in
http://www.postgresql.org/message-id/CAMkU=1xliwdkfemkdwjznr_jmzuybzzrz4f22kxa3vg6pz9...@mail.gmail.com
I'm still not sure whether anything else is going on in the original
problem, but I now understand Jeff's simplified query. The planner
does actually
