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:44:06
Message-ID: OF6BDDE38E.3BA7C1BF-ONC1256CE0.003AEB80@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

Browse pgsql-sql by date

  From Date Subject
Next Message luca.scaramella 2003-03-05 10:45:25 DELETE FROM A BLACK LIST
Previous Message luca.scaramella 2003-03-05 10:27:54 DELETE FROM A BLACK LIST