Re: IN surpasses NOT EXISTS in 7.4RC2 ??

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: IN surpasses NOT EXISTS in 7.4RC2 ??
Date: 2003-11-13 17:19:42
Message-ID: 1068743982.10945.18510.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 2003-11-13 at 12:00, Tom Lane wrote:
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2003-11-13 18:14:15 strange estimate for number of rows
Previous Message Tom Lane 2003-11-13 17:00:10 Re: IN surpasses NOT EXISTS in 7.4RC2 ??