On 9 January 2013 17:50, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Wed, Jan 9, 2013 at 3:59 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> On 9 November 2012 18:50, Jeff Janes <jeff.janes@gmail.com> wrote:
>>
>>> quadratic behavior in the resource owner/lock table
>>
>> I didn't want to let that particular phrase go by without saying
>> "exactly what behaviour is that?", so we can discuss fixing that also.
>
> It is the thing that was fixed in commit eeb6f37d89fc60c6449ca1, "Add
> a small cache of locks owned by a resource owner in ResourceOwner."
> But that fix is only in 9.3devel.
That's good, it fixes the problem I reported in 2010, under
"SAVEPOINTs and COMMIT performance".
-- Simon Riggs http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services