Postgres Pro
Downloads
Home   >   mailing lists

Re: delete is getting hung when there is a huge data in table - Mailing list pgsql-general

From David G. Johnston
Subject Re: delete is getting hung when there is a huge data in table
Date
Msg-id CAKFQuwaDzyAXCrCPbH9YaOhb_0=wXgEpyWHnTqZVaqWxdeRFwQ@mail.gmail.com
Whole thread Raw
In response to delete is getting hung when there is a huge data in table  (Mitu Verma <mitu.verma@ericsson.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: delete is getting hung when there is a huge data in table
Next
From: Uwe Schroeder
Date:
Subject: Re: delete is getting hung when there is a huge data in table