Postgres Pro
Downloads
Home   >   mailing lists

Re: LONG delete with LOTS of FK's - Mailing list pgsql-general

From Tom Lane
Subject Re: LONG delete with LOTS of FK's
Date
Msg-id 6281.1368134523@sss.pgh.pa.us
Whole thread Raw
In response to Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
Responses Re: LONG delete with LOTS of FK's  (Larry Rosenman <ler@lerctr.org>)
List pgsql-general
Tree view 
Larry Rosenman <ler@lerctr.org> writes:
>> Ideas on how to debug?

Perhaps it's blocked on a lock?  Did you look into pg_locks?
Did you note whether the process was consuming CPU time and/or doing IO?

            regards, tom lane

pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: LONG delete with LOTS of FK's
Next
From: Larry Rosenman
Date:
Subject: Re: LONG delete with LOTS of FK's