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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
