Postgres Pro
Downloads
Home   >   mailing lists

Re: reducing the overhead of frequent table locks - now, with WIP patch - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: reducing the overhead of frequent table locks - now, with WIP patch
Date
Msg-id 4DECC58C.3010202@enterprisedb.com
Whole thread Raw
In response to Re: reducing the overhead of frequent table locks - now, with WIP patch  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: WIP: Fast GiST index build
Next
From: Dimitri Fontaine
Date:
Subject: Re: Range Types and extensions