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

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