rtLock Exclusive 17941476941
ProcArrayLock Shared 31114676303
ProcArrayLock Exclusive 888356047549
Regards,
Staale Smedseng
Database Technology Group, Sun Microsystems
---(end of broadcast)---
TIP 6: explain analyze is your friend
> 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
I'm not sure 32-bit and 64-bit cases are going to be directly
comparable. We
could have a problem with cache line aliasing on only one or the
other for
example.
Agreed, this is likely comparing apples and oranges. I'll see if I can
get a one-to-one comparison done (these were the numbers I
On Thu, 2008-02-07 at 18:12, Simon Riggs wrote:
> I just realised you are using a lookup to get the text for the name of
> the lock. You used the same lookup table for both releases?
Oh, it wasn't quite that bad. :-) The two DTrace scripts had been
revised to correspond with the two different dec
On Wed, 2008-02-06 at 19:55, Tom Lane wrote:
> I am wondering if the waits are being
> attributed to the right locks --- I remember such an error in a previous
> set of dtrace results, and some of the other details such as claiming
> shared lock delays but no exclusive lock delays for FirstLockMgrL
