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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings