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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
