Re: LWLock contention: I think I understand the problem

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>> It still seems that the select() blocking method should be a loser.

> No question the new locking code is better. It just frustrates me we
> can't get something to show that.

pgbench may not be the setting in which that can be shown. It's I/O
bound to start with, and it exercises some of our other weak spots
(viz duplicate-key checking). So I'm not really surprised that it's
not showing any improvement from 7.1 to 7.2.

But yeah, it'd be nice to get some cross-version comparisons on other
test cases.

regards, tom lane