Re: Advise about how to delete entries

Поиск
Список
Период
Сортировка
От Kevin
Тема Re: Advise about how to delete entries
Дата
Msg-id 431D77F5.4070307@drule.org
обсуждение исходный текст
Ответ на Re: Advise about how to delete entries  (Arnau <arnaulist@andromeiberica.com>)
Ответы Re: Advise about how to delete entries
Список pgsql-performance
Arnau wrote:

> Hi all,
>
> >
> >     COPY FROM a file with all the ID's to delete, into a temporary
> table, and  do a joined delete to your main table (thus, only one query).
>
>
>   I already did this, but I don't have idea about how to do this join,
> could you give me a hint ;-) ?
>
> Thank you very much

maybe something like this:

DELETE FROM statistics_sasme s
     LEFT JOIN temp_table t ON (s.statistic_id = t.statistic_id)
WHERE t.statistic_id IS NOT NULL


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

Предыдущее
От: "J. Andrew Rogers"
Дата:
Сообщение: Re: Postgresql Hardware - Recommendations
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Improving performance of a query