Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14588: Postgres process blocked on semop - Mailing list pgsql-bugs

From Andres Freund
Subject Re: [BUGS] BUG #14588: Postgres process blocked on semop
Date
Msg-id 20170312210312.5urq2djmdnf4rwlp@alap3.anarazel.de
Whole thread Raw
In response to Re: [BUGS] BUG #14588: Postgres process blocked on semop  (Neo Liu <diabloneo@gmail.com>)
Responses Re: [BUGS] BUG #14588: Postgres process blocked on semop
List pgsql-bugs
Tree view 
Hi,

On 2017-03-12 04:30:52 +0000, Neo Liu wrote:
> *The pstack screenshot*
> It shows two process's stack, one is pid 186397 who were in authentication,
> and the other is 188832 who where in INSERT.

This suggest you're having quite massive contention around
ProcArrayLock.  You should consider updating to 9.6. Several releases
since 9.2 considerably improved scalability around this (especially
9.6).

Regards,

Andres


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14588: Postgres process blocked on semop
Next
From: Venkata B Nagothi
Date:
Subject: Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)?