Re: User concurrency thresholding: where do I look?

Jignesh K. Shah wrote:

> Top Wait time   seems to come from the following code path for
> ProcArrayLock:
>
>             Lock Id            Mode           Count
>       ProcArrayLock       Exclusive              21
>
>             Lock Id   Combined Time (ns)
>       ProcArrayLock           5255937500
>
>             Lock Id   Combined Time (ns)
>
>
>              postgres`LWLockAcquire+0x1f0
>              postgres`CommitTransaction+0x104

Yeah, ProcArrayLock is pretty contended.  I think it would be kinda neat
if we could split it up in partitions.  This lock is quite particular
though.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support