Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: delete is getting hung when there is a huge data in table
Date
Msg-id 32691.1430626393@sss.pgh.pa.us
Whole thread Raw
In response to delete is getting hung when there is a huge data in table  (Mitu Verma <mitu.verma@ericsson.com>)
Responses Re: delete is getting hung when there is a huge data in table
List pgsql-general
Tree view 
Mitu Verma <mitu.verma@ericsson.com> writes:
> 1. If postgreSQL has some limitations for deletion of large data?

Not as such, but you've not given us any details that would permit
comment.

A reasonably likely bet is that this table is referenced by a foreign key
in some other table, and that other table has no index on the referencing
column.  That would make the FK is-it-ok-to-delete checks very slow.

            regards, tom lane

pgsql-general by date:

Previous
From: Mitu Verma
Date:
Subject: delete is getting hung when there is a huge data in table
Next
From: "David G. Johnston"
Date:
Subject: Re: delete is getting hung when there is a huge data in table