| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: reducing the overhead of frequent table locks - now, with WIP patch |
| Date: | 2011-06-03 18:10:03 |
| Message-ID: | 20110603181003.GA1222@tornado.leadboat.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-06-03 18:19:04 | Re: Streaming solution and v3.1 protocol |
| Previous Message | Robert Haas | 2011-06-03 18:07:44 | Re: Domains versus polymorphic functions, redux |