From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
Cc: | PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Thank you ! Re: Is there any Faster workaround ?? |
Date: | 2002-04-09 21:32:41 |
Message-ID: | 3CB35DF8.D26E2055@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Thanks so much!
i think this ques. has been answered before also in
this mailing list sorry for asking...
regds
mallah.
Jean-Luc Lachance wrote:
> 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(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah | 2002-04-09 21:46:34 | new problem! Is there any Faster workaround ?? |
Previous Message | Jean-Luc Lachance | 2002-04-09 21:02:16 | Re: Is there any Faster workaround ?? |