Re: Wait free LW_SHARED acquisition

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