Quick Links

Is there any Faster workaround ??

From:	Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To:	PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject:	Is there any Faster workaround ??
Date:	2002-04-09 19:54:30
Message-ID:	3CB346F6.1DD7CFB9@trade-india.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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.

Responses

Re: Is there any Faster workaround ?? at 2002-04-09 20:19:18 from David Stanaway
Re: Is there any Faster workaround ?? at 2002-04-09 21:02:16 from Jean-Luc Lachance
new problem! Is there any Faster workaround ?? at 2002-04-09 21:46:34 from Rajesh Kumar Mallah

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Isaac Mesa Florez	2002-04-09 20:16:53	Help To Out
Previous Message	Michael Teter	2002-04-09 19:48:16	Yes! Thank you!