Re: delete to slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: delete to slow
Дата
Msg-id 28471.1112808462@sss.pgh.pa.us
обсуждение исходный текст
Ответ на delete to slow  (Ricardo Valença de Assis <valenca@campusvirtual.br>)
Список pgsql-admin
=?iso-8859-1?Q?Ricardo_Valen=E7a_de_Assis?= <valenca@campusvirtual.br> writes:
>     DELETE FROM table1 WHERE column1 IN (SELECT column2 FROM table2);

What PG version is this, and what does EXPLAIN say about that query?

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

You could do "DELETE FROM table1 WHERE column1 = table2.column2" but
that is not necessarily better.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: delete to slow
Следующее
От: Ricardo Valença de Assis
Дата:
Сообщение: Re: delete to slow