pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIs there any Faster workaround ??
3+ messages / 3 participants
[nested] [flat]
* Is there any Faster workaround ??
@ 2002-04-09 19:54 Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-09 20:19 ` Re: Is there any Faster workaround ?? David Stanaway <david@stanaway.net>
2002-04-09 21:02 ` Re: Is there any Faster workaround ?? Jean-Luc Lachance <jllachan@nsd.ca>
0 siblings, 2 replies; 3+ messages in thread
From: Rajesh Kumar Mallah @ 2002-04-09 19:54 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Is there any Faster workaround ??
2002-04-09 19:54 Is there any Faster workaround ?? Rajesh Kumar Mallah <mallah@trade-india.com>
@ 2002-04-09 20:19 ` David Stanaway <david@stanaway.net>
1 sibling, 0 replies; 3+ messages in thread
From: David Stanaway @ 2002-04-09 20:19 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-sql
On Tue, 2002-04-09 at 14:54, 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
>
DELETE from t_a where exists (select email from t_b where t_b.email =
t_a.email);
--
David Stanaway
Attachments:
signature.asc (application/pgp-signature, 523B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Is there any Faster workaround ??
2002-04-09 19:54 Is there any Faster workaround ?? Rajesh Kumar Mallah <mallah@trade-india.com>
@ 2002-04-09 21:02 ` Jean-Luc Lachance <jllachan@nsd.ca>
1 sibling, 0 replies; 3+ messages in thread
From: Jean-Luc Lachance @ 2002-04-09 21:02 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-04-09 21:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-09 19:54 Is there any Faster workaround ?? Rajesh Kumar Mallah <mallah@trade-india.com>
2002-04-09 20:19 ` David Stanaway <david@stanaway.net>
2002-04-09 21:02 ` Jean-Luc Lachance <jllachan@nsd.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox