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:45:25
Message-ID: OF93BA7C2A.CBC03AC0-ONC1256CE0.003B13D5@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 Christoph Haller 2003-03-05 11:47:18 Re: SETOF
Previous Message luca.scaramella 2003-03-05 10:44:06 DELETE FROM A BLACK LIST