Re: Why are we waiting?

On Wed, 2008-02-06 at 18:44 +0100, Staale Smedseng wrote:
> > What is the frequency distribution of lock wait time on ProcArrayLock?
> 
> See below for wait time distributions for ProcArrayLock (both shared and
> exclusive). The time measured is from entry into LWLockAcquire() until
> return. I've recorded the same data in two different resolutions (ms,
> and us for the lower part of the distribution). The DTrace script is at
> the bottom.
> 
> These results are for 1000 TPC-C like clients, and measured over the
> 1000 PostgreSQL processes over a period of 10 seconds.

Thanks! Interesting resonance pattern.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com