Re: reducing the overhead of frequent table locks - now, with WIP patch

On 06.06.2011 14:59, Robert Haas wrote:
> BTW, how do you identify from oprofile that *vxid* locks were the
> problem?  I didn't think it could produce that level of detail.

It can show the call stack of each call, with --callgraph=n option, 
where you can see what percentage of the calls to LockAcquire come from 
VirtualXactLockTableInsert.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com