Feature request: limited deletions

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Feature request: limited deletions
Дата
Msg-id g2sbddc86151004080306g24e0407dxd55dc9a7c89cd575@mail.gmail.com
обсуждение исходный текст
Ответы Re: Feature request: limited deletions
Список pgadmin-hackers
I couldn't find any discussion on this, but the request is quite straightforward.  Implement a LIMIT on DELETE statements like SELECT statements.

So you could write:

DELETE FROM massive_table WHERE id < 40000000 LIMIT 10000;

This would allow deletions in smaller batches rather than waiting potentially hours for the server to mark all those rows as deleted and commit it as one massive transaction.

... although I suspect there will be reasons against this.

Thom

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

Предыдущее
От: Erwin Brandstetter
Дата:
Сообщение: Missing RULEs from VIEWs and their format
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: Feature request: limited deletions