Re: Optimizer in 7.1.1 worse thatn 7.0.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Optimizer in 7.1.1 worse thatn 7.0.3
Date
Msg-id 14281.990830306@sss.pgh.pa.us
Whole thread Raw
In response to Optimizer in 7.1.1 worse thatn 7.0.3  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> I am hoping that there is a simple omission that keeps the optimizer
> from using the transitive literal.

PG doesn't compute transitive equality of literals, and never has AFAIK
(certainly 7.0.* didn't).  I'm not sure what's causing the change in
behavior from 7.0 to 7.1, but your theory about it is wrong.  Could you
make up a self-contained example?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Compilation fails --with-ssl on Solaris 8
Next
From: Justin Clift
Date:
Subject: Re: [GENERAL] Compilation fails --with-ssl on Solaris 8