Re: not in vs not exists - vastly diferent performance

From: Randolf Richardson <rr(at)8x(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: not in vs not exists - vastly diferent performance
Date: 2004-01-01 04:48:37
Message-ID: Xns9462D1831D7E0rr8xca@200.46.204.72
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)" wrote in comp.databases.postgresql.sql:

> "Iain" <iain(at)mst(dot)co(dot)jp> writes:
>
>> I found this interesting and thought I'd offer it up for comment.
>
> You didn't say what PG version you are using, but I'd venture to bet
> it is pre-7.4.

This must've been one of the enhancements. =)

--
Sir Randolf, noble spam fighter - rr(at)8x(dot)ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Randolf Richardson 2004-01-01 04:56:24 Re: Radius of a zip code
Previous Message Adam Ruth 2003-12-31 22:46:17 Re: postgreSQL editors