Re: Proposal of tunable fix for scalability of 8.4 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Proposal of tunable fix for scalability of 8.4
Date
Msg-id 29080.1236821556@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal of tunable fix for scalability of 8.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Proposal of tunable fix for scalability of 8.4
List pgsql-performance
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> I'm wondering about the testing methodology.

Me too.  This test case seems much too far away from real world use
to justify diddling low-level locking behavior; especially a change
that is obviously likely to have very negative effects in other
scenarios.  In particular, I think it would lead to complete starvation
of would-be exclusive lockers in the face of competition from a steady
stream of shared lockers.  AFAIR the existing behavior was designed
to reduce the odds of that, not for any other purpose.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
Next
From: Tom Lane
Date:
Subject: Re: Full statement logging problematic on larger machines?