Re: Many processes blocked at ProcArrayLock!

hi,
thanks.
my version is 9.3.2.
there were 221 processes blocked at "commit", and 114 processes blocked at "insert". (,found it by ps command).

在 2014-06-09 11:57:35，"Jeff Janes" <jeff(dot)janes(at)gmail(dot)com> 写道：

On Mon, Jun 9, 2014 at 2:52 AM, zhangzq <z204126_maillist(at)163(dot)com> wrote:

hello,
My many processes is blocked, and can't login, I dump the call stack by pstack, and found these processes is blocked at: LWLockAcquire(ProcArrayLock, LW_EXCLUSIVE),
Who have encountered this situation?
thanks!

What version? This may be an issue fixed in 9.3.4, 9.2.8, 9.1.13, 9.0.17, see commit 00283cae1b78174e27b39c and siblings. Do you have a lot of inserted but not yet committed tuples?