On 2013-05-09 16:22, Tom Lane wrote:
Larry Rosenman <ler@xxxxxxxxxx> 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@xxxxxxxxxx
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
