Re: Further pg_upgrade analysis for many tables
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Magnus Hagander <magnus@hagander.net>
Date: 2013-01-09T19:32:59Z
Lists: pgsql-hackers
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