Re: [BUGS] Optimizer in 7.1.1 worse thatn 7.0.3

2001-05-25 Thread Tom Lane
[EMAIL PROTECTED] 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

[BUGS] Optimizer in 7.1.1 worse thatn 7.0.3

2001-05-25 Thread pgsql-bugs
Paul Wehr ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Optimizer in 7.1.1 worse thatn 7.0.3 Long Description While upgrading from 7.0.3 to 7.1.1, I found a particular query that was not being planned in the same way. The qu