Re: delete is getting hung when there is a huge data in table

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: delete is getting hung when there is a huge data in table
Дата
Msg-id CAKFQuwaDzyAXCrCPbH9YaOhb_0=wXgEpyWHnTqZVaqWxdeRFwQ@mail.gmail.com
обсуждение исходный текст
Ответ на delete is getting hung when there is a huge data in table  (Mitu Verma <mitu.verma@ericsson.com>)
Список pgsql-general
Дерево обсуждения
On Saturday, May 2, 2015, Mitu Verma <mitu.verma@ericsson.com> wrote:

still this delete operation is not working and not a single row has been deleted from the table.


Because of MVCC other sessions are not able to see partial deletions...and as you aluded to knowing the data itself is not actually removed by a deletion though a vacuum will eventually allow the same space to be reused thus deferring the increase in size from future insertions.

David J. 

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: delete is getting hung when there is a huge data in table
Следующее
От: Uwe Schroeder
Дата:
Сообщение: Re: delete is getting hung when there is a huge data in table