Hi,
On 2013-09-30 18:54:11 +0200, Bernd Helmle wrote:
> 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?
The only relevant setting changed was -c shared_buffers=1GB, no other
patches applied. At which scale did you pgbench -i?
Your processors are a different microarchitecture, I guess that could
also explain some of the difference. Any chance you could run a perf record -ag
(after compiling with -fno-omit-frame-pointer)?
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services