Re: not in vs not exists - vastly diferent performance - Mailing list pgsql-sql

From Randolf Richardson
Subject Re: not in vs not exists - vastly diferent performance
Date
Msg-id Xns9462D1831D7E0rr8xca@200.46.204.72
Whole thread Raw
In response to not in vs not exists - vastly diferent performance  ("Iain" <iain@mst.co.jp>)
List pgsql-sql
"tgl@sss.pgh.pa.us (Tom Lane)" wrote in comp.databases.postgresql.sql:

> "Iain" <iain@mst.co.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@8x.ca
Vancouver, British Columbia, Canada

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


pgsql-sql by date:

Previous
From: treat00@yahoo.com (Thomas Reat)
Date:
Subject: "on insert" rules happen before the insert?
Next
From: Randolf Richardson
Date:
Subject: Re: Radius of a zip code