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)
Список
Дерево обсуждения
IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah <mallah@trade-india.com>
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Robert Treat <xzilla@users.sourceforge.net>
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Tom Lane <tgl@sss.pgh.pa.us>
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Robert Treat <xzilla@users.sourceforge.net>
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah <mallah@trade-india.com>
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Bruce Momjian <pgman@candle.pha.pa.us>
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Tom Lane <tgl@sss.pgh.pa.us>
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah <mallah@trade-india.com>
On Thu, 2003-11-13 at 12:00, Tom Lane wrote:
> Robert Treat 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 по дате отправления
