Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id 71A35475D24 for ; Tue, 9 Apr 2002 17:01:46 -0400 (EDT) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id RAA03035; Tue, 9 Apr 2002 17:01:44 -0400 X-Authentication-Warning: beamish.nsd.ca: smap set sender to using -f Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam) id xma003033; Tue, 9 Apr 02 17:01:35 -0400 Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148]) by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id RAA22555; Tue, 9 Apr 2002 17:01:35 -0400 Message-ID: <3CB356D8.48F8F5F4@nsd.ca> Date: Tue, 09 Apr 2002 17:02:16 -0400 From: Jean-Luc Lachance X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686) X-Accept-Language: en MIME-Version: 1.0 To: Rajesh Kumar Mallah Cc: PostgResql SQL Mailing List Subject: Re: Is there any Faster workaround ?? References: <3CB346F6.1DD7CFB9@trade-india.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/109 X-Sequence-Number: 7374 How about: DELETE from t_a where exist (select email from t_b where t_b.email = t_a.email) Rajesh Kumar Mallah wrote: > > Hi folks, > > We require to do below or similar quite often > > DELETE from t_a where email in (select email from t_b); > > everyone knows "IN" is pain fully slow currently in pgsql > is the any fster alternative to above query > > regds > Mallah. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org