Mitu Verma <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general