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