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

From Noah Misch
Subject Re: reducing the overhead of frequent table locks - now, with WIP patch
Date
Msg-id 20110603181003.GA1222@tornado.leadboat.com
Whole thread Raw
In response to reducing the overhead of frequent table locks - now, with WIP patch  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Jun 03, 2011 at 09:17:08AM -0400, Robert Haas wrote:
> As you can see, this works out to a bit more than a 4% improvement on
> this two-core box.  I also got access (thanks to Nate Boley) to a
> 24-core box and ran the same test with scale factor 100 and
> shared_buffers=8GB.  Here are the results of alternating runs without
> and with the patch on that machine:
> 
> tps = 36291.996228 (including connections establishing)
> tps = 129242.054578 (including connections establishing)
> tps = 36704.393055 (including connections establishing)
> tps = 128998.648106 (including connections establishing)
> tps = 36531.208898 (including connections establishing)
> tps = 131341.367344 (including connections establishing)

Nice!


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Domains versus polymorphic functions, redux
Next
From: Merlin Moncure
Date:
Subject: Re: Streaming solution and v3.1 protocol