Re: Many processes blocked at ProcArrayLock! - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: Many processes blocked at ProcArrayLock!
Date
Msg-id CAMkU=1z9ojM-iqe_TmaOLWrHyo4OMOX8kd8EayD0L9-q8AeFJw@mail.gmail.com
Whole thread Raw
In response to Re: Many processes blocked at ProcArrayLock!  (zhangzq <z204126_maillist@163.com>)
List pgsql-bugs
On Mon, Jun 9, 2014 at 7:03 PM, zhangzq <z204126_maillist@163.com> wrote:

> 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).
>


You should upgrade to 9.3.4, it is an easy upgrade.  Also, 335
simultaneously active connections is just going to exacerbate the problem,
no matter what the root cause of the problem is.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Next
From: zsoros@gmail.com
Date:
Subject: BUG #10589: hungarian.stop file spelling error