Re: LWLock contention: I think I understand the problem - Mailing list pgsql-hackers

From Tom Lane
Subject Re: LWLock contention: I think I understand the problem
Date
Msg-id 2992.1010120103@sss.pgh.pa.us
Whole thread Raw
In response to Re: LWLock contention: I think I understand the problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: shmctl portability problem
Next
From: Bruce Momjian
Date:
Subject: Re: LWLock contention: I think I understand the problem