| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: LONG delete with LOTS of FK's |
| Date: | 2013-05-09 21:23:07 |
| Message-ID: | b5eaafda5b69ca617440c7d7a7090bd3@webmail.lerctr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2013-05-09 16:22, Tom Lane wrote:
> 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
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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
--
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Thomas | 2013-05-09 21:26:49 | Re: LONG delete with LOTS of FK's |
| Previous Message | Larry Rosenman | 2013-05-09 21:22:22 | Re: LONG delete with LOTS of FK's |