Received: from mailmtx.acnet.net (mailmtx.acnet.net [170.76.16.130]) by postgresql.org (Postfix) with ESMTP id 9A844476390 for ; Tue, 9 Apr 2002 16:19:46 -0400 (EDT) Received: from localhost.localdomain ([170.76.42.3]) by mailmtx.acnet.net (Post.Office MTA v3.5.3 release 223 ID# 0-52476U50000L50000S0V35) with ESMTP id net; Tue, 9 Apr 2002 15:18:39 -0500 Subject: Re: Is there any Faster workaround ?? From: David Stanaway To: Rajesh Kumar Mallah Cc: PostgResql SQL Mailing List In-Reply-To: <3CB346F6.1DD7CFB9@trade-india.com> References: <3CB346F6.1DD7CFB9@trade-india.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-rN0eEnHcY6W70PJ2E3RL" X-Mailer: Evolution/1.0.2 Date: 09 Apr 2002 15:19:18 -0500 Message-Id: <1018383583.5240.10.camel@debian> Mime-Version: 1.0 X-Archive-Number: 200204/108 X-Sequence-Number: 7373 --=-rN0eEnHcY6W70PJ2E3RL Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2002-04-09 at 14:54, Rajesh Kumar Mallah wrote: > Hi folks, >=20 > We require to do below or similar quite often >=20 > DELETE from t_a where email in (select email from t_b); >=20 > everyone knows "IN" is pain fully slow currently in pgsql > is the any fster alternative to above query >=20 DELETE from t_a where exists (select email from t_b where t_b.email =3D t_a.email); -- David Stanaway --=-rN0eEnHcY6W70PJ2E3RL Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iQEXAwUAPLNMxr6yIDFGeSAyFAI5DgQAsK7sGrYqi1ptmowKtRiGiG0Ug7dio4Pb iz1QnUgogB5+HGVYhrO7uU0CnMPAXE6BsG2MyLFnHg8EBolMnB8azaUAMw6rfZkI UTOL1GmkFbY4ROwY+f6CmtojVlmbJMukYILjuARnHnjaqmdOOa1U6OpFh10l2HJQ K85RmM4IOJMEAI/Wus7XfEvsOclzRpRzVDHILsOSHZ6TeH6/2DJ4bjNrTRjlFhtc rQFs0VSdVMQHMGOqUInZ9ZW9vXUuti5UOndv1EMHF6KSr8RPEwhUJ5xslXbFryPO hIShfGjQWysJa5sNVvVDgKvl/dM9DC36v9Uqc83KYkoOx5AvmPCE05a7 =mUQX -----END PGP SIGNATURE----- --=-rN0eEnHcY6W70PJ2E3RL--