Re: LONG delete with LOTS of FK's

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: LONG delete with LOTS of FK's
Date: 2013-05-09 21:22:03
Message-ID: 6281.1368134523@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Larry Rosenman <ler(at)lerctr(dot)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

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2013-05-09 21:22:22 Re: LONG delete with LOTS of FK's
Previous Message Shaun Thomas 2013-05-09 21:20:32 Re: LONG delete with LOTS of FK's