Re: Wait free LW_SHARED acquisition
От | Bernd Helmle |
---|---|
Тема | Re: Wait free LW_SHARED acquisition |
Дата | |
Msg-id | 9079F8AA937E36317A72EFBF@apophis.credativ.lan обсуждение исходный текст |
Ответ на | Re: Wait free LW_SHARED acquisition (Andres Freund <andres@2ndquadrant.com>) |
Ответы |
Re: Wait free LW_SHARED acquisition
|
Список | pgsql-hackers |
--On 27. September 2013 09:57:07 +0200 Andres Freund <andres@2ndquadrant.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
В списке pgsql-hackers по дате отправления: