delete to slow

[Ricardo Valença de Assis <valenca@xxxxxxxxxxxxxxxx>]

Hello Everybody!

 

    I´m trying to use delete to remove data from one table based on another. The query is this:

 

    DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2);

 

    but my table is big, so it takes a lot o time...

    Is there a way to use DELETE with INNER JOIN in PostGreSQL?

 

Thanks!

 

Att.
Ricardo Valença
UEAD - UGF