| From: | Bernd Helmle <mailings(at)oopsware(dot)de> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Wait free LW_SHARED acquisition |
| Date: | 2013-09-30 16:54:11 |
| Message-ID: | 9079F8AA937E36317A72EFBF@apophis.credativ.lan |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
--On 27. September 2013 09:57:07 +0200 Andres Freund
<andres(at)2ndquadrant(dot)com> wrote:
> Ok, was free:
>
> padding + 16 partitions:
> tps = 147884.648416
>
> padding + 32 partitions:
> tps = 141777.841125
>
> padding + 64 partitions:
> tps = 141561.539790
>
> padding + 16 partitions + new lwlocks
> tps = 601895.580903 (yeha, still reproduces after some sleep!)
Hmm, out of interest and since i have access to a (atm) free DL580 G7 (4x
E7-4800 10core) i've tried your bench against this machine and got this
(best of three):
HEAD (default):
tps = 181738.607247 (including connections establishing)
tps = 182665.993063 (excluding connections establishing)
HEAD (padding + 16 partitions + your lwlocks patch applied):
tps = 269328.259833 (including connections establishing)
tps = 270685.666091 (excluding connections establishing)
So, still an improvement but far away from what you got. Do you have some
other tweaks in your setup?
--
Thanks
Bernd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2013-09-30 17:00:06 | Re: Wait free LW_SHARED acquisition |
| Previous Message | Alvaro Herrera | 2013-09-30 16:49:07 | Re: Minmax indexes |