Re: DELETE performance problem

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: DELETE performance problem
Дата
Msg-id 200911240807.59452@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: DELETE performance problem  (Thom Brown <thombrown@gmail.com>)
Список pgsql-performance
On Tuesday 24 November 2009, Thom Brown <thombrown@gmail.com> wrote:
>
> It's a shame there isn't a LIMIT option on DELETE so this can be done in
> small batches.

delete from table where pk in (select pk from table where delete_condition
limit X);


--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: Strange performance degradation
Следующее
От: Matthew Wakeling
Дата:
Сообщение: RAID card recommendation