DELETE FROM A BLACK LIST

From: luca(dot)scaramella(at)recom(dot)it
To: pgsql-sql(at)postgresql(dot)org
Subject: DELETE FROM A BLACK LIST
Date: 2003-03-05 10:27:54
Message-ID: OFC425EC90.A6DA753C-ONC1256CE0.003861F2@recom.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,
I have a Blacklist table containing about 1000 ID to delete from another
table (T1 about 1440294 records)
If i use the SQL

DELETE FROM T1 WHERE T1.ID IN (SELECT BLACKLIST.ID FROM BLACKLIST)

the operation is very slow .

There is a faster way to do the same operation??

Thanks
Luca

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message luca.scaramella 2003-03-05 10:44:06 DELETE FROM A BLACK LIST
Previous Message Christoph Haller 2003-03-05 08:38:06 Re: Insert multiple Rows