Horton

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

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>, pgsql-hackers@postgresql.org
Date: 2011-06-06T12:18:20Z
Lists: pgsql-hackers 
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