pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Is 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