Re: delete to slow - Mailing list pgsql-admin

On Wed, Apr 06, 2005 at 13:45:13 -0300,
  Ricardo Valença de Assis <valenca@campusvirtual.br> wrote:
> 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?

Yes. You should be able to do something like:
DELETE FROM table1 WHERE column1 = table2.column2;