Postgres Pro
Downloads
Home   >   mailing lists

DELETE FROM A BLACK LIST - Mailing list pgsql-sql

From luca.scaramella@recom.it
Subject DELETE FROM A BLACK LIST
Date
Msg-id OF6BDDE38E.3BA7C1BF-ONC1256CE0.003AEB80@recom.it
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Kim Petersen
Date:
Subject: Re: problematic query (for me ;-) [solved? - sorry to bother]
Next
From: luca.scaramella@recom.it
Date:
Subject: DELETE FROM A BLACK LIST