Re: Many processes blocked at ProcArrayLock!

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Many processes blocked at ProcArrayLock!
Дата
Msg-id CAMkU=1z9ojM-iqe_TmaOLWrHyo4OMOX8kd8EayD0L9-q8AeFJw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Many processes blocked at ProcArrayLock!  (zhangzq <z204126_maillist@163.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Следующее
От: zsoros@gmail.com
Дата:
Сообщение: BUG #10589: hungarian.stop file spelling error