Re: IN surpasses NOT EXISTS in 7.4RC2 ??

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: IN surpasses NOT EXISTS in 7.4RC2 ??
Дата
Msg-id 1068743982.10945.18510.camel@camel
обсуждение исходный текст
Ответ на Re: IN surpasses NOT EXISTS in 7.4RC2 ??  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Thu, 2003-11-13 at 12:00, Tom Lane wrote:
> Robert Treat <xzilla@users.sourceforge.net> writes:
> > Does the not exist query produce worse results in 7.4 than it did in
> > 7.3?
>
> EXISTS should work the same as before.
>

right. the original poster is asking if there is "something wrong with
exist" based on the comparison to IN, he needs to compare it vs. 7.3
EXISTS to determine if something is wrong.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: IN surpasses NOT EXISTS in 7.4RC2 ??
Следующее
От: Andrew Sullivan
Дата:
Сообщение: strange estimate for number of rows