[ADMIN] delete to slow

[Ricardo Valença de Assis]

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