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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mitu Verma <mitu(dot)verma(at)ericsson(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org' (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: delete is getting hung when there is a huge data in table
Date: 2015-05-03 04:13:13
Message-ID: 32691.1430626393@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mitu Verma <mitu(dot)verma(at)ericsson(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-05-03 05:28:35 Re: delete is getting hung when there is a huge data in table
Previous Message Mitu Verma 2015-05-03 03:24:25 delete is getting hung when there is a huge data in table