Re: LWLock contention: I think I understand the problem

> The results are shown in the attached plot.  Interesting, hmm?
> The "sweet spot" at 3 processes might be explained by assuming that
> pgbench itself chews up the fourth CPU.

To probe the theory, you could run pgbench on a different machine.

BTW, could you run the test with changing the number of CPUs? I'm
interested in how 7.2 is scale with # of processors.
--
Tatsuo Ishii