Tom Lane wrote:
Those numbers look a bit suspicious --- I'd expect to see some of the LWLocks being taken in both shared and exclusive modes, but you don't show any such cases. You sure your script is counting correctly?
I'll double check to make sure no stupid mistakes were made!
Also, it'd be interesting to count time spent holding shared lock separately from time spent holding exclusive.
Will provide that data later today. Regards, -Robert