Re: Optimizer in 7.1.1 worse thatn 7.0.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Optimizer in 7.1.1 worse thatn 7.0.3
Дата
Msg-id 14281.990830306@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Optimizer in 7.1.1 worse thatn 7.0.3  (pgsql-bugs@postgresql.org)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [GENERAL] Compilation fails --with-ssl on Solaris 8
Следующее
От: Justin Clift
Дата:
Сообщение: Re: [GENERAL] Compilation fails --with-ssl on Solaris 8