Re: LONG delete with LOTS of FK's

On 2013-05-09 16:22, Tom Lane wrote:
> 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
all the locks were clear, and it was consuming CPU and doing I/O
(D->S->D state), etc.


--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-642-9640 (c)     E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893