Re: IN surpasses NOT EXISTS in 7.4RC2 ?? - Mailing list pgsql-performance

From Robert Treat
Subject Re: IN surpasses NOT EXISTS in 7.4RC2 ??
Date
Msg-id 1068743982.10945.18510.camel@camel
Whole thread Raw
In response to Re: IN surpasses NOT EXISTS in 7.4RC2 ??  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: IN surpasses NOT EXISTS in 7.4RC2 ??
Next
From: Andrew Sullivan
Date:
Subject: strange estimate for number of rows